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.EGO_CHANGE_PEOPLE_IMPORT_PKG dependencies on ENG_CHANGE_ROLES_TEMP

Line 270: -- FUNCTION : To populate temporary table ENG_CHANGE_ROLES_TEMP

266: -- TYPE : PRIVATE
267: -- Pre-reqs : The Object_id is populated into G_FND_OBJECT_ID
268: -- initialize_fnd_object_id must be called prior
269: -- to call to this routine
270: -- FUNCTION : To populate temporary table ENG_CHANGE_ROLES_TEMP
271: -- with the roles available for the specific object
272: --
273: -- Parameters:
274: -- IN : NONE

Line 277: --Execute Immediate 'TRUNCATE TABLE ENG_CHANGE_ROLES_TEMP';

273: -- Parameters:
274: -- IN : NONE
275: --
276: BEGIN
277: --Execute Immediate 'TRUNCATE TABLE ENG_CHANGE_ROLES_TEMP';
278: DELETE ENG_CHANGE_ROLES_TEMP;
279: INSERT into eng_change_roles_temp
280: (INTERNAL_ROLE_ID,INTERNAL_ROLE_NAME,DISPLAY_ROLE_NAME)
281: SELECT DISTINCT role_tl.menu_id internal_role_id,

Line 278: DELETE ENG_CHANGE_ROLES_TEMP;

274: -- IN : NONE
275: --
276: BEGIN
277: --Execute Immediate 'TRUNCATE TABLE ENG_CHANGE_ROLES_TEMP';
278: DELETE ENG_CHANGE_ROLES_TEMP;
279: INSERT into eng_change_roles_temp
280: (INTERNAL_ROLE_ID,INTERNAL_ROLE_NAME,DISPLAY_ROLE_NAME)
281: SELECT DISTINCT role_tl.menu_id internal_role_id,
282: role.menu_name internal_role_name,

Line 279: INSERT into eng_change_roles_temp

275: --
276: BEGIN
277: --Execute Immediate 'TRUNCATE TABLE ENG_CHANGE_ROLES_TEMP';
278: DELETE ENG_CHANGE_ROLES_TEMP;
279: INSERT into eng_change_roles_temp
280: (INTERNAL_ROLE_ID,INTERNAL_ROLE_NAME,DISPLAY_ROLE_NAME)
281: SELECT DISTINCT role_tl.menu_id internal_role_id,
282: role.menu_name internal_role_name,
283: role_tl.user_menu_name display_role_name

Line 1718: FROM eng_change_roles_temp role

1714: UPDATE eng_change_people_intf ecpi
1715: SET (ecpi.internal_role_id, ecpi.internal_role_name ) =
1716: ( SELECT role.internal_role_id,
1717: role.internal_role_name
1718: FROM eng_change_roles_temp role
1719: WHERE role.display_role_name = ecpi.display_role_name
1720: )
1721: WHERE ecpi.data_set_id = G_DATA_SET_ID
1722: AND ecpi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER

Line 1727: FROM eng_change_roles_temp role2

1723: AND ecpi.process_status = G_PS_IN_PROCESS
1724: AND ecpi.internal_role_id IS NULL
1725: AND ecpi.display_role_name IS NOT NULL
1726: AND EXISTS ( SELECT role2.internal_role_id
1727: FROM eng_change_roles_temp role2
1728: WHERE role2.display_role_name = ecpi.display_role_name
1729: );
1730:
1731: -- For missing roles, update process_status and log an error.