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_DEAL_CREAT_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 438: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;

434: p_contract_number IN VARCHAR2,
435: p_source_chr_id IN NUMBER,
436: x_chr_id OUT NOCOPY NUMBER) AS
437:
438: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
439: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
440: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
441:
442: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 439: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;

435: p_source_chr_id IN NUMBER,
436: x_chr_id OUT NOCOPY NUMBER) AS
437:
438: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
439: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
440: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
441:
442: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
443: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 440: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;

436: x_chr_id OUT NOCOPY NUMBER) AS
437:
438: l_end_date OKL_K_HEADERS_FULL_V.END_DATE%TYPE DEFAULT NULL;
439: l_start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE DEFAULT NULL;
440: l_term_duration OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE DEFAULT NULL;
441:
442: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
443: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
444: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 1153: FROM okl_k_headers_full_v

1149: lx_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
1150:
1151: CURSOR get_curr_csr(p_id IN NUMBER) IS
1152: SELECT id,currency_code,currency_conversion_type,currency_conversion_date,currency_conversion_rate, cust_acct_id, khr_id
1153: FROM okl_k_headers_full_v
1154: WHERE scs_code = 'QUOTE'
1155: AND id = p_id;
1156:
1157: CURSOR c_rgpv IS

Line 2556: FROM okl_k_headers_full_v

2552:
2553: --Cursor to get vp template
2554: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2555: SELECT id
2556: FROM okl_k_headers_full_v
2557: WHERE scs_code = 'PROGRAM'
2558: AND sts_code IN ('ACTIVE','PASSED')
2559: AND khr_id = p_vp_id
2560: AND NVL(template_yn,'N') = 'Y';

Line 2703: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;

2699: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2700: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2701: l_start_date okc_k_headers_b.start_date%TYPE;
2702: l_rule_amt NUMBER;
2703: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2704: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2705: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2707: x_converted_amount NUMBER := NULL;

Line 2704: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;

2700: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2701: l_start_date okc_k_headers_b.start_date%TYPE;
2702: l_rule_amt NUMBER;
2703: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2704: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2705: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2707: x_converted_amount NUMBER := NULL;
2708:

Line 2705: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;

2701: l_start_date okc_k_headers_b.start_date%TYPE;
2702: l_rule_amt NUMBER;
2703: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2704: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2705: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2707: x_converted_amount NUMBER := NULL;
2708:
2709: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

Line 2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;

2702: l_rule_amt NUMBER;
2703: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2704: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2705: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2707: x_converted_amount NUMBER := NULL;
2708:
2709: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2710: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;

Line 2721: FROM okl_k_headers_full_v

2717:
2718: --Cursor to get vp template
2719: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2720: SELECT id
2721: FROM okl_k_headers_full_v
2722: WHERE scs_code = 'PROGRAM'
2723: AND sts_code IN ('ACTIVE','PASSED')
2724: AND khr_id = p_vp_id
2725: AND NVL(template_yn,'N') = 'Y';

Line 4626: FROM okl_k_headers_full_v CHR

4622: -- cursor when only customer is selected
4623:
4624: CURSOR l_leaseAppTmpl1_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4625: SELECT CHR.id
4626: FROM okl_k_headers_full_v CHR
4627: , okc_k_party_roles_b prl
4628: WHERE prl.dnz_chr_id = CHR.id
4629: AND prl.chr_id = CHR.id
4630: AND CHR.scs_code = 'LEASE'

Line 4716: FROM okl_k_headers_full_v CHR

4712: AND CHR.contract_number = p_source_contract_number;
4713:
4714: CURSOR l_leaseAppTmpl_crs IS
4715: SELECT CHR.id
4716: FROM okl_k_headers_full_v CHR
4717: WHERE CHR.scs_code = 'LEASE'
4718: AND CHR.chr_type = 'CYA'
4719: AND nvl(CHR.template_yn,'N') = 'Y'
4720: AND NVL(CHR.TEMPLATE_TYPE_CODE,'XXX') = 'LEASEAPP'

Line 4725: FROM okl_k_headers_full_v chr

4721: AND CHR.contract_number = p_source_contract_number;
4722:
4723: CURSOR l_program_csr IS
4724: SELECT chr.id
4725: FROM okl_k_headers_full_v chr
4726: WHERE chr.scs_code = 'PROGRAM'
4727: AND nvl(chr.template_yn, 'N') = 'N'
4728: AND chr.sts_code = 'ACTIVE'
4729: AND chr.authoring_org_id = p_org_id

Line 4736: FROM okl_k_headers_full_v CHR

4732: AND chr.contract_number = p_program_name;
4733:
4734: CURSOR l_progAgrmntTemp_crs(p_prog_id NUMBER) IS
4735: SELECT CHR.id
4736: FROM okl_k_headers_full_v CHR
4737: WHERE CHR.scs_code = p_scs_code
4738: AND CHR.chr_type = 'CYA'
4739: AND nvl(chr.template_yn,'N') = 'Y'
4740: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 4753: FROM okl_k_headers_full_v CHR

4749: */
4750:
4751: CURSOR l_progAgrmntTemp1_crs IS
4752: SELECT CHR.id
4753: FROM okl_k_headers_full_v CHR
4754: WHERE CHR.scs_code = p_scs_code
4755: AND CHR.chr_type = 'CYA'
4756: AND nvl(chr.template_yn,'N') = 'Y'
4757: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 5883: from OKL_k_headers_full_V

