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 650: from okc_k_headers_b

646: WHERE id = p_cle_id;
647: -- Added for price lock
648: cursor get_contract_number(l_chr_id number) is
649: select contract_number
650: from okc_k_headers_b
651: where id = l_chr_id;
652:
653: l_contract_number VARCHAR2(120);
654: l_old_price_list_id number;

Line 1027: FROM okc_k_headers_b

1023: strlvl_rec strlvl_csr%ROWTYPE;
1024:
1025: cursor hdr_csr (p_chr_id Number) Is
1026: SELECT start_date
1027: FROM okc_k_headers_b
1028: WHERE id = p_chr_id;
1029:
1030:
1031: Begin

Line 1482: FROM okc_k_headers_b

1478:
1479: -- get original chr_id
1480: Cursor get_old_chr_id IS
1481: SELECT orig_system_id1
1482: FROM okc_k_headers_b
1483: WHERE id = p_new_chr_id;
1484:
1485: -- If the new_chrId is from a renewed contract this cursor will return a record.
1486: -- It will not return any records if new_chrId is from a copied contract.

Line 2210: FROM okc_k_headers_b

2206: IS
2207:
2208: CURSOR l_chr_renew_csr (l_new_chr_id NUMBER) IS
2209: SELECT start_date,end_date,orig_system_id1
2210: FROM okc_k_headers_b
2211: WHERE id = l_new_chr_id;
2212:
2213: l_chr_renew_rec l_chr_renew_csr%ROWTYPE;
2214:

Line 2217: FROM okc_k_headers_b

2213: l_chr_renew_rec l_chr_renew_csr%ROWTYPE;
2214:
2215: CURSOR l_chr_old_csr (l_old_chr_id NUMBER) IS
2216: SELECT start_date,end_date
2217: FROM okc_k_headers_b
2218: WHERE id = l_old_chr_id;
2219:
2220:
2221: l_chr_old_rec l_chr_old_csr%ROWTYPE;

Line 2638: from okc_k_headers_b

2634: AND lines.lse_id IN (12,13);
2635:
2636: cursor get_contract_number(l_chr_id number) is
2637: select contract_number
2638: from okc_k_headers_b
2639: where id = l_chr_id;
2640:
2641: -- End added for price lock project
2642:

Line 2658: FROM okc_k_headers_b

2654:
2655: /*
2656: CURSOR get_old_chr_id_csr (p_chr_id NUMBER) IS
2657: SELECT orig_system_id1
2658: FROM okc_k_headers_b
2659: WHERE id = p_chr_id;
2660: */
2661: CURSOR get_status_csr (l_chr_id NUMBER) IS
2662: SELECT b.ste_code, orig_system_id1

Line 2663: FROM okc_k_headers_b a, okc_statuses_b b

2659: WHERE id = p_chr_id;
2660: */
2661: CURSOR get_status_csr (l_chr_id NUMBER) IS
2662: SELECT b.ste_code, orig_system_id1
2663: FROM okc_k_headers_b a, okc_statuses_b b
2664: WHERE a.id = l_chr_id
2665: and a.sts_code = b.code;
2666:
2667:

Line 2732: FROM okc_k_headers_b

2728: -- 05-Aug-2005 hkamdar Added for R12 Partial Period Project
2729: -- This cursor fetches the Contract Id belonging to Original contract
2730: CURSOR get_old_id_csr (p_new_chr_id NUMBER) IS
2731: SELECT orig_system_id1
2732: FROM okc_k_headers_b
2733: WHERE id = p_new_chr_id;
2734:
2735: -- New Variables
2736: l_new_period_type OKS_K_HEADERS_B.period_type%TYPE;

Line 3441: update okc_k_headers_b set

3437: -- Added for updating top line price_negotiated for copy
3438: IF p_upd_line_flag IS NULL and p_chr_id is not null THEN
3439:
3440: -- Get the sum of all the top lines.
3441: update okc_k_headers_b set
3442: estimated_amount =
3443: (select sum(price_negotiated) from okc_k_lines_b
3444: where dnz_chr_id = p_chr_id and cle_id is null)
3445: where id = p_chr_id;

Line 3642: SELECT id from okc_k_headers_b

3638:
3639: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3640:
3641: Cursor l_csr_header IS
3642: SELECT id from okc_k_headers_b
3643: WHERE scs_code in ('SERVICE','WARRANTY')
3644: AND id =p_chr_id;
3645:
3646: Cursor l_csr_top_line(p_chr_id NUMBER) IS

Line 3779: FROM okc_k_headers_b

3775:
3776: Cursor get_org_values IS
3777: SELECT inv_organization_id,
3778: authoring_org_id
3779: FROM okc_k_headers_b
3780: WHERE id=p_chr_id;
3781:
3782: Cursor l_hdr_svc_csr Is
3783: SELECT ctc.object1_id1 ,

Line 4714: From okc_k_headers_b b

4710:
4711:
4712: Cursor cur_get_contract_number(p_subject_chr_id number) IS
4713: SELECT contract_number , contract_number_modifier
4714: From okc_k_headers_b b
4715: where id = p_subject_chr_id;
4716:
4717: l_result NUMBER;
4718: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;

Line 4720: l_contract_number OKC_K_HEADERS_B.contract_number%type;

4716:
4717: l_result NUMBER;
4718: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;
4719: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;
4720: l_contract_number OKC_K_HEADERS_B.contract_number%type;
4721: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;
4722:
4723: BEGIN
4724: IF p_chr_id IS NOT NULL AND p_cle_id IS NULL

Line 4721: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;

4717: l_result NUMBER;
4718: l_sub_cle_id okc_operation_lines.subject_cle_id%TYPE;
4719: l_sub_chr_id okc_operation_lines.subject_chr_id%TYPE;
4720: l_contract_number OKC_K_HEADERS_B.contract_number%type;
4721: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type;
4722:
4723: BEGIN
4724: IF p_chr_id IS NOT NULL AND p_cle_id IS NULL
4725: THEN