API para criar cliente – perfil e conta

Neste post irei mostrar uma API para criar o cadastro do cliente. DECLARE custAcccountRec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; custProfileRec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE; custOrgRec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE; custPartyRec HZ_PARTY_V2PUB.PARTY_REC_TYPE; x_cust_account_id NUMBER; x_account_number VARCHAR2 (30); x_party_id NUMBER; x_party_number VARCHAR2 (30); x_profile_id NUMBER; x_return_status VARCHAR2 (3); x_msg_count NUMBER; x_msg_data VARCHAR2 (3000); l_collector_id NUMBER; BEGIN DBMS_OUTPUT.PUT_LINE ('In createCustomer Procedure.'); mo_global.init ('AR'); fnd_global.apps_initialize (user_id => 26801, resp_id... Continuar Lendo →

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 →

Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren

Acima ↑