5879: l_rbr_code okl_trx_contracts.rbr_code%type := null;
5880:
5881: cursor l_mla_csr is
5882: select id
5883: from OKL_k_headers_full_V
5884: where contract_number = p_mla_no
5885: and scs_code = 'MASTER_LEASE'
5886: and STS_CODE = 'ACTIVE'
5887: and TEMPLATE_YN = 'N'

Line 5907: from OKL_k_headers_full_V prg_hdr

5903: l_cl_id NUMBER;
5904:
5905: cursor l_program_csr is
5906: select id
5907: from OKL_k_headers_full_V prg_hdr
5908: where contract_number = p_program_no
5909: and scs_code = 'PROGRAM'
5910: and nvl(TEMPLATE_YN, 'N') = 'N'
5911: and sts_code = 'ACTIVE'

Line 5923: FROM okl_k_headers_full_v

5919: old_khr_id NUMBER;
5920:
5921: CURSOR c_vp_exsts_csr IS
5922: SELECT khr_id
5923: FROM okl_k_headers_full_v
5924: WHERE id = p_chr_id;
5925:
5926: CURSOR c_context_csr IS
5927: SELECT authoring_org_id, inv_organization_id

Line 5928: FROM okl_k_headers_full_V

5924: WHERE id = p_chr_id;
5925:
5926: CURSOR c_context_csr IS
5927: SELECT authoring_org_id, inv_organization_id
5928: FROM okl_k_headers_full_V
5929: WHERE id = p_chr_id;
5930:
5931: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5932: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

Line 6717: FROM okl_k_headers_full_v

6713: old_khr_id NUMBER;
6714:
6715: CURSOR c_vp_exsts_csr IS
6716: SELECT khr_id
6717: FROM okl_k_headers_full_v
6718: WHERE id = p_durv_rec.chr_id;
6719:
6720: l_fin_ast VARCHAR2(1) := 'N';
6721: l_lrls_yn VARCHAR2(1) := 'X';

Line 6833: CURSOR c_chk_pdt_effective(cp_pdt_id OKL_PRODUCTS.ID%TYPE, cp_effective_date okl_k_headers_full_v.start_date%type) IS

6829: l_count NUMBER;
6830: l_krpdel_tbl OKL_K_RATE_PARAMS_PVT.krpdel_tbl_type;
6831:
6832: -- ER# 9115610 - Start
6833: CURSOR c_chk_pdt_effective(cp_pdt_id OKL_PRODUCTS.ID%TYPE, cp_effective_date okl_k_headers_full_v.start_date%type) IS
6834: SELECT 'Y' FROM
6835: OKL_PRODUCTS
6836: WHERE ID = cp_pdt_id
6837: AND cp_effective_date BETWEEN FROM_DATE AND NVL(TO_DATE,cp_effective_date);

Line 8363: FROM okl_k_headers_full_v

8359: -- orig_system_id1,
8360: currency_code,
8361: pdt_id,
8362: khr_id
8363: FROM okl_k_headers_full_v
8364: WHERE id = p_durv_rec.chr_id;
8365:
8366:
8367: CURSOR l_vers_version_csr IS

Line 8374: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8370: WHERE vers.chr_id = p_durv_rec.chr_id;
8371:
8372: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8373: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8374: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8375: WHERE mla.id = gvr.chr_id_referred
8376: AND mla.scs_code = p_scs_code -- mla or cl
8377: AND gvr.chr_id = p_durv_rec.chr_id
8378: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8429: FROM okl_k_headers_full_v

8425: WHERE currency_code = p_currency_code;
8426:
8427: CURSOR l_program_csr(program_id NUMBER) IS
8428: SELECT id,contract_number
8429: FROM okl_k_headers_full_v
8430: WHERE id = program_id;
8431:
8432: CURSOR l_contact_csr IS
8433: --Start modified abhsaxen for performance SQLID 20563327

Line 9035: FROM okl_k_headers_full_v

9031: l_hdr_uv_rec c_hdr_full_uv%ROWTYPE;
9032:
9033: CURSOR c_hdr_full_v(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
9034: SELECT *
9035: FROM okl_k_headers_full_v
9036: WHERE id = p_chr_id;
9037:
9038: l_hdr_rec c_hdr_full_v%ROWTYPE;
9039:

Line 9055: FROM okl_k_headers_full_v mla,

9051: CURSOR c_gvr_data(p_scs_code VARCHAR2,
9052: p_chr_id NUMBER,
9053: p_dnz_chr_id NUMBER) IS
9054: SELECT mla.contract_number,gvr.chr_id_referred,gvr.id
9055: FROM okl_k_headers_full_v mla,
9056: okc_governances_v gvr
9057: WHERE mla.id = gvr.chr_id_referred
9058: AND mla.scs_code = p_scs_code
9059: AND gvr.dnz_chr_id = p_dnz_chr_id

Line 9112: FROM okl_k_headers_full_v chr

9108: AND lsq.status = 'CT-ACCEPTED';
9109:
9110: CURSOR c_program_template_name(p_orig_system_id1 NUMBER, p_khr_khr_id NUMBER) IS
9111: SELECT chr.contract_number
9112: FROM okl_k_headers_full_v chr
9113: WHERE chr.id = p_orig_system_id1
9114: AND chr.template_type_code = 'PROGRAM'
9115: AND NVL(chr.template_yn,'N') = 'Y'
9116: AND EXISTS(SELECT 1