DBA Data[Home] [Help]

APPS.OKL_BILL_UPFRONT_TAX_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 709: IS TABLE OF okl_txl_ar_inv_lns_b%ROWTYPE

705:
706: l_sty_id NUMBER;
707: l_upfront_tax_treatment_rec l_upfront_tax_treatment_csr%ROWTYPE;
708: TYPE txl_ar_inv_lins_tbl
709: IS TABLE OF okl_txl_ar_inv_lns_b%ROWTYPE
710: INDEX BY BINARY_INTEGER;
711:
712: TYPE txl_ar_inv_lns_tl_tbl
713: IS TABLE OF okl_txl_ar_inv_lns_tl%ROWTYPE

Line 1126: ---Bulk insert into okl_txl_ar_inv_lns_b

1122: END IF;
1123:
1124:
1125: --use for all i loop and bulk insert into invoice lines table
1126: ---Bulk insert into okl_txl_ar_inv_lns_b
1127: BEGIN
1128: IF l_txl_ar_inv_lns_tbl.COUNT > 0
1129: THEN
1130: FORALL i IN l_txl_ar_inv_lns_tbl.FIRST .. l_txl_ar_inv_lns_tbl.LAST save

Line 1132: INSERT INTO okl_txl_ar_inv_lns_b

1128: IF l_txl_ar_inv_lns_tbl.COUNT > 0
1129: THEN
1130: FORALL i IN l_txl_ar_inv_lns_tbl.FIRST .. l_txl_ar_inv_lns_tbl.LAST save
1131: exceptions
1132: INSERT INTO okl_txl_ar_inv_lns_b
1133: VALUES l_txl_ar_inv_lns_tbl(i);
1134: END IF;
1135:
1136: EXCEPTION

Line 1145: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',

1141: LOOP
1142: okl_api.set_message(p_app_name => 'OKL',
1143: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1144: p_token1 => 'TABLE_NAME',
1145: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1146: p_token2 => 'ERROR_CODE',
1147: p_token2_value => SQLERRM(-sql%bulk_exceptions(i)
1148: .error_code),
1149: p_token3 => 'ITERATION',

Line 1208: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',

1204: LOOP
1205: okl_api.set_message(p_app_name => 'OKL',
1206: p_msg_name => 'OKL_TX_TRX_INS_ERR',
1207: p_token1 => 'TABLE_NAME',
1208: p_token1_value => 'OKL_TXL_AR_INV_LNS_B',
1209: p_token2 => 'ERROR_CODE',
1210: p_token2_value => SQLERRM(-sql%bulk_exceptions(i)
1211: .error_code),
1212: p_token3 => 'ITERATION',