DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on AR_INVOICE_API_PUB

Line 349: ,l_batch_source_rec OUT NOCOPY AR_INVOICE_API_PUB.batch_source_rec_type)

345: --------------------------------------------
346: PROCEDURE PREPARE_BATCH_SOURCE_REC(
347: x_return_status OUT NOCOPY VARCHAR2
348: ,p_trx_date IN DATE
349: ,l_batch_source_rec OUT NOCOPY AR_INVOICE_API_PUB.batch_source_rec_type)
350: IS
351: CURSOR batch_src_csr( p_in_date DATE ) IS
352: SELECT BATCH_SOURCE_ID
353: FROM ra_batch_sources_all

Line 402: ,l_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type

398: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
399: --end: | 02-APR-07 cklee R12 Billing enhancement project |
400: -- rkuttiya added for bug 7209767
401: ,p_source IN VARCHAR2
402: ,l_trx_header_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_header_tbl_type
403: )
404: IS
405:
406: lx_customer_id number;

Line 903: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)

899: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
900: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
901: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
902: --end: | 02-APR-07 cklee R12 Billing enhancement project |
903: ,l_trx_lines_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_line_tbl_type)
904: IS
905:
906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;

Line 1518: ,l_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type )

1514: -- ,r_xsiv_rec IN Okl_Ext_Sell_Invs_Pub.xsiv_rec_type
1515: -- ,r_xlsv_rec IN Okl_Xtl_Sell_Invs_Pub.xlsv_rec_type
1516: ,xfer_rec IN OKL_ARINTF_PVT.xfer_rec_type
1517: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1518: ,l_trx_dist_tbl OUT NOCOPY AR_INVOICE_API_PUB.trx_dist_tbl_type )
1519: IS
1520: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1521: /* commented out for R12
1522: CURSOR dist_csr ( p_xls_id NUMBER ) IS

Line 1910: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;

1906: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1907: -- ------------------------------------------
1908: -- Variable definition for AR API call
1909: -- ------------------------------------------
1910: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1911: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1912:
1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;

Line 1911: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;

1907: -- ------------------------------------------
1908: -- Variable definition for AR API call
1909: -- ------------------------------------------
1910: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1911: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1912:
1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1915:

Line 1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;

1909: -- ------------------------------------------
1910: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1911: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1912:
1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1915:
1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;

Line 1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;

1910: l_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1911: l_init_batch_source_rec AR_INVOICE_API_PUB.batch_source_rec_type;
1912:
1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1915:
1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1918:

Line 1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;

1912:
1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1915:
1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1918:
1919: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1920: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;

Line 1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;

1913: l_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1914: l_init_contingency_tbl AR_INVOICE_API_PUB.trx_contingencies_tbl_type;
1915:
1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1918:
1919: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1920: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1921:

Line 1919: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;

1915:
1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1918:
1919: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1920: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1921:
1922: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1923: /*commented out for R12

Line 1920: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;

1916: l_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1917: l_init_trx_header_tbl AR_INVOICE_API_PUB.trx_header_tbl_type;
1918:
1919: l_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1920: l_init_trx_lines_tbl AR_INVOICE_API_PUB.trx_line_tbl_type;
1921:
1922: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1923: /*commented out for R12
1924: --Bug# 4488818: Sales Tax Billing

Line 1930: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;

1926: l_tax_line_number NUMBER;
1927: */
1928: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1929:
1930: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1931: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1932:
1933: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1934: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;

Line 1931: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;

1927: */
1928: --end: | 02-APR-07 cklee R12 Billing enhancement project |
1929:
1930: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1931: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1932:
1933: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1934: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1935:

Line 1933: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;

1929:
1930: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1931: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1932:
1933: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1934: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1935:
1936: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1937: /* commented out for R12

Line 1934: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;

1930: l_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1931: l_init_trx_dist_tbl AR_INVOICE_API_PUB.trx_dist_tbl_type;
1932:
1933: l_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1934: l_init_trx_salescredits_tbl AR_INVOICE_API_PUB.trx_salescredits_tbl_type;
1935:
1936: --start: | 02-APR-07 cklee R12 Billing enhancement project |
1937: /* commented out for R12
1938: l_init_xsiv_rec Okl_Ext_Sell_Invs_Pub.xsiv_rec_type;

Line 2810: AR_INVOICE_API_PUB.create_single_invoice(

2806: fnd_file.put_line(fnd_file.output,'Code Combination Id
2807: :'||l_trx_dist_tbl(j).code_combination_id);
2808: End LOOP;
2809:
2810: AR_INVOICE_API_PUB.create_single_invoice(
2811: p_api_version => 1.0,
2812: p_batch_source_rec => l_batch_source_rec,
2813: p_trx_header_tbl => l_trx_header_tbl,
2814: p_trx_lines_tbl => l_trx_lines_tbl,