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

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

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

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

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

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

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

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

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

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

Line 2718: FROM okl_k_headers_full_v

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

Line 4623: FROM okl_k_headers_full_v CHR

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

Line 4713: FROM okl_k_headers_full_v CHR

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

Line 4722: FROM okl_k_headers_full_v chr

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

Line 4733: FROM okl_k_headers_full_v CHR

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

Line 4750: FROM okl_k_headers_full_v CHR

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

Line 5857: from OKL_k_headers_full_V

5853: l_rbr_code okl_trx_contracts.rbr_code%type := null;
5854:
5855: cursor l_mla_csr is
5856: select id
5857: from OKL_k_headers_full_V
5858: where contract_number = p_mla_no
5859: and scs_code = 'MASTER_LEASE'
5860: and STS_CODE = 'ACTIVE'
5861: and TEMPLATE_YN = 'N'

Line 5881: from OKL_k_headers_full_V prg_hdr

5877: l_cl_id NUMBER;
5878:
5879: cursor l_program_csr is
5880: select id
5881: from OKL_k_headers_full_V prg_hdr
5882: where contract_number = p_program_no
5883: and scs_code = 'PROGRAM'
5884: and nvl(TEMPLATE_YN, 'N') = 'N'
5885: and sts_code = 'ACTIVE'

Line 5897: FROM okl_k_headers_full_v

5893: old_khr_id NUMBER;
5894:
5895: CURSOR c_vp_exsts_csr IS
5896: SELECT khr_id
5897: FROM okl_k_headers_full_v
5898: WHERE id = p_chr_id;
5899:
5900: CURSOR c_context_csr IS
5901: SELECT authoring_org_id, inv_organization_id

Line 5902: FROM okl_k_headers_full_V

5898: WHERE id = p_chr_id;
5899:
5900: CURSOR c_context_csr IS
5901: SELECT authoring_org_id, inv_organization_id
5902: FROM okl_k_headers_full_V
5903: WHERE id = p_chr_id;
5904:
5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

Line 6672: FROM okl_k_headers_full_v

6668: old_khr_id NUMBER;
6669:
6670: CURSOR c_vp_exsts_csr IS
6671: SELECT khr_id
6672: FROM okl_k_headers_full_v
6673: WHERE id = p_durv_rec.chr_id;
6674:
6675: l_fin_ast VARCHAR2(1) := 'N';
6676: l_lrls_yn VARCHAR2(1) := 'X';

Line 8289: FROM okl_k_headers_full_v

8285: -- orig_system_id1,
8286: currency_code,
8287: pdt_id,
8288: khr_id
8289: FROM okl_k_headers_full_v
8290: WHERE id = p_durv_rec.chr_id;
8291:
8292:
8293: CURSOR l_vers_version_csr IS

Line 8300: FROM okl_k_headers_full_v mla, okc_governances_v gvr

8296: WHERE vers.chr_id = p_durv_rec.chr_id;
8297:
8298: CURSOR l_gvr_csr(p_scs_code VARCHAR2) IS
8299: SELECT mla.contract_number, gvr.chr_id_referred, gvr.id
8300: FROM okl_k_headers_full_v mla, okc_governances_v gvr
8301: WHERE mla.id = gvr.chr_id_referred
8302: AND mla.scs_code = p_scs_code -- mla or cl
8303: AND gvr.chr_id = p_durv_rec.chr_id
8304: AND gvr.dnz_chr_id = p_durv_rec.chr_id;

Line 8353: FROM okl_k_headers_full_v

8349: WHERE currency_code = p_currency_code;
8350:
8351: CURSOR l_program_csr(program_id NUMBER) IS
8352: SELECT id,contract_number
8353: FROM okl_k_headers_full_v
8354: WHERE id = program_id;
8355:
8356: CURSOR l_contact_csr IS
8357: --Start modified abhsaxen for performance SQLID 20563327

Line 8944: FROM okl_k_headers_full_v

8940: l_hdr_uv_rec c_hdr_full_uv%ROWTYPE;
8941:
8942: CURSOR c_hdr_full_v(p_chr_id OKC_K_HEADERS_ALL_B.ID%TYPE) IS
8943: SELECT *
8944: FROM okl_k_headers_full_v
8945: WHERE id = p_chr_id;
8946:
8947: l_hdr_rec c_hdr_full_v%ROWTYPE;
8948:

Line 8963: FROM okl_k_headers_full_v mla,

8959: CURSOR c_gvr_data(p_scs_code VARCHAR2,
8960: p_chr_id NUMBER,
8961: p_dnz_chr_id NUMBER) IS
8962: SELECT mla.contract_number,gvr.chr_id_referred,gvr.id
8963: FROM okl_k_headers_full_v mla,
8964: okc_governances_v gvr
8965: WHERE mla.id = gvr.chr_id_referred
8966: AND mla.scs_code = p_scs_code
8967: AND gvr.dnz_chr_id = p_dnz_chr_id

Line 9017: FROM okl_k_headers_full_v chr

9013: AND lsq.status = 'CT-ACCEPTED';
9014:
9015: CURSOR c_program_template_name(p_orig_system_id1 NUMBER, p_khr_khr_id NUMBER) IS
9016: SELECT chr.contract_number
9017: FROM okl_k_headers_full_v chr
9018: WHERE chr.id = p_orig_system_id1
9019: AND chr.template_type_code = 'PROGRAM'
9020: AND NVL(chr.template_yn,'N') = 'Y'
9021: AND EXISTS(SELECT 1