APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_XTD_SELL_INVS_TL

Line 34: TYPE esdtl_tbl_type IS TABLE OF OKL_XTD_SELL_INVS_TL%ROWTYPE INDEX BY BINARY_INTEGER;

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;
37: xlstl_tbl xlstl_tbl_type;
38: esdtl_tbl esdtl_tbl_type;

Line 331: INSERT INTO OKL_XTD_SELL_INVS_TL

327:
328: IF esdtl_tbl.COUNT > 0 THEN
329: FORALL indx IN esdtl_tbl.first..esdtl_tbl.LAST
330: SAVE EXCEPTIONS
331: INSERT INTO OKL_XTD_SELL_INVS_TL
332: VALUES esdtl_tbl(indx);
333: END IF;
334:
335: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 346: PRINT_TO_LOG('BULK Done Inserting into okl_xtd_sell_invs_tl');

342:
343: --error_tbl(error_tbl.count + 1).id := to_number(esdtl_tbl(i).id);
344: END LOOP;
345: END IF;
346: PRINT_TO_LOG('BULK Done Inserting into okl_xtd_sell_invs_tl');
347:
348: -- update the status
349: PRINT_TO_LOG('BULK tai_id_tbl.COUNT: '||tai_id_tbl.COUNT);
350: IF (tai_id_tbl.COUNT > 0) THEN

Line 383: DELETE FROM Okl_Xtd_Sell_Invs_TL

379:
380: DELETE FROM Okl_Xtd_Sell_Invs_B
381: WHERE id = del_xtd_rec.esd_id;
382:
383: DELETE FROM Okl_Xtd_Sell_Invs_TL
384: WHERE id = del_xtd_rec.esd_id;
385:
386: END LOOP;
387:

Line 1947: DELETE FROM okl_xtd_sell_invs_tl

1943:
1944: DELETE FROM okl_xtd_sell_invs_b
1945: WHERE id = d_esdv_rec.id;
1946:
1947: DELETE FROM okl_xtd_sell_invs_tl
1948: WHERE id = d_esdv_rec.id;
1949:
1950: END LOOP;
1951:

Line 3088: DELETE FROM okl_xtd_sell_invs_tl

3084:
3085: DELETE FROM okl_xtd_sell_invs_b
3086: WHERE id = d_esdv_rec.id;
3087:
3088: DELETE FROM okl_xtd_sell_invs_tl
3089: WHERE id = d_esdv_rec.id;
3090:
3091: END LOOP;
3092: