Hi, in this post I will show how create and update records on list price at API. DECLARE l_return_status VARCHAR2 (20); x_return_status VARCHAR2 (20); l_error_data VARCHAR2 (20000); l_error_message VARCHAR2 (20000); l_msg_count NUMBER; l_msg_data VARCHAR2 (20000); l_err_count NUMBER; i NUMBER; l_price_list_rec qp_price_list_pub.price_list_rec_type; l_price_list_val_rec qp_price_list_pub.price_list_val_rec_type; l_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type; l_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type; l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type; l_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type; l_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type; l_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type;... Continuar Lendo →
Create or Update Category Codes
Hi, this post I will show how to create or update category_codes on Inventory Category. Create DECLARE v_return_status VARCHAR2(1) := NULL; v_msg_count NUMBER := 0; v_msg_data VARCHAR2(2000); v_errorcode VARCHAR2(1000); l_category_rec INV_ITEM_CATEGORY_PUB.category_rec_type; x_category_id NUMBER; v_context VARCHAR2 (2); l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2(1000); BEGIN fnd_global.apps_initialize (1139, 20634, 401); l_category_rec.structure_id := 50412; l_category_rec.segment1 := 'Milton'; l_category_rec.description :=... Continuar Lendo →
API to create transacions on Oracle Receivables
Hi, this post I will show how to create transactions on Oracle Receivables at API. DECLARE l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type; l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type; l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type; l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type; l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type; l_cust_trx_id NUMBER; v_trx_header_Id NUMBER; v_trx_line_id NUMBER; BEGIN SELECT ra_customer_trx_s.NEXTVAL INTO v_trx_header_Id FROM DUAL; SELECT ra_customer_trx_lines_s.NEXTVAL INTO v_trx_line_id FROM DUAL; MO_GLOBAL.SET_POLICY_CONTEXT('S',81); MO_GLOBAL.set_org_context (81, NULL,... Continuar Lendo →
Atualizar informações de campos das distribuições
Nesse post irei mostrar como é possível atualizar informações das entregas via API, essa alternativa pode ajudar quando há integrações e o procedimento é feito por um outro sistema sem precisar entrar na tela das distribuições. DECLARE x_delivery_info WSH_DELIVERIES_PUB.delivery_pub_rec_type; x_return_status VARCHAR2 (10); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); x_msg_details VARCHAR2 (3000); x_msg_summary VARCHAR2 (3000); x_del_id NUMBER;... Continuar Lendo →
API para submeter para aprovação a OC
Nesse post irei mostrar uma API para submeter para aprovação uma ordem de compra via API. Crie uma Ordem de Compra 2. Rode o script abaixo DECLARE v_item_key VARCHAR2 (100); l_result NUMBER; lv_request_id NUMBER; v_phase VARCHAR2(4000); v_status VARCHAR2(4000); v_dev_phase VARCHAR2(4000); v_dev_status VARCHAR2(4000); v_message VARCHAR2(4000); CURSOR c_po_details IS SELECT pha.po_header_id, pha.org_id, pha.segment1, pha.agent_id, pdt.document_subtype, pdt.document_type_code, pha.authorization_status... Continuar Lendo →
Creating / Updating costs by Interface
In this article I will show how to create cost records by Interface. Many companies need to replicate their costs to other organizations. This is due to the fact that its components or assemblies are manufactured in more than one organization. Oracle provides a request that copies costs to other organizations. But sometimes the company... Continuar Lendo →
API Create Reservations
In This Post I want to show how create a reservations using API Oracle Some times it's necessary to use API for work with integrations. The script below can be used for create a reservation. DECLARE l_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_new_rsv_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE; l_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_new_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; x_serial_number INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE; l_api_version NUMBER := 1.0; l_init_msg_list VARCHAR2 (2) := FND_API.G_TRUE;... Continuar Lendo →