DBA Data[Home] [Help]

APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 718: IS TABLE OF okl_txl_ar_inv_lns_b%ROWTYPE

714:
715: l_sty_id NUMBER;
716: l_upfront_tax_treatment_rec l_upfront_tax_treatment_csr%ROWTYPE;
717: TYPE txl_ar_inv_lins_tbl
718: IS TABLE OF okl_txl_ar_inv_lns_b%ROWTYPE
719: INDEX BY BINARY_INTEGER;
720:
721: TYPE txl_ar_inv_lns_tl_tbl
722: IS TABLE OF okl_txl_ar_inv_lns_tl%ROWTYPE

Line 1198: ---Bulk insert into okl_txl_ar_inv_lns_b

1194: END IF;
1195:
1196:
1197: --use for all i loop and bulk insert into invoice lines table
1198: ---Bulk insert into okl_txl_ar_inv_lns_b
1199: BEGIN
1200: IF l_txl_ar_inv_lns_tbl.COUNT > 0
1201: THEN
1202: FORALL i IN l_txl_ar_inv_lns_tbl.FIRST .. l_txl_ar_inv_lns_tbl.LAST save

Line 1204: INSERT INTO okl_txl_ar_inv_lns_b

1200: IF l_txl_ar_inv_lns_tbl.COUNT > 0
1201: THEN
1202: FORALL i IN l_txl_ar_inv_lns_tbl.FIRST .. l_txl_ar_inv_lns_tbl.LAST save
1203: exceptions
1204: INSERT INTO okl_txl_ar_inv_lns_b
1205: VALUES l_txl_ar_inv_lns_tbl(i);
1206: END IF;
1207:
1208: EXCEPTION

Line 1217: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',

1213: LOOP
1214: okl_api.set_message(p_app_name => 'OKL',
1215: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1216: p_token1 => 'TABLE_NAME',
1217: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1218: p_token2 => 'ERROR_CODE',
1219: p_token2_value => SQLERRM(-sql%bulk_exceptions(i)
1220: .error_code),
1221: p_token3 => 'ITERATION',

Line 1308: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',

1304: LOOP
1305: okl_api.set_message(p_app_name => 'OKL',
1306: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1307: p_token1 => 'TABLE_NAME',
1308: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1309: p_token2 => 'ERROR_CODE',
1310: p_token2_value => SQLERRM(-sql%bulk_exceptions(i)
1311: .error_code),
1312: p_token3 => 'ITERATION',