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.CS_ERES_INT_PKG dependencies on FND_GLOBAL

Line 90: l_event.PARAM_VALUE_7 := fnd_global.user_name;

86: l_event.PARAM_VALUE_5 := -1;
87: l_event.PARAM_NAME_6 := '#WF_SOURCE_APPLICATION_TYPE';
88: l_event.PARAM_VALUE_6 := 'DB';
89: l_event.PARAM_NAME_7 := '#WF_SIGN_REQUESTER';
90: l_event.PARAM_VALUE_7 := fnd_global.user_name;
91: l_event.PARAM_NAME_8 := 'TRANSFORM_XML';
92: l_event.PARAM_VALUE_8 := 'N';
93:
94: -- Construct a call to the function that returns an XML document. This call will be executed by the ERES API

Line 1126: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,

1122: WHERE lookup_code = v_lookup_code
1123: AND lookup_type = v_lookup_type
1124: AND LANGUAGE = userenv('LANG')
1125: AND View_APPLICATION_ID = 170
1126: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,
1127: VIEW_APPLICATION_ID);
1128:
1129: l_Problem_code VARCHAR2(80);
1130: l_Resolution_code VARCHAR2(80);

Line 1153: AND cont_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cont_type_lkup.LOOKUP_TYPE,

1149: AND sr_cont.incident_id = v_incident_id
1150: ANd sr_cont.primary_flag = 'Y'
1151: AND cont_type_lkup.LANGUAGE = userenv('LANG')
1152: AND cont_type_lkup.View_APPLICATION_ID = 170
1153: AND cont_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cont_type_lkup.LOOKUP_TYPE,
1154: cont_type_lkup.VIEW_APPLICATION_ID);
1155: l_Contact_Type VARCHAR2(80);
1156:
1157:

Line 1453: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID) ) Problem_code

