DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on AR_INVOICE_API_PUB

Line 607: ,l_batch_source_rec OUT NOCOPY AR_INVOICE_API_PUB.batch_source_rec_type)

603: --------------------------------------------
604: PROCEDURE PREPARE_BATCH_SOURCE_REC(
605: x_return_status OUT NOCOPY VARCHAR2
606: ,p_trx_date IN DATE
607: ,l_batch_source_rec OUT NOCOPY AR_INVOICE_API_PUB.batch_source_rec_type)
608: IS
609: CURSOR batch_src_csr( p_in_date DATE ) IS
610: SELECT BATCH_SOURCE_ID
611: FROM ra_batch_sources_all

Line 660: ,l_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type

656: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
657: --end: | 02-APR-07 cklee R12 Billing enhancement project |
658: -- rkuttiya added for bug 7209767
659: ,p_source IN VARCHAR2
660: ,l_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type
661: )
662: IS
663:
664: lx_customer_id number;

Line 1111: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)

1107: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
1108: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
1109: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
1110: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1111: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)
1112: IS
1113:
1114: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1115: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;

Line 1726: ,l_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type )

1722: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
1723: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
1724: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
1725: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1726: ,l_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type )
1727: IS
1728: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1729: /* commented out for R12
1730: CURSOR dist_csr ( p_xls_id NUMBER ) IS

Line 2118: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;

2114: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2115: -- ------------------------------------------
2116: -- Variable definition for AR API call
2117: -- ------------------------------------------
2118: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2119: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2120:
2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;

Line 2119: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;

2115: -- ------------------------------------------
2116: -- Variable definition for AR API call
2117: -- ------------------------------------------
2118: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2119: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2120:
2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2123:

Line 2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;

2117: -- ------------------------------------------
2118: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2119: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2120:
2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2123:
2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;

Line 2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;

2118: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2119: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
2120:
2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2123:
2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2126:

Line 2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;

2120:
2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2123:
2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2126:
2127: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2128: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;

Line 2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;

2121: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2122: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
2123:
2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2126:
2127: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2128: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2129:

Line 2127: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;

2123:
2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2126:
2127: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2128: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2129:
2130: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2131: /*commented out for R12

Line 2128: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;

2124: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2125: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
2126:
2127: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2128: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
2129:
2130: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2131: /*commented out for R12
2132: --Bug# 4488818: Sales Tax Billing

Line 2138: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;

2134: l_tax_line_number NUMBER;
2135: */
2136: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2137:
2138: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2139: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2140:
2141: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2142: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;

Line 2139: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;

2135: */
2136: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2137:
2138: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2139: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2140:
2141: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2142: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2143:

Line 2141: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;

2137:
2138: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2139: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2140:
2141: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2142: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2143:
2144: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2145: /* commented out for R12

Line 2142: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;

2138: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2139: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
2140:
2141: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2142: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
2143:
2144: --start: | 02-APR-07 cklee R12 Billing enhancement project |
2145: /* commented out for R12
2146: l_init_xsiv_rec Okl_Ext_Sell_Invs_Pub.xsiv_rec_type;

Line 2956: AR_INVOICE_API_PUB.create_single_invoice(

2952: fnd_file.put_line(fnd_file.output,'Code Combination Id
2953: :'||l_trx_dist_tbl(j).code_combination_id);
2954: End LOOP;
2955:
2956: AR_INVOICE_API_PUB.create_single_invoice(
2957: p_api_version => 1.0,
2958: p_batch_source_rec => l_batch_source_rec,
2959: p_trx_header_tbl => l_trx_header_tbl,
2960: p_trx_lines_tbl => l_trx_lines_tbl,