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.IGS_SC_GRANTS_PVT dependencies on FND_OBJECTS

Line 69: table_name fnd_objects.database_object_name%TYPE,

65:
66: TYPE g_object_rec IS RECORD
67: ( obj_group_id igs_sc_objects.obj_group_id%TYPE,
68: object_id igs_sc_objects.object_id%TYPE,
69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,

Line 71: pk1_column_name fnd_objects.pk1_column_name%TYPE,

67: ( obj_group_id igs_sc_objects.obj_group_id%TYPE,
68: object_id igs_sc_objects.object_id%TYPE,
69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,

Line 72: pk2_column_name fnd_objects.pk2_column_name%TYPE,

68: object_id igs_sc_objects.object_id%TYPE,
69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,

Line 73: pk3_column_name fnd_objects.pk3_column_name%TYPE,

69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,

Line 74: pk4_column_name fnd_objects.pk4_column_name%TYPE,

70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,

Line 75: pk5_column_name fnd_objects.pk5_column_name%TYPE,

71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,
79: pk4_column_type fnd_objects.pk4_column_type%TYPE,

Line 76: pk1_column_type fnd_objects.pk1_column_type%TYPE,

72: pk2_column_name fnd_objects.pk2_column_name%TYPE,
73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,
79: pk4_column_type fnd_objects.pk4_column_type%TYPE,
80: pk5_column_type fnd_objects.pk5_column_type%TYPE

Line 77: pk2_column_type fnd_objects.pk2_column_type%TYPE,

73: pk3_column_name fnd_objects.pk3_column_name%TYPE,
74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,
79: pk4_column_type fnd_objects.pk4_column_type%TYPE,
80: pk5_column_type fnd_objects.pk5_column_type%TYPE
81:

Line 78: pk3_column_type fnd_objects.pk3_column_type%TYPE,

74: pk4_column_name fnd_objects.pk4_column_name%TYPE,
75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,
79: pk4_column_type fnd_objects.pk4_column_type%TYPE,
80: pk5_column_type fnd_objects.pk5_column_type%TYPE
81:
82: );

Line 79: pk4_column_type fnd_objects.pk4_column_type%TYPE,

75: pk5_column_name fnd_objects.pk5_column_name%TYPE,
76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,
79: pk4_column_type fnd_objects.pk4_column_type%TYPE,
80: pk5_column_type fnd_objects.pk5_column_type%TYPE
81:
82: );
83:

Line 80: pk5_column_type fnd_objects.pk5_column_type%TYPE

76: pk1_column_type fnd_objects.pk1_column_type%TYPE,
77: pk2_column_type fnd_objects.pk2_column_type%TYPE,
78: pk3_column_type fnd_objects.pk3_column_type%TYPE,
79: pk4_column_type fnd_objects.pk4_column_type%TYPE,
80: pk5_column_type fnd_objects.pk5_column_type%TYPE
81:
82: );
83:
84: TYPE g_grant_rec IS RECORD

Line 391: fnd_objects fnd,

387: pk3_column_type ,
388: pk4_column_type ,
389: pk5_column_type
390: FROM igs_sc_objects sco,
391: fnd_objects fnd,
392: igs_sc_grants grn,
393: igs_sc_obj_groups grp
394: WHERE (application_id IN (8405,8406))
395: AND fnd.object_id = sco.object_id

Line 1217: CURSOR c_group(cp_obj_name fnd_objects.obj_name%TYPE) IS

1213: l_alias_name VARCHAR2(8);
1214:
1215: --skpandey, Bug#4937960: Changed c_group cursor definition to optimize query
1216: -- Object data cursor
1217: CURSOR c_group(cp_obj_name fnd_objects.obj_name%TYPE) IS
1218: SELECT sco.obj_group_id,
1219: sco.object_id,
1220: fnd.obj_name,
1221: grp.default_policy_type,

Line 1233: fnd_objects fnd,

1229: pk3_column_type ,
1230: pk4_column_type ,
1231: pk5_column_type
1232: FROM igs_sc_objects sco,
1233: fnd_objects fnd,
1234: igs_sc_obj_groups grp
1235: WHERE application_id IN (8405,8406)
1236: AND fnd.obj_name = cp_obj_name
1237: AND grp.obj_group_id = sco.obj_group_id