2: /* $Header: ARINGTTB.pls 120.10 2007/06/21 21:04:13 mraymond ship $ */
3: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
4:
5: PROCEDURE INSERT_ROWS (
6: p_trx_header_tbl IN AR_INVOICE_API_PUB.trx_header_tbl_type,
7: p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
8: p_trx_dist_tbl IN AR_INVOICE_API_PUB.trx_dist_tbl_type,
9: p_trx_salescredits_tbl IN AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
10: x_errmsg OUT NOCOPY VARCHAR2,
3: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
4:
5: PROCEDURE INSERT_ROWS (
6: p_trx_header_tbl IN AR_INVOICE_API_PUB.trx_header_tbl_type,
7: p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
8: p_trx_dist_tbl IN AR_INVOICE_API_PUB.trx_dist_tbl_type,
9: p_trx_salescredits_tbl IN AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
10: x_errmsg OUT NOCOPY VARCHAR2,
11: x_return_status OUT NOCOPY VARCHAR2
4:
5: PROCEDURE INSERT_ROWS (
6: p_trx_header_tbl IN AR_INVOICE_API_PUB.trx_header_tbl_type,
7: p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
8: p_trx_dist_tbl IN AR_INVOICE_API_PUB.trx_dist_tbl_type,
9: p_trx_salescredits_tbl IN AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
10: x_errmsg OUT NOCOPY VARCHAR2,
11: x_return_status OUT NOCOPY VARCHAR2
12: ) IS
5: PROCEDURE INSERT_ROWS (
6: p_trx_header_tbl IN AR_INVOICE_API_PUB.trx_header_tbl_type,
7: p_trx_lines_tbl IN AR_INVOICE_API_PUB.trx_line_tbl_type,
8: p_trx_dist_tbl IN AR_INVOICE_API_PUB.trx_dist_tbl_type,
9: p_trx_salescredits_tbl IN AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
10: x_errmsg OUT NOCOPY VARCHAR2,
11: x_return_status OUT NOCOPY VARCHAR2
12: ) IS
13: RecExist Number;
682: END INSERT_ROWS;
683:
684: PROCEDURE GET_ROWS (
685: p_org_id IN NUMBER DEFAULT NULL,
686: p_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type,
687: p_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type,
688: p_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type,
689: p_trx_salescredits_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
690: x_errmsg OUT NOCOPY VARCHAR2,
683:
684: PROCEDURE GET_ROWS (
685: p_org_id IN NUMBER DEFAULT NULL,
686: p_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type,
687: p_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type,
688: p_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type,
689: p_trx_salescredits_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
690: x_errmsg OUT NOCOPY VARCHAR2,
691: x_return_status OUT NOCOPY VARCHAR2
684: PROCEDURE GET_ROWS (
685: p_org_id IN NUMBER DEFAULT NULL,
686: p_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type,
687: p_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type,
688: p_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type,
689: p_trx_salescredits_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
690: x_errmsg OUT NOCOPY VARCHAR2,
691: x_return_status OUT NOCOPY VARCHAR2
692: ) AS
685: p_org_id IN NUMBER DEFAULT NULL,
686: p_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type,
687: p_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type,
688: p_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type,
689: p_trx_salescredits_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
690: x_errmsg OUT NOCOPY VARCHAR2,
691: x_return_status OUT NOCOPY VARCHAR2
692: ) AS
693: