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_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 4318: last_updated_by = FND_GLOBAL.USER_ID,

4314: -- Clear all source contract's date_renewed column
4315: UPDATE OKC_K_HEADERS_B
4316: SET date_renewed = null,
4317: object_version_number = object_version_number + 1,
4318: last_updated_by = FND_GLOBAL.USER_ID,
4319: last_update_date = sysdate,
4320: last_update_login = FND_GLOBAL.LOGIN_ID
4321: WHERE id in (
4322: SELECT distinct object_chr_id

Line 4320: last_update_login = FND_GLOBAL.LOGIN_ID

4316: SET date_renewed = null,
4317: object_version_number = object_version_number + 1,
4318: last_updated_by = FND_GLOBAL.USER_ID,
4319: last_update_date = sysdate,
4320: last_update_login = FND_GLOBAL.LOGIN_ID
4321: WHERE id in (
4322: SELECT distinct object_chr_id
4323: FROM okc_operation_lines
4324: WHERE subject_chr_id = p_target_chr_id

Line 4344: last_updated_by = FND_GLOBAL.USER_ID,

4340: If ( l_no_of_op_lines = l_no_of_lines ) Then
4341: UPDATE OKC_K_HEADERS_B
4342: SET date_renewed = sysdate,
4343: object_version_number = object_version_number + 1,
4344: last_updated_by = FND_GLOBAL.USER_ID,
4345: last_update_date = sysdate,
4346: last_update_login = FND_GLOBAL.LOGIN_ID
4347: WHERE id = ole_rec.object_chr_id;
4348:

Line 4346: last_update_login = FND_GLOBAL.LOGIN_ID

4342: SET date_renewed = sysdate,
4343: object_version_number = object_version_number + 1,
4344: last_updated_by = FND_GLOBAL.USER_ID,
4345: last_update_date = sysdate,
4346: last_update_login = FND_GLOBAL.LOGIN_ID
4347: WHERE id = ole_rec.object_chr_id;
4348:
4349: End If;
4350: END LOOP;

Line 4362: last_updated_by = FND_GLOBAL.USER_ID,

4358: --
4359: UPDATE okc_operation_lines ol
4360: SET active_yn = l_active_yn,
4361: object_version_number = object_version_number + 1,
4362: last_updated_by = FND_GLOBAL.USER_ID,
4363: last_update_date = sysdate,
4364: last_update_login = FND_GLOBAL.LOGIN_ID
4365: WHERE subject_chr_id = p_target_chr_id
4366: AND subject_cle_id is null

Line 4364: last_update_login = FND_GLOBAL.LOGIN_ID

4360: SET active_yn = l_active_yn,
4361: object_version_number = object_version_number + 1,
4362: last_updated_by = FND_GLOBAL.USER_ID,
4363: last_update_date = sysdate,
4364: last_update_login = FND_GLOBAL.LOGIN_ID
4365: WHERE subject_chr_id = p_target_chr_id
4366: AND subject_cle_id is null
4367: AND object_cle_id is null
4368: And exists(Select 'x' --Fix Bug 4948793

Line 4384: last_updated_by = FND_GLOBAL.USER_ID,

4380: --
4381: UPDATE OKC_K_LINES_B
4382: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
4383: object_version_number = object_version_number + 1,
4384: last_updated_by = FND_GLOBAL.USER_ID,
4385: last_update_date = sysdate,
4386: last_update_login = FND_GLOBAL.LOGIN_ID
4387: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4388: FROM okc_operation_instances op

Line 4386: last_update_login = FND_GLOBAL.LOGIN_ID

4382: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
4383: object_version_number = object_version_number + 1,
4384: last_updated_by = FND_GLOBAL.USER_ID,
4385: last_update_date = sysdate,
4386: last_update_login = FND_GLOBAL.LOGIN_ID
4387: WHERE id in (Select ol.object_cle_id --Fix Bug 4948793
4388: FROM okc_operation_instances op
4389: , okc_class_operations cls
4390: , okc_subclasses_b sl

Line 4408: last_updated_by = FND_GLOBAL.USER_ID,

4404: --
4405: UPDATE okc_operation_lines ol
4406: SET active_yn = l_active_yn,
4407: object_version_number = object_version_number + 1,
4408: last_updated_by = FND_GLOBAL.USER_ID,
4409: last_update_date = sysdate,
4410: last_update_login = FND_GLOBAL.LOGIN_ID
4411: WHERE subject_chr_id = p_target_chr_id
4412: AND subject_cle_id is not null

Line 4410: last_update_login = FND_GLOBAL.LOGIN_ID

4406: SET active_yn = l_active_yn,
4407: object_version_number = object_version_number + 1,
4408: last_updated_by = FND_GLOBAL.USER_ID,
4409: last_update_date = sysdate,
4410: last_update_login = FND_GLOBAL.LOGIN_ID
4411: WHERE subject_chr_id = p_target_chr_id
4412: AND subject_cle_id is not null
4413: AND object_cle_id is not null
4414: And exists(Select 'x' --Fix Bug 4948793

Line 5118: last_updated_by = FND_GLOBAL.USER_ID,

5114:
5115: UPDATE okc_operation_lines
5116: SET active_yn = l_active_yn,
5117: object_version_number = object_version_number + 1,
5118: last_updated_by = FND_GLOBAL.USER_ID,
5119: last_update_date = sysdate,
5120: last_update_login = FND_GLOBAL.LOGIN_ID
5121:
5122: where subject_cle_id in ( select id

Line 5120: last_update_login = FND_GLOBAL.LOGIN_ID

5116: SET active_yn = l_active_yn,
5117: object_version_number = object_version_number + 1,
5118: last_updated_by = FND_GLOBAL.USER_ID,
5119: last_update_date = sysdate,
5120: last_update_login = FND_GLOBAL.LOGIN_ID
5121:
5122: where subject_cle_id in ( select id
5123: from okc_k_lines_b kle1
5124: start with kle1.id = p_target_line_id

Line 5136: last_updated_by = FND_GLOBAL.USER_ID,

5132:
5133: UPDATE OKC_K_LINES_B
5134: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5135: object_version_number = object_version_number + 1,
5136: last_updated_by = FND_GLOBAL.USER_ID,
5137: last_update_date = sysdate,
5138: last_update_login = FND_GLOBAL.LOGIN_ID
5139: WHERE id in
5140: ( SELECT object_cle_id

Line 5138: last_update_login = FND_GLOBAL.LOGIN_ID

5134: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5135: object_version_number = object_version_number + 1,
5136: last_updated_by = FND_GLOBAL.USER_ID,
5137: last_update_date = sysdate,
5138: last_update_login = FND_GLOBAL.LOGIN_ID
5139: WHERE id in
5140: ( SELECT object_cle_id
5141: FROM okc_operation_lines ol1
5142: WHERE ol1.subject_cle_id = p_target_line_id );

Line 5150: last_updated_by = FND_GLOBAL.USER_ID,

5146:
5147: UPDATE OKC_K_LINES_B
5148: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5149: object_version_number = object_version_number + 1,
5150: last_updated_by = FND_GLOBAL.USER_ID,
5151: last_update_date = sysdate,
5152: last_update_login = FND_GLOBAL.LOGIN_ID
5153: WHERE cle_id in
5154: ( SELECT object_cle_id

Line 5152: last_update_login = FND_GLOBAL.LOGIN_ID

5148: SET date_renewed = decode(l_active_yn,'Y',sysdate,null),
5149: object_version_number = object_version_number + 1,
5150: last_updated_by = FND_GLOBAL.USER_ID,
5151: last_update_date = sysdate,
5152: last_update_login = FND_GLOBAL.LOGIN_ID
5153: WHERE cle_id in
5154: ( SELECT object_cle_id
5155: FROM okc_operation_lines ol1
5156: WHERE ol1.subject_cle_id = p_target_line_id );