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_CREATE_KLE_PVT dependencies on OKC_K_HEADERS_V

Line 94: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';

90: G_FORMULA_RES OKL_FORMULAE_V.NAME%TYPE := 'LINE_RESIDUAL_VALUE';
91: G_ID2 CONSTANT VARCHAR2(200) := '#';
92: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
93: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
94: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
95: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
96: G_QUOTE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'QUOTE';
97: ---------------------------------------------------------------------------------------------------------------
98: --Added by dpsingh for LE uptake

Line 95: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';

91: G_ID2 CONSTANT VARCHAR2(200) := '#';
92: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
93: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
94: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
95: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
96: G_QUOTE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'QUOTE';
97: ---------------------------------------------------------------------------------------------------------------
98: --Added by dpsingh for LE uptake
99: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS

Line 96: G_QUOTE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'QUOTE';

92: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
93: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
94: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
95: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
96: G_QUOTE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'QUOTE';
97: ---------------------------------------------------------------------------------------------------------------
98: --Added by dpsingh for LE uptake
99: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
100: SELECT contract_number

Line 333: FROM OKC_K_HEADERS_V chrv

329: RETURN VARCHAR2 IS
330: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
331: CURSOR c_get_tls_sts_code(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
332: SELECT chrv.sts_code
333: FROM OKC_K_HEADERS_V chrv
334: WHERE chrv.id = p_dnz_chr_id;
335:
336: CURSOR c_get_sls_sts_code(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
337: SELECT cle.sts_code

Line 364: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');

360: -- store SQL error message on message stack
361: OKL_API.set_message(p_app_name => G_APP_NAME,
362: p_msg_name => G_NO_MATCHING_RECORD,
363: p_token1 => G_COL_NAME_TOKEN,
364: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');
365: RAISE G_EXCEPTION_HALT_VALIDATION;
366: END IF;
367: CLOSE c_get_tls_sts_code;
368: IF (x_sts_code IS NULL OR

Line 387: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');

383: -- store SQL error message on message stack
384: OKL_API.set_message(p_app_name => G_APP_NAME,
385: p_msg_name => G_NO_MATCHING_RECORD,
386: p_token1 => G_COL_NAME_TOKEN,
387: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');
388: RAISE G_EXCEPTION_HALT_VALIDATION;
389: END IF;
390: CLOSE c_get_sls_sts_code;
391: IF (x_sts_code IS NULL OR

Line 445: FROM OKC_K_HEADERS_V chrv

441: RETURN VARCHAR2 IS
442: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
443: CURSOR c_get_tls_end_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
444: SELECT chrv.end_Date
445: FROM OKC_K_HEADERS_V chrv
446: WHERE chrv.id = p_dnz_chr_id;
447:
448: CURSOR c_get_sls_end_date(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
449: SELECT cle.end_date

Line 476: p_token1_value => 'OKC_K_HEADERS_V.END_DATE');

472: -- store SQL error message on message stack
473: OKL_API.set_message(p_app_name => G_APP_NAME,
474: p_msg_name => G_NO_MATCHING_RECORD,
475: p_token1 => G_COL_NAME_TOKEN,
476: p_token1_value => 'OKC_K_HEADERS_V.END_DATE');
477: RAISE G_EXCEPTION_HALT_VALIDATION;
478: END IF;
479: CLOSE c_get_tls_end_date;
480: END IF;

Line 491: p_token1_value => 'OKC_K_HEADERS_V.END_DATE');

487: -- store SQL error message on message stack
488: OKL_API.set_message(p_app_name => G_APP_NAME,
489: p_msg_name => G_NO_MATCHING_RECORD,
490: p_token1 => G_COL_NAME_TOKEN,
491: p_token1_value => 'OKC_K_HEADERS_V.END_DATE');
492: RAISE G_EXCEPTION_HALT_VALIDATION;
493: END IF;
494: CLOSE c_get_sls_end_date;
495: END IF;

Line 546: FROM OKC_K_HEADERS_V chrv

542: CURSOR c_get_tls_start_date(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
543: SELECT chrv.start_Date,
544: chrv.orig_system_source_code,
545: chrv.orig_system_id1
546: FROM OKC_K_HEADERS_V chrv
547: WHERE chrv.id = p_dnz_chr_id;
548:
549: CURSOR c_get_sls_start_date(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
550: SELECT cle.start_date

Line 589: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');

585: -- store SQL error message on message stack
586: OKL_API.set_message(p_app_name => G_APP_NAME,
587: p_msg_name => G_NO_MATCHING_RECORD,
588: p_token1 => G_COL_NAME_TOKEN,
589: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');
590: RAISE G_EXCEPTION_HALT_VALIDATION;
591: END IF;
592: CLOSE c_get_tls_start_date;
593: IF lv_orig_sys_source_code = 'OKL_REBOOK' THEN

Line 610: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');

606: -- store SQL error message on message stack
607: OKL_API.set_message(p_app_name => G_APP_NAME,
608: p_msg_name => G_NO_MATCHING_RECORD,
609: p_token1 => G_COL_NAME_TOKEN,
610: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');
611: RAISE G_EXCEPTION_HALT_VALIDATION;
612: END IF;
613: CLOSE c_get_sls_start_date;
614: END IF;

Line 660: FROM OKC_K_HEADERS_V chrv

656: RETURN VARCHAR2 IS
657: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
658: CURSOR c_get_tls_currency_code(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
659: SELECT chrv.currency_code
660: FROM OKC_K_HEADERS_V chrv
661: WHERE chrv.id = p_dnz_chr_id;
662:
663: CURSOR c_get_sls_currency_code(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
664: SELECT cle.currency_code

Line 691: p_token1_value => 'OKC_K_HEADERS_V.CURRENCY_CODE');

687: -- store SQL error message on message stack
688: OKL_API.set_message(p_app_name => G_APP_NAME,
689: p_msg_name => G_NO_MATCHING_RECORD,
690: p_token1 => G_COL_NAME_TOKEN,
691: p_token1_value => 'OKC_K_HEADERS_V.CURRENCY_CODE');
692: RAISE G_EXCEPTION_HALT_VALIDATION;
693: END IF;
694: CLOSE c_get_tls_currency_code;
695: END IF;

Line 706: p_token1_value => 'OKC_K_HEADERS_V.CURRENCY_CODE');

702: -- store SQL error message on message stack
703: OKL_API.set_message(p_app_name => G_APP_NAME,
704: p_msg_name => G_NO_MATCHING_RECORD,
705: p_token1 => G_COL_NAME_TOKEN,
706: p_token1_value => 'OKC_K_HEADERS_V.CURRENCY_CODE');
707: RAISE G_EXCEPTION_HALT_VALIDATION;
708: END IF;
709: CLOSE c_get_sls_currency_code;
710: END IF;

Line 777: FROM OKC_K_HEADERS_V chrv

773: chrv.currency_code,
774: chrv.start_Date,
775: chrv.orig_system_source_code,
776: chrv.orig_system_id1
777: FROM OKC_K_HEADERS_V chrv
778: WHERE chrv.id = p_dnz_chr_id;
779:
780: CURSOR c_get_contract_line_details(p_cle_id OKC_K_LINES_B.CLE_ID%TYPE) IS
781: SELECT cle.sts_code,

Line 827: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');

823: -- store SQL error message on message stack
824: OKL_API.set_message(p_app_name => G_APP_NAME,
825: p_msg_name => G_NO_MATCHING_RECORD,
826: p_token1 => G_COL_NAME_TOKEN,
827: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');
828: RAISE G_EXCEPTION_HALT_VALIDATION;
829: END IF;
830: CLOSE c_get_contract_header_details;
831: IF lv_orig_sys_source_code = 'OKL_REBOOK' THEN

Line 852: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');

848: -- store SQL error message on message stack
849: OKL_API.set_message(p_app_name => G_APP_NAME,
850: p_msg_name => G_NO_MATCHING_RECORD,
851: p_token1 => G_COL_NAME_TOKEN,
852: p_token1_value => 'OKC_K_HEADERS_V.START_DATE');
853: RAISE G_EXCEPTION_HALT_VALIDATION;
854: END IF;
855: CLOSE c_get_contract_line_details;
856: END IF;

Line 3548: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;

3544: ln1_dummy NUMBER := 0;
3545: ln2_dummy NUMBER := 0;
3546: ln3_dummy NUMBER := p_units;
3547: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3548: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3549: --Bug# 4419339
3550: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3551: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
3552: IS

Line 15205: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;

15201: ln_klev_fin_cap OKL_K_LINES_V.CAPITAL_AMOUNT%TYPE := 0;
15202: ln_clev_model_price_unit OKC_K_LINES_V.PRICE_UNIT%TYPE := 0;
15203: ln_cimv_model_no_items OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
15204: lv_object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE;
15205: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
15206: ln_dummy NUMBER := 0;
15207: ln_dummy1 NUMBER := 0;
15208: i NUMBER := 0;
15209: j NUMBER := 0;

Line 15239: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,

15235: IS
15236: SELECT CII.SERIAL_NUMBER IB_SERIAL_NUMBER,
15237: CII.INSTANCE_ID
15238: FROM
15239: OKC_K_HEADERS_V OKHV, OKC_K_LINES_V KLE_FA, OKC_LINE_STYLES_B LSE_FA, OKC_K_LINES_B KLE_IL,
15240: OKC_LINE_STYLES_B LSE_IL, OKC_K_LINES_B KLE_IB, OKC_LINE_STYLES_B LSE_IB, OKC_K_ITEMS ITE,
15241: CSI_ITEM_INSTANCES CII
15242: WHERE
15243: kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id AND lse_fa.lty_code = 'FREE_FORM1'

Line 19086: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

19082: x_msg_data OUT NOCOPY VARCHAR2,
19083: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
19084: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
19085: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
19086: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
19087: p_itiv_ib_tbl IN itiv_tbl_type,
19088: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,
19089: x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type) IS
19090: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INTS_IB_LINE';