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

Line 59: select application_id from okc_k_headers_b where id = p_chr_id;

55: from okc_k_lines_b
56: where dnz_chr_id = p_chr_id;
57:
58: cursor cur_headers(p_chr_id number) is
59: select application_id from okc_k_headers_b where id = p_chr_id;
60:
61: p_appl_id1 number;
62: cur_lines_rec cur_line%rowtype;
63:

Line 90: FROM okc_k_headers_b k,

86: p_contract_number_modifier IN VARCHAR2
87: ) is
88: CURSOR cur_auto_renew is
89: SELECT k.id,k.contract_number,k.contract_number_modifier,k.start_date,k.END_date,k.object_version_number
90: FROM okc_k_headers_b k,
91: okc_statuses_b sts
92: WHERE k.date_renewed is null
93: and k.sts_code = sts.code
94: and sts.ste_code in ('ACTIVE','EXPIRED','SIGNED')

Line 110: l_contract_number okc_k_headers_b.contract_number%TYPE;

106: l_return_status varchar2(1) := okc_api.g_ret_sts_success;
107: l_chr_id number;
108: l_timeunit okx_units_of_measure_v.uom_code%type;
109: l_duration number;
110: l_contract_number okc_k_headers_b.contract_number%TYPE;
111: l_msg_count Number;
112: l_msg Varchar2(2000);
113:
114: x_return_status varchar2(1) := okc_api.g_ret_sts_success;

Line 288: l_app_id okc_k_headers_b.application_id%TYPE;

284: l_status VARCHAR2(100) := '1';
285: l_cls_code VARCHAR2(100);
286: l_template_yn VARCHAR2(10);
287: l_code VARCHAR2(100);
288: l_app_id okc_k_headers_b.application_id%TYPE;
289: l_scs_code okc_k_headers_b.scs_code%TYPE;
290: --l_k okc_k_headers_b.contract_number%TYPE;
291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;

Line 289: l_scs_code okc_k_headers_b.scs_code%TYPE;

285: l_cls_code VARCHAR2(100);
286: l_template_yn VARCHAR2(10);
287: l_code VARCHAR2(100);
288: l_app_id okc_k_headers_b.application_id%TYPE;
289: l_scs_code okc_k_headers_b.scs_code%TYPE;
290: --l_k okc_k_headers_b.contract_number%TYPE;
291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
293: l_end_date okc_k_headers_b.end_date%TYPE;

Line 290: --l_k okc_k_headers_b.contract_number%TYPE;

286: l_template_yn VARCHAR2(10);
287: l_code VARCHAR2(100);
288: l_app_id okc_k_headers_b.application_id%TYPE;
289: l_scs_code okc_k_headers_b.scs_code%TYPE;
290: --l_k okc_k_headers_b.contract_number%TYPE;
291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
293: l_end_date okc_k_headers_b.end_date%TYPE;
294: l_date_terminated okc_k_headers_b.date_terminated%TYPE;

Line 292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;

288: l_app_id okc_k_headers_b.application_id%TYPE;
289: l_scs_code okc_k_headers_b.scs_code%TYPE;
290: --l_k okc_k_headers_b.contract_number%TYPE;
291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
293: l_end_date okc_k_headers_b.end_date%TYPE;
294: l_date_terminated okc_k_headers_b.date_terminated%TYPE;
295: l_start_date okc_k_headers_b.start_date%TYPE;
296: x_msg_count number;

Line 293: l_end_date okc_k_headers_b.end_date%TYPE;

289: l_scs_code okc_k_headers_b.scs_code%TYPE;
290: --l_k okc_k_headers_b.contract_number%TYPE;
291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
293: l_end_date okc_k_headers_b.end_date%TYPE;
294: l_date_terminated okc_k_headers_b.date_terminated%TYPE;
295: l_start_date okc_k_headers_b.start_date%TYPE;
296: x_msg_count number;
297: x_msg_data VARCHAR2(3000);

Line 294: l_date_terminated okc_k_headers_b.date_terminated%TYPE;

