APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_EXT_SELL_INVS_TL

Line 32: TYPE xsitl_tbl_type IS TABLE OF OKL_EXT_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;

28: l_xsitl_cnt NUMBER := 0;
29: l_xlstl_cnt NUMBER := 0;
30: l_esdtl_cnt NUMBER := 0;
31:
32: TYPE xsitl_tbl_type IS TABLE OF OKL_EXT_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
33: TYPE xlstl_tbl_type IS TABLE OF OKL_XTL_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
34: TYPE esdtl_tbl_type IS TABLE OF OKL_XTD_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;
35:
36: xsitl_tbl xsitl_tbl_type;

Line 231: INSERT INTO OKL_EXT_SELL_INVS_TL

227:
228: IF xsitl_tbl.COUNT > 0 THEN
229: FORALL indx IN xsitl_tbl.first..xsitl_tbl.LAST
230: SAVE EXCEPTIONS
231: INSERT INTO OKL_EXT_SELL_INVS_TL
232: VALUES xsitl_tbl(indx);
233: END IF;
234:
235: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 245: PRINT_TO_LOG('BULK Done Inserting into okl_ext_sell_invs_tl');

241:
242: --error_tbl(error_tbl.count + 1).id := to_number(xsitl_tbl(i).id);
243: END LOOP;
244: END IF;
245: PRINT_TO_LOG('BULK Done Inserting into okl_ext_sell_invs_tl');
246:
247: -- --------------------------------------
248: -- Transfer Xls records to the Xls table
249: -- --------------------------------------

Line 399: DELETE FROM Okl_Ext_Sell_Invs_TL

395: PRINT_TO_LOG('BULK Finally deleting xsi when error ...');
396: DELETE FROM Okl_Ext_Sell_Invs_B
397: WHERE id = error_tbl(i).id;
398:
399: DELETE FROM Okl_Ext_Sell_Invs_TL
400: WHERE id = error_tbl(i).id;
401: END LOOP;
402:
403: -- Performance Improvement

Line 1965: DELETE FROM okl_ext_sell_invs_tl

1961:
1962: DELETE FROM okl_ext_sell_invs_b
1963: WHERE id = d_xsiv_rec.id;
1964:
1965: DELETE FROM okl_ext_sell_invs_tl
1966: WHERE id = d_xsiv_rec.id;
1967:
1968: END LOOP;
1969: END IF;

Line 3106: DELETE FROM okl_ext_sell_invs_tl

3102:
3103: DELETE FROM okl_ext_sell_invs_b
3104: WHERE id = d_xsiv_rec.id;
3105:
3106: DELETE FROM okl_ext_sell_invs_tl
3107: WHERE id = d_xsiv_rec.id;
3108: END LOOP;
3109: END IF;
3110: