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 →

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 ↑