290: --l_k okc_k_headers_b.contract_number%TYPE;
291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
293: l_end_date okc_k_headers_b.end_date%TYPE;
294: l_date_terminated okc_k_headers_b.date_terminated%TYPE;
295: l_start_date okc_k_headers_b.start_date%TYPE;
296: x_msg_count number;
297: x_msg_data VARCHAR2(3000);
298: l_rnrl_rec OKS_RENEW_UTIL_PVT.RNRL_REC_TYPE;

Line 295: l_start_date okc_k_headers_b.start_date%TYPE;

291: l_k VARCHAR2(255);
292: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
293: l_end_date okc_k_headers_b.end_date%TYPE;
294: l_date_terminated okc_k_headers_b.date_terminated%TYPE;
295: l_start_date okc_k_headers_b.start_date%TYPE;
296: x_msg_count number;
297: x_msg_data VARCHAR2(3000);
298: l_rnrl_rec OKS_RENEW_UTIL_PVT.RNRL_REC_TYPE;
299: x_rnrl_rec OKS_RENEW_UTIL_PVT.RNRL_REC_TYPE;

Line 308: FROM okc_k_headers_b

304:
305: CURSOR c_chr IS
306: SELECT sts_code,template_yn, application_id, scs_code,contract_number,
307: contract_number_modifier,end_date,date_terminated, start_date
308: FROM okc_k_headers_b
309: WHERE id = p_chr_id;
310:
311: CURSOR cur_status(p_code IN VARCHAR2) IS
312: SELECT ste_code

Line 480: FROM okc_k_headers_b

476: TEMPLATE_YN,
477: DATE_TERMINATED,
478: DATE_RENEWED,
479: END_DATE
480: FROM okc_k_headers_b
481: WHERE id = p_renew_in_parameters_rec.p_contract_id;
482:
483: CURSOR cur_status(p_sts_code varchar2) is
484: SELECT ste_code,meaning

Line 1398: FROM okc_k_headers_b

1394: p_chr_id IN number) is
1395:
1396: CURSOR cur_header(p_chr_id number) is
1397: SELECT id,object_version_number
1398: FROM okc_k_headers_b
1399: WHERE id = p_chr_id;
1400:
1401: CURSOR cur_lines(p_chr_id number) is
1402: SELECT a.id,b.id cle_id_ren_to ,a.object_version_number

Line 1642: from okc_k_headers_b

1638:
1639: --/Rules Migration/-added application id
1640: CURSOR cur_headers is
1641: Select start_date,end_date,object_version_number,application_id
1642: from okc_k_headers_b
1643: where id = p_chr_id;
1644:
1645: CURSOR cur_lines(p_id number) is
1646: SELECT id,object_version_number,start_date,end_date,level,cle_id

Line 2199: UPDATE OKC_K_HEADERS_B

2195: -- level estimated amount
2196: -- Not calling Update Contract api for performance reason as well as it is a process api
2197: -- donot need to do all the validation for updating the price
2198:
2199: UPDATE OKC_K_HEADERS_B
2200: set estimated_amount = estimated_amount - l_cle_tbl(j).price_negotiated
2201: WHERE id = p_chr_id;
2202: -- Adding for bug 2084147 - End
2203:

Line 2448: from OKC_K_HEADERS_b

2444:
2445: --/Rules migration/ replaced by cursor below
2446: /*
2447: CURSOR cur_qa(p_chr_id number) is select nvl(qcl_id,OKC_API.G_MISS_NUM)
2448: from OKC_K_HEADERS_b
2449: where id=p_chr_id;
2450: */
2451:
2452:

Line 2457: from OKC_K_HEADERS_b

2453: CURSOR cur_header(p_chr_id number) is
2454: select nvl(qcl_id,OKC_API.G_MISS_NUM) qcl_id,
2455: nvl(renewal_type_code,OKC_API.G_MISS_CHAR) renewal_type_code,renewal_notify_to,
2456: application_id
2457: from OKC_K_HEADERS_b
2458: where id=p_chr_id;
2459:
2460: CURSOR cur_wf(p_chr_id number)
2461: is select pdf_id from okc_k_processes kp, okc_process_defs_b pd where

Line 2470: FROM OKC_K_HEADERS_B K,

