55: iv_CUST_ACCT_SITE_ID DBMS_SQL.NUMBER_TABLE;
56: --------
57: -- invoice api
58: --------
59: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
60: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
61: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
62: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
63: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
56: --------
57: -- invoice api
58: --------
59: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
60: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
61: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
62: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
63: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
64: iv_create_flag VARCHAR2(1) := 'N';
57: -- invoice api
58: --------
59: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
60: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
61: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
62: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
63: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
64: iv_create_flag VARCHAR2(1) := 'N';
65: iv_header_cpt NUMBER := 0;
58: --------
59: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
60: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
61: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
62: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
63: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
64: iv_create_flag VARCHAR2(1) := 'N';
65: iv_header_cpt NUMBER := 0;
66: iv_line_cpt NUMBER := 0;
59: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
60: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
61: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
62: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
63: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
64: iv_create_flag VARCHAR2(1) := 'N';
65: iv_header_cpt NUMBER := 0;
66: iv_line_cpt NUMBER := 0;
67: iv_dist_cpt NUMBER := 0;
73:
74: -------------
75: -- Recycle
76: -------------
77: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
78: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
79: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
80: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
81: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
74: -------------
75: -- Recycle
76: -------------
77: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
78: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
79: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
80: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
81: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
75: -- Recycle
76: -------------
77: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
78: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
79: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
80: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
81: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
76: -------------
77: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
78: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
79: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
80: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
81: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
77: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
78: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
79: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
80: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
81: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
82: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
83: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
84: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
85: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
807: --
808: -- Execution of the invoice api
809: --
810: ar_late_charge_pkg.g_invoice_api_called_from_lc := 'Y';
811: AR_INVOICE_API_PUB.create_invoice(
812: p_api_version => 1.0,
813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,
815: x_msg_data => x_msg_data,