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

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

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

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

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

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

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

Line 1154: FROM okl_k_headers_full_v

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

Line 2559: FROM okl_k_headers_full_v

2555: --Cursor to get vp template
2556: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2557: /* Modified this query to improve performance for bug#6979120
2558: SELECT id
2559: FROM okl_k_headers_full_v
2560: WHERE scs_code = 'PROGRAM'
2561: AND sts_code IN ('ACTIVE','PASSED')
2562: AND khr_id = p_vp_id
2563: AND NVL(template_yn,'N') = 'Y'; */

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

2710: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2711: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2712: l_start_date okc_k_headers_b.start_date%TYPE;
2713: l_rule_amt NUMBER;
2714: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2715: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2716: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2717: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2718: x_converted_amount NUMBER := NULL;

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

2711: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2712: l_start_date okc_k_headers_b.start_date%TYPE;
2713: l_rule_amt NUMBER;
2714: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2715: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2716: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2717: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2718: x_converted_amount NUMBER := NULL;
2719:

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

2712: l_start_date okc_k_headers_b.start_date%TYPE;
2713: l_rule_amt NUMBER;
2714: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2715: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2716: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2717: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2718: x_converted_amount NUMBER := NULL;
2719:
2720: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

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

2713: l_rule_amt NUMBER;
2714: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2715: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2716: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2717: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2718: x_converted_amount NUMBER := NULL;
2719:
2720: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2721: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;

Line 2733: FROM okl_k_headers_full_v

2729: --Cursor to get vp template
2730: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2731: /* Modified this query to improve performance for bug#6979120
2732: SELECT id
2733: FROM okl_k_headers_full_v
2734: WHERE scs_code = 'PROGRAM'
2735: AND sts_code IN ('ACTIVE','PASSED')
2736: AND khr_id = p_vp_id
2737: AND NVL(template_yn,'N') = 'Y'; */

Line 4645: FROM okl_k_headers_full_v CHR

4641: -- cursor when only customer is selected
4642:
4643: CURSOR l_leaseAppTmpl1_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4644: SELECT CHR.id
4645: FROM okl_k_headers_full_v CHR
4646: , okc_k_party_roles_b prl
4647: WHERE prl.dnz_chr_id = CHR.id
4648: AND prl.chr_id = CHR.id
4649: AND CHR.scs_code = 'LEASE'

Line 4735: FROM okl_k_headers_full_v CHR

4731: AND CHR.contract_number = p_source_contract_number;
4732:
4733: CURSOR l_leaseAppTmpl_crs IS
4734: SELECT CHR.id
4735: FROM okl_k_headers_full_v CHR
4736: WHERE CHR.scs_code = 'LEASE'
4737: AND CHR.chr_type = 'CYA'
4738: AND nvl(CHR.template_yn,'N') = 'Y'
4739: AND NVL(CHR.TEMPLATE_TYPE_CODE,'XXX') = 'LEASEAPP'

Line 4744: FROM okl_k_headers_full_v chr

4740: AND CHR.contract_number = p_source_contract_number;
4741:
4742: CURSOR l_program_csr IS
4743: SELECT chr.id
4744: FROM okl_k_headers_full_v chr
4745: WHERE chr.scs_code = 'PROGRAM'
4746: AND nvl(chr.template_yn, 'N') = 'N'
4747: AND chr.sts_code = 'ACTIVE'
4748: AND chr.authoring_org_id = p_org_id

Line 4755: FROM okl_k_headers_full_v CHR

4751: AND chr.contract_number = p_program_name;
4752:
4753: CURSOR l_progAgrmntTemp_crs(p_prog_id NUMBER) IS
4754: SELECT CHR.id
4755: FROM okl_k_headers_full_v CHR
4756: WHERE CHR.scs_code = p_scs_code
4757: AND CHR.chr_type = 'CYA'
4758: AND nvl(chr.template_yn,'N') = 'Y'
4759: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 4772: FROM okl_k_headers_full_v CHR

4768: */
4769:
4770: CURSOR l_progAgrmntTemp1_crs IS
4771: SELECT CHR.id
4772: FROM okl_k_headers_full_v CHR
4773: WHERE CHR.scs_code = p_scs_code
4774: AND CHR.chr_type = 'CYA'
4775: AND nvl(chr.template_yn,'N') = 'Y'
4776: AND NVL(chr.template_type_code,'XXX') = OKL_TEMP_TYPE_PROGRAM

Line 5759: from OKL_k_headers_full_V

5755: l_rbr_code okl_trx_contracts.rbr_code%type := null;
5756:
5757: cursor l_mla_csr is
5758: select id
5759: from OKL_k_headers_full_V
5760: where contract_number = p_mla_no
5761: and scs_code = 'MASTER_LEASE'
5762: and STS_CODE = 'ACTIVE'
5763: and TEMPLATE_YN = 'N'

Line 5783: from OKL_k_headers_full_V prg_hdr

5779: l_cl_id NUMBER;
5780:
5781: cursor l_program_csr is
5782: select id
5783: from OKL_k_headers_full_V prg_hdr
5784: where contract_number = p_program_no
5785: and scs_code = 'PROGRAM'
5786: and nvl(TEMPLATE_YN, 'N') = 'N'
5787: and sts_code = 'ACTIVE'

Line 5799: FROM okl_k_headers_full_v

5795: old_khr_id NUMBER;
5796:
5797: CURSOR c_vp_exsts_csr IS
5798: SELECT khr_id
5799: FROM okl_k_headers_full_v
5800: WHERE id = p_chr_id;
5801:
5802: CURSOR c_context_csr IS
5803: SELECT authoring_org_id, inv_organization_id

Line 5804: FROM okl_k_headers_full_V

5800: WHERE id = p_chr_id;
5801:
5802: CURSOR c_context_csr IS
5803: SELECT authoring_org_id, inv_organization_id
5804: FROM okl_k_headers_full_V
5805: WHERE id = p_chr_id;
5806:
5807: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5808: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

Line 6555: FROM okl_k_headers_full_v

6551: old_khr_id NUMBER;
6552:
6553: CURSOR c_vp_exsts_csr IS
6554: SELECT khr_id
6555: FROM okl_k_headers_full_v
6556: WHERE id = p_durv_rec.chr_id;
6557:
6558: l_fin_ast VARCHAR2(1) := 'N';
6559: l_lrls_yn VARCHAR2(1) := 'X';

Line 8094: FROM okl_k_headers_full_v

8090: -- orig_system_id1,
8091: currency_code,
8092: pdt_id,
8093: khr_id
8094: FROM okl_k_headers_full_v
8095: WHERE id = p_durv_rec.chr_id;
8096:
8097:
8098: CURSOR l_vers_version_csr IS

Line 8105: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8101: WHERE vers.chr_id = p_durv_rec.chr_id;
8102:
8103: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8104: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8105: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8106: WHERE mla.id = gvr.chr_id_referred
8107: AND mla.scs_code = p_scs_code -- mla or cl
8108: AND gvr.chr_id = p_durv_rec.chr_id
8109: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8158: FROM okl_k_headers_full_v

8154: WHERE currency_code = p_currency_code;
8155:
8156: CURSOR l_program_csr(program_id NUMBER) IS
8157: SELECT id,contract_number
8158: FROM okl_k_headers_full_v
8159: WHERE id = program_id;
8160:
8161: CURSOR l_contact_csr IS
8162: --Start modified abhsaxen for performance SQLID 20563327