APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_XTL_SELL_INVS_B

Line 21: TYPE xls_tbl_type IS TABLE OF OKL_XTL_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;

17: l_xls_cnt NUMBER := 0;
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;

Line 256: INSERT INTO OKL_XTL_SELL_INVS_B

252:
253: IF xls_tbl.COUNT > 0 THEN
254: FORALL indx IN xls_tbl.first..xls_tbl.LAST
255: SAVE EXCEPTIONS
256: INSERT INTO OKL_XTL_SELL_INVS_B
257: VALUES xls_tbl(indx);
258: END IF;
259:
260: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 270: PRINT_TO_LOG('BULK Done Inserting into okl_xtl_sell_invs_b');

266:
267: --error_tbl(error_tbl.count + 1).xls_id := to_number(xls_tbl(i).id);
268: END LOOP;
269: END IF;
270: PRINT_TO_LOG('BULK Done Inserting into okl_xtl_sell_invs_b');
271:
272: -- --------------------------------------
273: -- Transfer XlsTl records to the XlsTl table
274: -- --------------------------------------

Line 389: DELETE FROM Okl_Xtl_Sell_Invs_B

385:
386: END LOOP;
387:
388: PRINT_TO_LOG('BULK Deleting xls when error ...');
389: DELETE FROM Okl_Xtl_Sell_Invs_B
390: WHERE id = del_error_rec.xls_id;
391:
392: DELETE FROM Okl_Xtl_Sell_Invs_TL
393: WHERE id = del_error_rec.xls_id;

Line 528: l_xls_id OKL_XTL_SELL_INVS_B.id%TYPE;

524: )
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

Line 1954: DELETE FROM okl_xtl_sell_invs_b

1950: END LOOP;
1951:
1952: d_xlsv_rec.id := del3level.xls_id;
1953:
1954: DELETE FROM okl_xtl_sell_invs_b
1955: WHERE id = d_xlsv_rec.id;
1956:
1957: DELETE FROM okl_xtl_sell_invs_tl
1958: WHERE id = d_xlsv_rec.id;

Line 3095: DELETE FROM okl_xtl_sell_invs_b

3091: END LOOP;
3092:
3093: d_xlsv_rec.id := del2level.xls_id;
3094:
3095: DELETE FROM okl_xtl_sell_invs_b
3096: WHERE id = d_xlsv_rec.id;
3097:
3098: DELETE FROM okl_xtl_sell_invs_tl
3099: WHERE id = d_xlsv_rec.id;