1449: WHERE problem.lookup_code = sr.problem_code
1450: AND problem.lookup_type = ''REQUEST_PROBLEM_CODE''
1451: AND problem.LANGUAGE = userenv(''LANG'')
1452: AND problem.View_APPLICATION_ID = 170
1453: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID) ) Problem_code
1454: ,(SELECT resolution.meaning
1455: FROM fnd_lookup_values resolution
1456: WHERE resolution.lookup_code = sr.resolution_code
1457: AND resolution.lookup_type = ''REQUEST_RESOLUTION_CODE''

Line 1460: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code

1456: WHERE resolution.lookup_code = sr.resolution_code
1457: AND resolution.lookup_type = ''REQUEST_RESOLUTION_CODE''
1458: AND resolution.LANGUAGE = userenv(''LANG'')
1459: AND resolution.View_APPLICATION_ID = 170
1460: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code
1461: ,tl.summary Problem_summary
1462: ,tl.resolution_summary Resolution_Summary
1463: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl
1464: WHERE sr.incident_id = tl.incident_id

Line 2088: l_chr_newline VARCHAR2(8) := fnd_global.newline;

2084: lx_msg_count NUMBER;
2085: lx_msg_data VARCHAR2(4000);
2086: lx_return_status VARCHAR2(1);
2087: lx_msg_index_out NUMBER;
2088: l_chr_newline VARCHAR2(8) := fnd_global.newline;
2089: l_api_name VARCHAR2(240) := 'Post_Approval_Process';
2090: l_spl_excp VARCHAR2(3) := 'N';
2091: l_note_id NUMBER;
2092: l_note_err_msg VARCHAR2(240);

Line 2445: p_last_updated_by => fnd_global.user_id,

2441: x_msg_data => l_msg_data,
2442: p_request_id => p_incident_id,
2443: p_audit_id => null,
2444: p_object_version_number => l_sr_version,
2445: p_last_updated_by => fnd_global.user_id,
2446: p_last_update_date => sysdate,
2447: p_service_request_rec => l_servicerequest_Rec,
2448: p_notes => l_notes_table_dummy,
2449: p_contacts => l_contacts_table,

Line 2501: , p_entered_by => fnd_global.user_id

2497: , p_source_object_code => 'SR'
2498: , p_notes => l_notes_table(k).note
2499: , p_notes_detail => l_notes_table(k).note_detail
2500: , p_note_status => NVL(l_note_status,'I')
2501: , p_entered_by => fnd_global.user_id
2502: , p_entered_date => sysdate
2503: , p_last_update_date => sysdate
2504: , p_last_updated_by => fnd_global.user_id
2505: , p_creation_date => sysdate

Line 2504: , p_last_updated_by => fnd_global.user_id

2500: , p_note_status => NVL(l_note_status,'I')
2501: , p_entered_by => fnd_global.user_id
2502: , p_entered_date => sysdate
2503: , p_last_update_date => sysdate
2504: , p_last_updated_by => fnd_global.user_id
2505: , p_creation_date => sysdate
2506: , p_created_by => fnd_global.user_id
2507: , p_last_update_login => fnd_global.login_id
2508: , p_note_type => l_note_type

Line 2506: , p_created_by => fnd_global.user_id

2502: , p_entered_date => sysdate
2503: , p_last_update_date => sysdate
2504: , p_last_updated_by => fnd_global.user_id
2505: , p_creation_date => sysdate
2506: , p_created_by => fnd_global.user_id
2507: , p_last_update_login => fnd_global.login_id
2508: , p_note_type => l_note_type
2509: , x_return_status => l_return_status
2510: , x_msg_count => l_msg_count

Line 2507: , p_last_update_login => fnd_global.login_id

2503: , p_last_update_date => sysdate
2504: , p_last_updated_by => fnd_global.user_id
2505: , p_creation_date => sysdate
2506: , p_created_by => fnd_global.user_id
2507: , p_last_update_login => fnd_global.login_id
2508: , p_note_type => l_note_type
2509: , x_return_status => l_return_status
2510: , x_msg_count => l_msg_count
2511: , x_msg_data => l_msg_data

Line 2788: p_last_updated_by => fnd_global.user_id,

2784: x_msg_data => l_msg_data,
2785: p_request_id => p_incident_id,
2786: p_audit_id => null,
2787: p_object_version_number => l_sr_version,
2788: p_last_updated_by => fnd_global.user_id,
2789: p_last_update_date => sysdate,
2790: p_service_request_rec => l_servicerequest_Rec,
2791: p_notes => l_notes_table_dummy,
2792: p_contacts => l_contacts_table,

Line 2842: , p_entered_by => fnd_global.user_id

2838: , p_source_object_code => 'SR'
2839: , p_notes => l_notes_table(k).note
2840: , p_notes_detail => l_notes_table(k).note_detail
2841: , p_note_status => NVL(l_note_status,'I')
2842: , p_entered_by => fnd_global.user_id
2843: , p_entered_date => sysdate
2844: , p_last_update_date => sysdate
2845: , p_last_updated_by => fnd_global.user_id
2846: , p_creation_date => sysdate

Line 2845: , p_last_updated_by => fnd_global.user_id

2841: , p_note_status => NVL(l_note_status,'I')
2842: , p_entered_by => fnd_global.user_id
2843: , p_entered_date => sysdate
2844: , p_last_update_date => sysdate
2845: , p_last_updated_by => fnd_global.user_id
2846: , p_creation_date => sysdate
2847: , p_created_by => fnd_global.user_id
2848: , p_last_update_login => fnd_global.login_id
2849: , p_note_type => l_note_type

Line 2847: , p_created_by => fnd_global.user_id

2843: , p_entered_date => sysdate
2844: , p_last_update_date => sysdate
2845: , p_last_updated_by => fnd_global.user_id
2846: , p_creation_date => sysdate
2847: , p_created_by => fnd_global.user_id
2848: , p_last_update_login => fnd_global.login_id
2849: , p_note_type => l_note_type
2850: , x_return_status => l_return_status
2851: , x_msg_count => l_msg_count

Line 2848: , p_last_update_login => fnd_global.login_id

2844: , p_last_update_date => sysdate
2845: , p_last_updated_by => fnd_global.user_id
2846: , p_creation_date => sysdate
2847: , p_created_by => fnd_global.user_id
2848: , p_last_update_login => fnd_global.login_id
2849: , p_note_type => l_note_type
2850: , x_return_status => l_return_status
2851: , x_msg_count => l_msg_count
2852: , x_msg_data => l_msg_data