Apply and release Hold on Payables workbench at API

Hi, this post I will show how to apply and release a hold on workbench in payables. DECLARE v_rowid ROWID; v_hold_id NUMBER := NULL; BEGIN mo_global.set_policy_context('S', 81); FOR C IN ( SELECT hold, reason, hold_lookup_code FROM ap_holds_hold_name_v WHERE hold_lookup_code = 'RET. PAGAMENTO' ) LOOP AP_HOLDS_PKG.Insert_Row(x_rowid => v_rowid, x_hold_id => v_hold_id, x_invoice_id => 155074, x_line_location_id =>... Continuar Lendo →

Cancelar NFF Contas a pagar via API

Olá, neste post irei mostrar como cancelar uma nota fiscal no contas a pagar via API. declare v_invoice_id number; v_last_updated_by varchar2(20); v_last_update_login varchar2(20); v_accounting_date date := sysdate; v_boolean boolean; v_error_code varchar2(100); v_debug_info varchar2(1000); v_message_name varchar2(1000); v_invoice_amount number; v_base_amount number; v_tax_amount number; v_temp_cancelled_amount number; v_cancelled_by varchar2(1000); v_cancelled_amount number; v_cancelled_date date; v_last_update_date date; v_token varchar2(100); v_orig_prepay_amt number;... Continuar Lendo →

Criar Fornecedores via API

Nesse post irei mostrar como criar um fornecedor via API. declare p_api_version number; p_init_msg_list varchar2(200); p_commit varchar2(200); p_validation_level number; x_return_status varchar2(200); x_msg_count number; x_msg_data varchar2(200); l_msg varchar2(200); lr_vend apps.ap_vendor_pub_pkg.r_vendor_rec_type; lr_ex_vend ap_suppliers%rowtype; x_vendor_id number; x_party_id number; pin_copy_vendor_id number; begin -- Initialize apps session fnd_global.apps_initialize(1139, 50833, 200); mo_global.init('SQLAP'); fnd_client_info.set_org_context(101); -- Assign Basic Values p_api_version := 1.0; p_init_msg_list... Continuar Lendo →

Atualizar informações de fornecedor

Nesse post irei colocar uma API pública onde é possível atualizar informações do cadastro dos fornecedores. DECLARE p_api_version NUMBER; p_init_msg_list VARCHAR2(200); p_commit VARCHAR2(200); p_validation_level NUMBER; x_return_status VARCHAR2(200); x_msg_count NUMBER; x_msg_data VARCHAR2(200); lr_vendor_rec apps.ap_vendor_pub_pkg.r_vendor_rec_type; lr_existing_vendor_rec ap_suppliers%ROWTYPE; l_msg VARCHAR2(200); p_vendor_id NUMBER; BEGIN fnd_global.apps_initialize(1234, 50833, 200); mo_global.init('SQLAP'); fnd_client_info.set_org_context(101); p_api_version := 1.0; p_init_msg_list := fnd_api.g_true; p_commit := fnd_api.g_true; p_validation_level... Continuar Lendo →

Powered by por Anders Noren

Acima ↑