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 FND_OBJECTS

Line 29: G_FND_OBJECT_ID fnd_objects.object_id%TYPE;

25: --Indicates the object name
26: G_FND_OBJECT_NAME VARCHAR2(99) := 'ENG_CHANGE';
27:
28: --Indicates the object id (set using g_Fnd_Object_Name)
29: G_FND_OBJECT_ID fnd_objects.object_id%TYPE;
30:
31: -- Seeded value for all_users (group available in hz_parties)
32: G_ALL_USERS_PARTY_ID PLS_INTEGER := -1000;
33:

Line 211: FROM fnd_objects

207: -- IN : object_name
208: --
209: CURSOR c_fnd_object_id(c_object_name IN VARCHAR2) IS
210: SELECT object_id
211: FROM fnd_objects
212: WHERE obj_name = c_object_name;
213:
214: BEGIN
215: OPEN c_fnd_object_id(p_object_name);

Line 454: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL

450: WHERE grants.object_id = G_FND_OBJECT_ID
451: AND grants.menu_id = cp_menu_id
452: AND grants.instance_type = 'INSTANCE'
453: AND grants.instance_pk1_value = TO_CHAR(cp_change_id)
454: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL
455: -- AND grants.instance_pk2_value = TO_CHAR(cp_organization_id)
456: AND ((grants.grantee_type = 'USER' AND grants.grantee_key = cp_user_party_id_char ) OR
457: (grants.grantee_type = 'GROUP' AND grants.grantee_key = cp_group_party_id_char) OR
458: (grants.grantee_type = 'GLOBAL' AND grants.grantee_key = cp_global_party_id_char) OR

Line 483: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL

479: AND grants.object_id = cp_object_id
480: AND grants.menu_id = cp_menu_id
481: AND grants.instance_type = 'INSTANCE'
482: AND grants.instance_pk1_value = TO_CHAR(cp_change_id)
483: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL
484: -- AND grants.instance_pk2_value = TO_CHAR(cp_organization_id)
485: AND ((grants.grantee_type = 'USER' AND grants.grantee_key = cp_user_party_id_char ) OR
486: (grants.grantee_type = 'GROUP' AND grants.grantee_key = cp_group_party_id_char) OR
487: (grants.grantee_type = 'GLOBAL' AND grants.grantee_key = cp_global_party_id_char) OR

Line 656: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL

652: WHERE grants.object_id = cp_object_id
653: AND grants.menu_id = cp_menu_id
654: AND grants.instance_type = 'INSTANCE'
655: AND grants.instance_pk1_value = TO_CHAR(cp_change_id)
656: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL
657: -- AND grants.instance_pk2_value = TO_CHAR(cp_organization_id)
658: AND ((grants.grantee_type = 'USER' AND grants.grantee_key = cp_user_party_id_char ) OR
659: (grants.grantee_type = 'GROUP' AND grants.grantee_key = cp_group_party_id_char) OR
660: (grants.grantee_type = 'GLOBAL' AND grants.grantee_key = cp_global_party_id_char) OR

Line 720: -- Passing NULL to as PK2_Value for ENG_CHANGE in fnd_objects is NULL

716: ,p_object_name => G_FND_OBJECT_NAME
717: ,p_instance_type => 'INSTANCE'
718: ,p_instance_set_id => NULL
719: ,p_instance_pk1_value => TO_CHAR(p_change_id)
720: -- Passing NULL to as PK2_Value for ENG_CHANGE in fnd_objects is NULL
721: ,p_instance_pk2_value => NULL
722: ,p_instance_pk3_value => NULL
723: ,p_instance_pk4_value => NULL
724: ,p_instance_pk5_value => NULL

Line 810: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL

806: WHERE grants.object_id = G_FND_OBJECT_ID
807: AND grants.menu_id = cp_menu_id
808: AND grants.instance_type = 'INSTANCE'
809: AND grants.instance_pk1_value = TO_CHAR(cp_change_id)
810: -- Commented as PK2_Value for ENG_CHANGE in fnd_objects is NULL
811: -- AND grants.instance_pk2_value = TO_CHAR(cp_organization_id)
812: AND ((grants.grantee_type = 'USER' AND grants.grantee_key = cp_user_party_id_char ) OR
813: (grants.grantee_type = 'GROUP' AND grants.grantee_key = cp_group_party_id_char) OR
814: (grants.grantee_type = 'GLOBAL' AND grants.grantee_key = cp_global_party_id_char) OR