API to create Receipt on Oracle Receivables

This post I will show a API to create a receipt on oracle Receivables. DECLARE l_error_description VARCHAR2 (2000) := NULL; l_ar_receipt_succ_count NUMBER:= 0; l_ar_receipt_err_count NUMBER:= 0; l_ar_receipt_tot_count NUMBER:= 0; l_msg_index_num NUMBER:= 1; l_msg_count NUMBER; l_data_txt VARCHAR2(1000); l_msg_data VARCHAR2(1000); l_apl_return_status VARCHAR2 (1); l_apl_msg_count NUMBER; l_apl_msg_data VARCHAR2 (240); l_org_id NUMBER; l_gl_date_count NUMBER; l_functional_currency fnd_currencies.currency_code%TYPE; l_conv_type gl_daily_conversion_types.conversion_type%TYPE; l_conv_rate... Continuar Lendo →

Oracle FNDLOAD scripts

Segue abaixo os exemplos de fndload tanto para upload quanto para download de arquivos do EBS. 1. Lookups -- ------------- FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE 2. Concurrent Program -- ----------------------------- FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM" FNDLOAD... 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 WordPress.com. Tema: Baskerville 2 por Anders Noren

Acima ↑