2466: fnd.user_id=res.user_id and res.id1=p_user_id;
2467:
2468: CURSOR cur_header_aa IS
2469: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
2470: FROM OKC_K_HEADERS_B K,
2471: OKC_SUBCLASSES_B SCS
2472: WHERE k.id = p_renew_in_parameters_rec.p_contract_id
2473: AND k.scs_code = scs.code;
2474:

Line 2476: select start_date,end_date from okc_k_headers_b where

2472: WHERE k.id = p_renew_in_parameters_rec.p_contract_id
2473: AND k.scs_code = scs.code;
2474:
2475: CURSOR cur_startend(p_chr_id number) is
2476: select start_date,end_date from okc_k_headers_b where
2477: id=p_chr_id;
2478:
2479: l_scs_code okc_subclasses_v.code%type;
2480: l_cls_code okc_subclasses_v.cls_code%type;

Line 3019: from okc_k_headers_b

3015:
3016: --commented /rules migration/
3017: --replaced by cur_header
3018: /*cursor cur_org is select authoring_org_id,inv_organization_id
3019: from okc_k_headers_b
3020: where id = p_renew_in_parameters_rec.p_contract_id;*/
3021:
3022: -- /rules migration/
3023: Cursor cur_header is

Line 3027: from okc_k_headers_b

3023: Cursor cur_header is
3024: select authoring_org_id,inv_organization_id,application_id,
3025: nvl(renewal_type_code,OKC_API.G_MISS_CHAR) renewal_type_code,
3026: renewal_end_date
3027: from okc_k_headers_b
3028: where id = p_renew_in_parameters_rec.p_contract_id;
3029:
3030: cur_header_rec cur_header%rowtype;
3031: --

Line 3032: r_org OKC_K_HEADERS_B.authoring_org_id%type;

3028: where id = p_renew_in_parameters_rec.p_contract_id;
3029:
3030: cur_header_rec cur_header%rowtype;
3031: --
3032: r_org OKC_K_HEADERS_B.authoring_org_id%type;
3033: r_inv_org OKC_K_HEADERS_B.inv_organization_id%type;
3034:
3035: FUNCTION set_attributes(p_renew_in_rec IN OUT NOCOPY renew_in_parameters_rec) RETURN varchar2 is
3036:

Line 3033: r_inv_org OKC_K_HEADERS_B.inv_organization_id%type;

3029:
3030: cur_header_rec cur_header%rowtype;
3031: --
3032: r_org OKC_K_HEADERS_B.authoring_org_id%type;
3033: r_inv_org OKC_K_HEADERS_B.inv_organization_id%type;
3034:
3035: FUNCTION set_attributes(p_renew_in_rec IN OUT NOCOPY renew_in_parameters_rec) RETURN varchar2 is
3036:
3037: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3516: from okc_k_headers_b

3512: raise OKC_API.G_EXCEPTION_ERROR;
3513: END IF;
3514: -- Raising an exception when the contract header id is invalid
3515: select count(*) into l_invalid_chr_id
3516: from okc_k_headers_b
3517: where id = p_chr_id;
3518:
3519: if (l_invalid_chr_id = 0) Then
3520: RAISE Contract_Not_Found;

Line 3599: update okc_k_headers_b

3595:
3596: -- If Date_Renewed is not null for all the top lines
3597: If l_top_date_count = 0 Then
3598: -- Update Date_Renewed field of contract header
3599: update okc_k_headers_b
3600: set date_renewed = ( select MAX(date_renewed)
3601: from okc_k_lines_b
3602: where chr_id = p_chr_id )
3603: where id = p_chr_id;

Line 3692: FROM okc_k_headers_b k,okc_statuses_b s

3688: be displayed. */
3689:
3690: Cursor cur_ren(p_chr_id number) is
3691: SELECT CONTRACT_NUMBER,CONTRACT_NUMBER_MODIFIER,ste_code
3692: FROM okc_k_headers_b k,okc_statuses_b s
3693: where k.id=p_chr_id and k.sts_code=s.code;
3694:
3695: k_ren_rec cur_ren%rowtype;
3696: l_id number:=OKC_API.G_MISS_NUM;