APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_XTD_SELL_INVS_B

Line 22: TYPE esd_tbl_type IS TABLE OF OKL_XTD_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;

18: l_esd_cnt NUMBER := 0;
19:
20: TYPE xsi_tbl_type IS TABLE OF OKL_EXT_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;
21: TYPE xls_tbl_type IS TABLE OF OKL_XTL_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;
22: TYPE esd_tbl_type IS TABLE OF OKL_XTD_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;
23:
24: xsi_tbl xsi_tbl_type;
25: xls_tbl xls_tbl_type;
26: esd_tbl esd_tbl_type;

Line 306: INSERT INTO OKL_XTD_SELL_INVS_B

302:
303: IF esd_tbl.COUNT > 0 THEN
304: FORALL indx IN esd_tbl.first..esd_tbl.LAST
305: SAVE EXCEPTIONS
306: INSERT INTO OKL_XTD_SELL_INVS_B
307: VALUES esd_tbl(indx);
308: END IF;
309:
310: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 320: PRINT_TO_LOG('BULK Done Inserting into okl_xtd_sell_invs_b');

316:
317: --error_tbl(error_tbl.count + 1).esd_id := to_number(esd_tbl(i).id);
318: END LOOP;
319: END IF;
320: PRINT_TO_LOG('BULK Done Inserting into okl_xtd_sell_invs_b');
321:
322: -- --------------------------------------
323: -- Transfer XtdTl records to the XtdTl table
324: -- --------------------------------------

Line 380: DELETE FROM Okl_Xtd_Sell_Invs_B

376:
377: FOR del_xtd_rec IN del_xtd_csr( del_error_rec.xls_id ) LOOP
378: PRINT_TO_LOG('BULK Deleting xtd when error ...');
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;

Line 529: l_esd_id OKL_XTD_SELL_INVS_B.id%TYPE;

525: IS
526: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_IE_TBL';
527: l_xsi_id OKL_EXT_SELL_INVS_B.id%TYPE;
528: l_xls_id OKL_XTL_SELL_INVS_B.id%TYPE;
529: l_esd_id OKL_XTD_SELL_INVS_B.id%TYPE;
530: l_legal_entity_id OKL_EXT_SELL_INVS_B.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
531:
532: -- Selects all distributions created by the accounting Engine
533: CURSOR acc_dstrs_csr(p_source_id IN NUMBER, p_source_table IN VARCHAR2) IS

Line 1944: DELETE FROM okl_xtd_sell_invs_b

1940: FOR delrec IN del_xtd_csr(del3level.xls_id)
1941: LOOP
1942: d_esdv_rec.id := delrec.esd_id;
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;

Line 3085: DELETE FROM okl_xtd_sell_invs_b

3081: FOR delrec IN del_xtd_csr(del2level.xls_id)
3082: LOOP
3083: d_esdv_rec.id := delrec.esd_id;
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;