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.OKS_SETUP_UTIL_PUB dependencies on OKC_K_HEADERS_B

Line 314: FROM okc_k_headers_b

310: -- 8/5/2005 hkamdar R12 Partial Period Project
311: -- Added new cursor to fetch the org id for the contract
312: CURSOR get_org_id_csr (p_new_chr_id NUMBER) IS
313: SELECT org_id
314: FROM okc_k_headers_b
315: WHERE id = p_new_chr_id;
316:
317: l_period_type varchar2(30):=null;
318: l_period_start varchar2(30):=null;

Line 645: from okc_k_headers_b

641: WHERE id = p_cle_id;
642: -- Added for price lock
643: cursor get_contract_number(l_chr_id number) is
644: select contract_number
645: from okc_k_headers_b
646: where id = l_chr_id;
647:
648: l_contract_number VARCHAR2(120);
649: l_old_price_list_id number;

Line 1019: FROM okc_k_headers_b

1015: strlvl_rec strlvl_csr%ROWTYPE;
1016:
1017: cursor hdr_csr (p_chr_id Number) Is
1018: SELECT start_date
1019: FROM okc_k_headers_b
1020: WHERE id = p_chr_id;
1021:
1022:
1023: Begin

Line 1474: FROM okc_k_headers_b

1470:
1471: -- get original chr_id
1472: Cursor get_old_chr_id IS
1473: SELECT orig_system_id1
1474: FROM okc_k_headers_b
1475: WHERE id = p_new_chr_id;
1476:
1477: -- If the new_chrId is from a renewed contract this cursor will return a record.
1478: -- It will not return any records if new_chrId is from a copied contract.

Line 2201: FROM okc_k_headers_b

2197: IS
2198:
2199: CURSOR l_chr_renew_csr (l_new_chr_id NUMBER) IS
2200: SELECT start_date,end_date,orig_system_id1
2201: FROM okc_k_headers_b
2202: WHERE id = l_new_chr_id;
2203:
2204: l_chr_renew_rec l_chr_renew_csr%ROWTYPE;
2205:

Line 2208: FROM okc_k_headers_b

2204: l_chr_renew_rec l_chr_renew_csr%ROWTYPE;
2205:
2206: CURSOR l_chr_old_csr (l_old_chr_id NUMBER) IS
2207: SELECT start_date,end_date
2208: FROM okc_k_headers_b
2209: WHERE id = l_old_chr_id;
2210:
2211:
2212: l_chr_old_rec l_chr_old_csr%ROWTYPE;

Line 2629: from okc_k_headers_b

2625: AND lines.lse_id IN (12,13);
2626:
2627: cursor get_contract_number(l_chr_id number) is
2628: select contract_number
2629: from okc_k_headers_b
2630: where id = l_chr_id;
2631:
2632: -- End added for price lock project
2633:

Line 2649: FROM okc_k_headers_b

2645:
2646: /*
2647: CURSOR get_old_chr_id_csr (p_chr_id NUMBER) IS
2648: SELECT orig_system_id1
2649: FROM okc_k_headers_b
2650: WHERE id = p_chr_id;
2651: */
2652: CURSOR get_status_csr (l_chr_id NUMBER) IS
2653: SELECT b.ste_code, orig_system_id1

Line 2654: FROM okc_k_headers_b a, okc_statuses_b b

2650: WHERE id = p_chr_id;
2651: */
2652: CURSOR get_status_csr (l_chr_id NUMBER) IS
2653: SELECT b.ste_code, orig_system_id1
2654: FROM okc_k_headers_b a, okc_statuses_b b
2655: WHERE a.id = l_chr_id
2656: and a.sts_code = b.code;
2657:
2658:

Line 2723: FROM okc_k_headers_b

2719: -- 05-Aug-2005 hkamdar Added for R12 Partial Period Project
2720: -- This cursor fetches the Contract Id belonging to Original contract
2721: CURSOR get_old_id_csr (p_new_chr_id NUMBER) IS
2722: SELECT orig_system_id1
2723: FROM okc_k_headers_b
2724: WHERE id = p_new_chr_id;
2725:
2726: -- New Variables
2727: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;

Line 3432: update okc_k_headers_b set

3428: -- Added for updating top line price_negotiated for copy
3429: IF p_upd_line_flag IS NULL and p_chr_id is not null THEN
3430:
3431: -- Get the sum of all the top lines.
3432: update okc_k_headers_b set
3433: estimated_amount =
3434: (select sum(price_negotiated) from okc_k_lines_b
3435: where dnz_chr_id = p_chr_id and cle_id is null)
3436: where id = p_chr_id;

Line 3633: SELECT id from okc_k_headers_b

3629:
3630: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3631:
3632: Cursor l_csr_header IS
3633: SELECT id from okc_k_headers_b
3634: WHERE scs_code in ('SERVICE','WARRANTY')
3635: AND id =p_chr_id;
3636:
3637: Cursor l_csr_top_line(p_chr_id NUMBER) IS

Line 3770: FROM okc_k_headers_b

3766:
3767: Cursor get_org_values IS
3768: SELECT inv_organization_id,
3769: authoring_org_id
3770: FROM okc_k_headers_b
3771: WHERE id=p_chr_id;
3772:
3773: Cursor l_hdr_svc_csr Is
3774: SELECT ctc.object1_id1 ,

Line 4705: From okc_k_headers_b b

4701:
4702:
4703: Cursor cur_get_contract_number(p_subject_chr_id number) IS
4704: SELECT contract_number , contract_number_modifier
4705: From okc_k_headers_b b
4706: where id = p_subject_chr_id;
4707:
4708: l_result NUMBER;
4709: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;

Line 4711: l_contract_number OKC_K_HEADERS_B.contract_number%type;

4707:
4708: l_result NUMBER;
4709: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;
4710: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;
4711: l_contract_number OKC_K_HEADERS_B.contract_number%type;
4712: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;
4713:
4714: BEGIN
4715: IF p_chr_id IS NOT NULL AND p_cle_id IS NULL

Line 4712: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;

4708: l_result NUMBER;
4709: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;
4710: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;
4711: l_contract_number OKC_K_HEADERS_B.contract_number%type;
4712: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;
4713:
4714: BEGIN
4715: IF p_chr_id IS NOT NULL AND p_cle_id IS NULL
4716: THEN