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 91: l_event.PARAM_VALUE_7 := fnd_global.user_name;

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

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

1193: WHERE lookup_code = v_lookup_code
1194: AND lookup_type = v_lookup_type
1195: AND LANGUAGE = userenv('LANG')
1196: AND View_APPLICATION_ID = 170
1197: AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LOOKUP_TYPE,
1198: VIEW_APPLICATION_ID);
1199:
1200: l_Problem_code VARCHAR2(80);
1201: l_Resolution_code VARCHAR2(80);

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

1220: AND sr_cont.incident_id = v_incident_id
1221: ANd sr_cont.primary_flag = 'Y'
1222: AND cont_type_lkup.LANGUAGE = userenv('LANG')
1223: AND cont_type_lkup.View_APPLICATION_ID = 170
1224: AND cont_type_lkup.SECURITY_GROUP_ID = fnd_global.lookup_security_group(cont_type_lkup.LOOKUP_TYPE,
1225: cont_type_lkup.VIEW_APPLICATION_ID);
1226: l_Contact_Type VARCHAR2(80);
1227:
1228:

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

1525: WHERE problem.lookup_code = sr.problem_code
1526: AND problem.lookup_type = ''REQUEST_PROBLEM_CODE''
1527: AND problem.LANGUAGE = userenv(''LANG'')
1528: AND problem.View_APPLICATION_ID = 170
1529: AND problem.SECURITY_GROUP_ID = fnd_global.lookup_security_group(problem.LOOKUP_TYPE, problem.VIEW_APPLICATION_ID) ) Problem_code
1530: ,(SELECT resolution.meaning
1531: FROM fnd_lookup_values resolution
1532: WHERE resolution.lookup_code = sr.resolution_code
1533: AND resolution.lookup_type = ''REQUEST_RESOLUTION_CODE''

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

1532: WHERE resolution.lookup_code = sr.resolution_code
1533: AND resolution.lookup_type = ''REQUEST_RESOLUTION_CODE''
1534: AND resolution.LANGUAGE = userenv(''LANG'')
1535: AND resolution.View_APPLICATION_ID = 170
1536: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code
1537: ,tl.summary Problem_summary
1538: ,tl.resolution_summary Resolution_Summary
1539: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl
1540: WHERE sr.incident_id = tl.incident_id

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

2169: lx_msg_count NUMBER;
2170: lx_msg_data VARCHAR2(4000);
2171: lx_return_status VARCHAR2(1);
2172: lx_msg_index_out NUMBER;
2173: l_chr_newline VARCHAR2(8) := fnd_global.newline;
2174: l_api_name VARCHAR2(240) := 'Post_Approval_Process';
2175: l_spl_excp VARCHAR2(3) := 'N';
2176: l_note_id NUMBER;
2177: l_note_err_msg VARCHAR2(240);

Line 2539: p_last_updated_by => fnd_global.user_id,

2535: x_msg_data => l_msg_data,
2536: p_request_id => p_incident_id,
2537: p_audit_id => null,
2538: p_object_version_number => l_sr_version,
2539: p_last_updated_by => fnd_global.user_id,
2540: p_last_update_date => sysdate,
2541: p_service_request_rec => l_servicerequest_Rec,
2542: p_notes => l_notes_table_dummy,
2543: p_contacts => l_contacts_table,

Line 2595: , p_entered_by => fnd_global.user_id

2591: , p_source_object_code => 'SR'
2592: , p_notes => l_notes_table(k).note
2593: , p_notes_detail => l_notes_table(k).note_detail
2594: , p_note_status => NVL(l_note_status,'I')
2595: , p_entered_by => fnd_global.user_id
2596: , p_entered_date => sysdate
2597: , p_last_update_date => sysdate
2598: , p_last_updated_by => fnd_global.user_id
2599: , p_creation_date => sysdate

Line 2598: , p_last_updated_by => fnd_global.user_id

2594: , p_note_status => NVL(l_note_status,'I')
2595: , p_entered_by => fnd_global.user_id
2596: , p_entered_date => sysdate
2597: , p_last_update_date => sysdate
2598: , p_last_updated_by => fnd_global.user_id
2599: , p_creation_date => sysdate
2600: , p_created_by => fnd_global.user_id
2601: , p_last_update_login => fnd_global.login_id
2602: , p_note_type => l_note_type

Line 2600: , p_created_by => fnd_global.user_id

2596: , p_entered_date => sysdate
2597: , p_last_update_date => sysdate
2598: , p_last_updated_by => fnd_global.user_id
2599: , p_creation_date => sysdate
2600: , p_created_by => fnd_global.user_id
2601: , p_last_update_login => fnd_global.login_id
2602: , p_note_type => l_note_type
2603: , x_return_status => l_return_status
2604: , x_msg_count => l_msg_count

Line 2601: , p_last_update_login => fnd_global.login_id

2597: , p_last_update_date => sysdate
2598: , p_last_updated_by => fnd_global.user_id
2599: , p_creation_date => sysdate
2600: , p_created_by => fnd_global.user_id
2601: , p_last_update_login => fnd_global.login_id
2602: , p_note_type => l_note_type
2603: , x_return_status => l_return_status
2604: , x_msg_count => l_msg_count
2605: , x_msg_data => l_msg_data

Line 2882: p_last_updated_by => fnd_global.user_id,

2878: x_msg_data => l_msg_data,
2879: p_request_id => p_incident_id,
2880: p_audit_id => null,
2881: p_object_version_number => l_sr_version,
2882: p_last_updated_by => fnd_global.user_id,
2883: p_last_update_date => sysdate,
2884: p_service_request_rec => l_servicerequest_Rec,
2885: p_notes => l_notes_table_dummy,
2886: p_contacts => l_contacts_table,

Line 2936: , p_entered_by => fnd_global.user_id

2932: , p_source_object_code => 'SR'
2933: , p_notes => l_notes_table(k).note
2934: , p_notes_detail => l_notes_table(k).note_detail
2935: , p_note_status => NVL(l_note_status,'I')
2936: , p_entered_by => fnd_global.user_id
2937: , p_entered_date => sysdate
2938: , p_last_update_date => sysdate
2939: , p_last_updated_by => fnd_global.user_id
2940: , p_creation_date => sysdate

Line 2939: , p_last_updated_by => fnd_global.user_id

2935: , p_note_status => NVL(l_note_status,'I')
2936: , p_entered_by => fnd_global.user_id
2937: , p_entered_date => sysdate
2938: , p_last_update_date => sysdate
2939: , p_last_updated_by => fnd_global.user_id
2940: , p_creation_date => sysdate
2941: , p_created_by => fnd_global.user_id
2942: , p_last_update_login => fnd_global.login_id
2943: , p_note_type => l_note_type

Line 2941: , p_created_by => fnd_global.user_id

2937: , p_entered_date => sysdate
2938: , p_last_update_date => sysdate
2939: , p_last_updated_by => fnd_global.user_id
2940: , p_creation_date => sysdate
2941: , p_created_by => fnd_global.user_id
2942: , p_last_update_login => fnd_global.login_id
2943: , p_note_type => l_note_type
2944: , x_return_status => l_return_status
2945: , x_msg_count => l_msg_count

Line 2942: , p_last_update_login => fnd_global.login_id

2938: , p_last_update_date => sysdate
2939: , p_last_updated_by => fnd_global.user_id
2940: , p_creation_date => sysdate
2941: , p_created_by => fnd_global.user_id
2942: , p_last_update_login => fnd_global.login_id
2943: , p_note_type => l_note_type
2944: , x_return_status => l_return_status
2945: , x_msg_count => l_msg_count
2946: , x_msg_data => l_msg_data