eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_EXT_SELL_INVS_B

Line 20: TYPE xsi_tbl_type IS TABLE OF OKL_EXT_SELL_INVS_B%ROWTYPE INDEX BY BINARY_INTEGER;

16: l_xsi_cnt NUMBER := 0;
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;

Line 205: INSERT INTO OKL_EXT_SELL_INVS_B

201:
202: IF xsi_tbl.COUNT > 0 THEN
203: FORALL indx IN xsi_tbl.first..xsi_tbl.LAST
204: SAVE EXCEPTIONS
205: INSERT INTO OKL_EXT_SELL_INVS_B
206: VALUES xsi_tbl(indx);
207: END IF;
208:
209: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 220: PRINT_TO_LOG('BULK Done Inserting into okl_ext_sell_invs_b');

216: error_tbl(error_tbl.COUNT + 1).id := TO_NUMBER(xsi_tbl(i).id);
217: total_error_tbl(total_error_tbl.COUNT + 1).id := TO_NUMBER(xsi_tbl(i).id);
218: END LOOP;
219: END IF;
220: PRINT_TO_LOG('BULK Done Inserting into okl_ext_sell_invs_b');
221:
222: -- --------------------------------------
223: -- Transfer XsiTl records to the XsiTl table
224: -- --------------------------------------

Line 396: DELETE FROM Okl_Ext_Sell_Invs_B

392: DELETE FROM Okl_Xtl_Sell_Invs_TL
393: WHERE id = del_error_rec.xls_id;
394:
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;

Line 527: l_xsi_id OKL_EXT_SELL_INVS_B.id%TYPE;

523: ,p_end_of_records IN VARCHAR2 DEFAULT NULL
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:

Line 530: l_legal_entity_id OKL_EXT_SELL_INVS_B.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006

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
534: SELECT cr_dr_flag,

Line 793: l_currency_code okl_ext_sell_invs_b.currency_code%TYPE;

789:
790: --Start code added by pgomes on 20-NOV-2002
791: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
792: l_khr_id khr_id_type;
793: l_currency_code okl_ext_sell_invs_b.currency_code%TYPE;
794: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%TYPE;
795: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%TYPE;
796: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%TYPE;
797:

Line 794: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%TYPE;

790: --Start code added by pgomes on 20-NOV-2002
791: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
792: l_khr_id khr_id_type;
793: l_currency_code okl_ext_sell_invs_b.currency_code%TYPE;
794: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%TYPE;
795: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%TYPE;
796: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%TYPE;
797:
798: --Get currency conversion attributes for a contract

Line 795: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%TYPE;

791: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%TYPE;
792: l_khr_id khr_id_type;
793: l_currency_code okl_ext_sell_invs_b.currency_code%TYPE;
794: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%TYPE;
795: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%TYPE;
796: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%TYPE;
797:
798: --Get currency conversion attributes for a contract
799: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS

Line 796: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%TYPE;

792: l_khr_id khr_id_type;
793: l_currency_code okl_ext_sell_invs_b.currency_code%TYPE;
794: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%TYPE;
795: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%TYPE;
796: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%TYPE;
797:
798: --Get currency conversion attributes for a contract
799: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
800: SELECT currency_code,

Line 1962: DELETE FROM okl_ext_sell_invs_b

1958: WHERE id = d_xlsv_rec.id;
1959:
1960: d_xsiv_rec.id := del3level.xsi_id;
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;

Line 3103: DELETE FROM okl_ext_sell_invs_b

3099: WHERE id = d_xlsv_rec.id;
3100:
3101: d_xsiv_rec.id := del2level.xsi_id;
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;