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 →
Aplicar modificador a uma ordem de venda existente
Nesse post irei mostrar como aplicar um modificador a uma ordem de venda existente via API. Execute o script abaixo para criar o modificador DECLARE l_header_rec OE_ORDER_PUB.Header_Rec_Type; l_line_tbl OE_ORDER_PUB.Line_Tbl_Type; l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type; l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type; l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type; l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type; l_request_rec OE_ORDER_PUB.Request_Rec_Type; l_return_status VARCHAR2 (1000); l_msg_count NUMBER; l_msg_data VARCHAR2 (1000); p_api_version_number NUMBER := 1.0; p_init_msg_list VARCHAR2... Continuar Lendo →
Criar Percurso via API
Nesse post irei mostrar como criar percurso/distribuição via API Execute o script abaixo para criar o percurso e distribuição ao mesmo tempo DECLARE lv_return_status VARCHAR2 (1); ln_msg_count NUMBER; lv_msg_data VARCHAR2 (400); ln_trip_id VARCHAR2 (20); lv_trip_name VARCHAR2 (30); l_line_tbl WSH_UTIL_CORE.id_tab_type; l_del_rows_tbl WSH_UTIL_CORE.id_tab_type; i NUMBER := 1; l_msg_index_out NUMBER; CURSOR cur_trip IS SELECT delivery_detail_id FROM wsh_delivery_details a,... Continuar Lendo →
Criar requisições de compra/interna via interface
Olá, segue abaixo um exemplo de código para criar requisição de compra/interna. INSERT INTO po_requisitions_interface_all (interface_source_code, source_type_code, requisition_type, destination_type_code, item_segment1, item_description, quantity, authorization_status, preparer_id, autosource_flag, uom_code, destination_organization_id, destination_subinventory, deliver_to_location_id, deliver_to_requestor_id, need_by_date, gl_date, charge_account_id, accrual_account_id, variance_account_id, org_id, suggested_vendor_id, suggested_vendor_site_id, unit_price, creation_date, created_by, last_update_date, last_updated_by) VALUES ('INV', 'VENDOR', 'PURCHASE', 'INVENTORY', '887788', 'Teste importação de item', 1, 'INCOMPLETE',... 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 →
Importing bills at Interface
In this article I will demonstrate how to import a structure via Interface. Many companies face the difficulty of creating structures because of the volume of data. In this case there is possibility of using the oracle interface to give this help, with a little knowledge in sql and pl / sql you can do... Continuar Lendo →