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 2556: FROM okl_k_headers_full_v

2552: --Cursor to get vp template
2553: CURSOR vp_tmpl_csr(p_vp_id IN NUMBER) IS
2554: /* Modified this query to improve performance for bug#6979120
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 2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;

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

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

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

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

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

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

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

Line 2730: FROM okl_k_headers_full_v

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

Line 4642: FROM okl_k_headers_full_v CHR

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

Line 4732: FROM okl_k_headers_full_v CHR

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

Line 4741: FROM okl_k_headers_full_v chr

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

Line 4752: FROM okl_k_headers_full_v CHR

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

Line 4769: FROM okl_k_headers_full_v CHR

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

Line 5756: from OKL_k_headers_full_V

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

Line 5780: from OKL_k_headers_full_V prg_hdr

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

Line 5796: FROM okl_k_headers_full_v

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

Line 5801: FROM okl_k_headers_full_V

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

Line 6552: FROM okl_k_headers_full_v

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

Line 8085: FROM okl_k_headers_full_v

8081: -- orig_system_id1,
8082: currency_code,
8083: pdt_id,
8084: khr_id
8085: FROM okl_k_headers_full_v
8086: WHERE id = p_durv_rec.chr_id;
8087:
8088:
8089: CURSOR l_vers_version_csr IS

Line 8096: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8092: WHERE vers.chr_id = p_durv_rec.chr_id;
8093:
8094: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8095: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8096: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8097: WHERE mla.id = gvr.chr_id_referred
8098: AND mla.scs_code = p_scs_code -- mla or cl
8099: AND gvr.chr_id = p_durv_rec.chr_id
8100: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8149: FROM okl_k_headers_full_v

8145: WHERE currency_code = p_currency_code;
8146:
8147: CURSOR l_program_csr(program_id NUMBER) IS
8148: SELECT id,contract_number
8149: FROM okl_k_headers_full_v
8150: WHERE id = program_id;
8151:
8152: CURSOR l_contact_csr IS
8153: --Start modified abhsaxen for performance SQLID 20563327