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.

[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on FND_GLOBAL

Line 131: and resp_id=fnd_global.resp_id

127: Cursor Access_Level_csr is
128: Select access_level
129: from okc_subclass_resps_v
130: where scs_code=p_scs_code
131: and resp_id=fnd_global.resp_id
132: and sysdate between start_date and nvl(end_date,sysdate);
133:
134: l_access_level VARCHAR2(1);
135: l_return_val VARCHAR2(1) := 'N' ;

Line 4376: last_updated_by = FND_GLOBAL.USER_ID,

4372: -- Clear all source contract's date_renewed column
4373: UPDATE OKC_K_HEADERS_B
4374: SET date_renewed = null,
4375: object_version_number = object_version_number + 1,
4376: last_updated_by = FND_GLOBAL.USER_ID,
4377: last_update_date = sysdate,
4378: last_update_login = FND_GLOBAL.LOGIN_ID
4379: WHERE id in (
4380: SELECT distinct object_chr_id

Line 4378: last_update_login = FND_GLOBAL.LOGIN_ID

4374: SET date_renewed = null,
4375: object_version_number = object_version_number + 1,
4376: last_updated_by = FND_GLOBAL.USER_ID,
4377: last_update_date = sysdate,
4378: last_update_login = FND_GLOBAL.LOGIN_ID
4379: WHERE id in (
4380: SELECT distinct object_chr_id
4381: FROM okc_operation_lines
4382: WHERE subject_chr_id = p_target_chr_id

Line 4402: last_updated_by = FND_GLOBAL.USER_ID,

4398: If ( l_no_of_op_lines = l_no_of_lines ) Then
4399: UPDATE OKC_K_HEADERS_B
4400: SET date_renewed = sysdate,
4401: object_version_number = object_version_number + 1,
4402: last_updated_by = FND_GLOBAL.USER_ID,
4403: last_update_date = sysdate,
4404: last_update_login = FND_GLOBAL.LOGIN_ID
4405: WHERE id = ole_rec.object_chr_id;
4406:

Line 4404: last_update_login = FND_GLOBAL.LOGIN_ID

4400: SET date_renewed = sysdate,
4401: object_version_number = object_version_number + 1,
4402: last_updated_by = FND_GLOBAL.USER_ID,
4403: last_update_date = sysdate,
4404: last_update_login = FND_GLOBAL.LOGIN_ID
4405: WHERE id = ole_rec.object_chr_id;
4406:
4407: End If;
4408: END LOOP;

Line 4420: last_updated_by = FND_GLOBAL.USER_ID,

4416: --
4417: UPDATE okc_operation_lines ol
4418: SET active_yn = l_active_yn,
4419: object_version_number = object_version_number + 1,
4420: last_updated_by = FND_GLOBAL.USER_ID,
4421: last_update_date = sysdate,
4422: last_update_login = FND_GLOBAL.LOGIN_ID
4423: WHERE subject_chr_id = p_target_chr_id
4424: AND subject_cle_id is null

Line 4422: last_update_login = FND_GLOBAL.LOGIN_ID

4418: SET active_yn = l_active_yn,
4419: object_version_number = object_version_number + 1,
4420: last_updated_by = FND_GLOBAL.USER_ID,
4421: last_update_date = sysdate,
4422: last_update_login = FND_GLOBAL.LOGIN_ID
4423: WHERE subject_chr_id = p_target_chr_id
4424: AND subject_cle_id is null
4425: AND object_cle_id is null
4426: And exists(Select 'x' --Fix Bug 4948793

Line 4442: last_updated_by = FND_GLOBAL.USER_ID,

4438: --
4439: UPDATE OKC_K_LINES_B
4440: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
4441: object_version_number = object_version_number + 1,
4442: last_updated_by = FND_GLOBAL.USER_ID,
4443: last_update_date = sysdate,
4444: last_update_login = FND_GLOBAL.LOGIN_ID
4445: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4446: FROM okc_operation_instances op

Line 4444: last_update_login = FND_GLOBAL.LOGIN_ID

4440: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
4441: object_version_number = object_version_number + 1,
4442: last_updated_by = FND_GLOBAL.USER_ID,
4443: last_update_date = sysdate,
4444: last_update_login = FND_GLOBAL.LOGIN_ID
4445: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4446: FROM okc_operation_instances op
4447: , okc_class_operations cls
4448: , okc_subclasses_b sl

Line 4466: last_updated_by = FND_GLOBAL.USER_ID,

4462: --
4463: UPDATE okc_operation_lines ol
4464: SET active_yn = l_active_yn,
4465: object_version_number = object_version_number + 1,
4466: last_updated_by = FND_GLOBAL.USER_ID,
4467: last_update_date = sysdate,
4468: last_update_login = FND_GLOBAL.LOGIN_ID
4469: WHERE subject_chr_id = p_target_chr_id
4470: AND subject_cle_id is not null

Line 4468: last_update_login = FND_GLOBAL.LOGIN_ID

4464: SET active_yn = l_active_yn,
4465: object_version_number = object_version_number + 1,
4466: last_updated_by = FND_GLOBAL.USER_ID,
4467: last_update_date = sysdate,
4468: last_update_login = FND_GLOBAL.LOGIN_ID
4469: WHERE subject_chr_id = p_target_chr_id
4470: AND subject_cle_id is not null
4471: AND object_cle_id is not null
4472: And exists(Select 'x' --Fix Bug 4948793

Line 5280: last_updated_by = FND_GLOBAL.USER_ID,

5276:
5277: UPDATE okc_operation_lines
5278: SET active_yn = l_active_yn,
5279: object_version_number = object_version_number + 1,
5280: last_updated_by = FND_GLOBAL.USER_ID,
5281: last_update_date = sysdate,
5282: last_update_login = FND_GLOBAL.LOGIN_ID
5283:
5284: where subject_cle_id in ( select id

Line 5282: last_update_login = FND_GLOBAL.LOGIN_ID

5278: SET active_yn = l_active_yn,
5279: object_version_number = object_version_number + 1,
5280: last_updated_by = FND_GLOBAL.USER_ID,
5281: last_update_date = sysdate,
5282: last_update_login = FND_GLOBAL.LOGIN_ID
5283:
5284: where subject_cle_id in ( select id
5285: from okc_k_lines_b kle1
5286: start with kle1.id = p_target_line_id

Line 5298: last_updated_by = FND_GLOBAL.USER_ID,

5294:
5295: UPDATE OKC_K_LINES_B
5296: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5297: object_version_number = object_version_number + 1,
5298: last_updated_by = FND_GLOBAL.USER_ID,
5299: last_update_date = sysdate,
5300: last_update_login = FND_GLOBAL.LOGIN_ID
5301: WHERE id in
5302: ( SELECT object_cle_id

Line 5300: last_update_login = FND_GLOBAL.LOGIN_ID

5296: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5297: object_version_number = object_version_number + 1,
5298: last_updated_by = FND_GLOBAL.USER_ID,
5299: last_update_date = sysdate,
5300: last_update_login = FND_GLOBAL.LOGIN_ID
5301: WHERE id in
5302: ( SELECT object_cle_id
5303: FROM okc_operation_lines ol1
5304: WHERE ol1.subject_cle_id = p_target_line_id );

Line 5312: last_updated_by = FND_GLOBAL.USER_ID,

5308:
5309: UPDATE OKC_K_LINES_B
5310: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5311: object_version_number = object_version_number + 1,
5312: last_updated_by = FND_GLOBAL.USER_ID,
5313: last_update_date = sysdate,
5314: last_update_login = FND_GLOBAL.LOGIN_ID
5315: WHERE cle_id in
5316: ( SELECT object_cle_id

Line 5314: last_update_login = FND_GLOBAL.LOGIN_ID

5310: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5311: object_version_number = object_version_number + 1,
5312: last_updated_by = FND_GLOBAL.USER_ID,
5313: last_update_date = sysdate,
5314: last_update_login = FND_GLOBAL.LOGIN_ID
5315: WHERE cle_id in
5316: ( SELECT object_cle_id
5317: FROM okc_operation_lines ol1
5318: WHERE ol1.subject_cle_id = p_target_line_id );