52:
53: --------
54: -- invoice api
55: --------
56: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
57: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
58: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
59: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
60: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
53: --------
54: -- invoice api
55: --------
56: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
57: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
58: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
59: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
60: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
61: iv_create_flag VARCHAR2(1) := 'N';
54: -- invoice api
55: --------
56: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
57: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
58: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
59: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
60: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
61: iv_create_flag VARCHAR2(1) := 'N';
62: iv_header_cpt NUMBER := 0;
55: --------
56: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
57: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
58: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
59: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
60: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
61: iv_create_flag VARCHAR2(1) := 'N';
62: iv_header_cpt NUMBER := 0;
63: iv_line_cpt NUMBER := 0;
56: iv_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
57: iv_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
58: iv_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
59: iv_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
60: iv_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
61: iv_create_flag VARCHAR2(1) := 'N';
62: iv_header_cpt NUMBER := 0;
63: iv_line_cpt NUMBER := 0;
64: iv_dist_cpt NUMBER := 0;
70:
71: -------------
72: -- Recycle
73: -------------
74: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
75: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
71: -------------
72: -- Recycle
73: -------------
74: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
75: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
72: -- Recycle
73: -------------
74: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
75: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
73: -------------
74: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
75: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
74: nl_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type;
75: nl_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type;
76: nl_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type;
77: nl_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
78: nl_batch_source_rec ar_invoice_api_pub.batch_source_rec_type;
79: nl_INTEREST_HEADER_ID DBMS_SQL.NUMBER_TABLE;
80: nl_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
81: nl_HEADER_TYPE DBMS_SQL.VARCHAR2_TABLE;
82: nl_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: --
785: -- Execution of the invoice api
786: --
787: AR_INVOICE_API_PUB.create_invoice(
788: p_api_version => 1.0,
789: x_return_status => x_return_status,
790: x_msg_count => x_msg_count,
791: x_msg_data => x_msg_data,