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

Line 98: * p_db_object_name VARCHAR2 Object_name in fnd_objects

94: * EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
95: *
96: * ARGUMENTS : IN:
97: * p_operation_code VARCHAR2 e.g SELECT,INSERT etc.
98: * p_db_object_name VARCHAR2 Object_name in fnd_objects
99: * e.g.HZ_PARTIES
100: * p_instance_pk1_value VARCHAR2 e.g Party_id = 1000
101: * p_user VARCHAR2 e.g JDOE
102: *

Line 139: FROM fnd_objects

135: AND (end_date IS NULL OR end_date >= SYSDATE);
136:
137: CURSOR c_check_table IS
138: SELECT '1'
139: FROM fnd_objects
140: WHERE database_object_name = p_db_object_name
141: AND ROWNUM = 1;
142:
143: CURSOR c_check_operation_code IS

Line 545: fnd_objects obj

541: dsg.dss_group_code, dsg.rank
542: FROM hz_dss_entities dse,
543: hz_dss_secured_entities se,
544: hz_dss_groups_b dsg,
545: fnd_objects obj
546: WHERE obj.database_object_name = p_db_object_name
547: AND dse.object_id IS NOT NULL
548: AND dse.object_id = obj.object_id
549: AND dse.entity_id = se.entity_id

Line 561: fnd_objects obj,

557: dsg.dss_group_code, dsg.rank
558: FROM hz_dss_entities dse,
559: hz_dss_secured_entities se,
560: hz_dss_groups_b dsg,
561: fnd_objects obj,
562: fnd_object_instance_sets ins
563: WHERE obj.database_object_name = p_db_object_name
564: AND dse.object_id IS NULL
565: AND dse.instance_set_id = ins.instance_set_id

Line 973: FROM fnd_objects fo , hz_dss_entities dse

969: SELECT dse.entity_id, fo.object_id,
970: fo.pk1_column_name, fo.pk2_column_name ,
971: dse.parent_fk_column1 , dse.parent_fk_column2,
972: dse.group_assignment_level
973: FROM fnd_objects fo , hz_dss_entities dse
974: WHERE ( ( dse.object_id IN ( select object_id from fnd_objects
975: where database_object_name = t_object_name) )
976: OR
977: (dse.instance_set_id in ( select instance_set_id

Line 974: WHERE ( ( dse.object_id IN ( select object_id from fnd_objects

970: fo.pk1_column_name, fo.pk2_column_name ,
971: dse.parent_fk_column1 , dse.parent_fk_column2,
972: dse.group_assignment_level
973: FROM fnd_objects fo , hz_dss_entities dse
974: WHERE ( ( dse.object_id IN ( select object_id from fnd_objects
975: where database_object_name = t_object_name) )
976: OR
977: (dse.instance_set_id in ( select instance_set_id
978: from fnd_object_instance_sets ois

Line 980: (select object_id from fnd_objects

976: OR
977: (dse.instance_set_id in ( select instance_set_id
978: from fnd_object_instance_sets ois
979: where ois.object_id IN
980: (select object_id from fnd_objects
981: where database_object_name = t_object_name)
982: )
983: )
984: )

Line 990: l_pk1_column_name fnd_objects.pk1_column_name%type;

986: AND dse.status = 'A';
987:
988: l_entity_id hz_dss_entities.entity_id%type;
989: l_object_id hz_dss_entities.object_id%type;
990: l_pk1_column_name fnd_objects.pk1_column_name%type;
991: l_pk2_column_name fnd_objects.pk2_column_name%type;
992: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
993: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;
994: l_group_assignment_level hz_dss_entities.group_assignment_level%type;

Line 991: l_pk2_column_name fnd_objects.pk2_column_name%type;

987:
988: l_entity_id hz_dss_entities.entity_id%type;
989: l_object_id hz_dss_entities.object_id%type;
990: l_pk1_column_name fnd_objects.pk1_column_name%type;
991: l_pk2_column_name fnd_objects.pk2_column_name%type;
992: l_parent_fk_column1 hz_dss_entities.parent_fk_column1%type;
993: l_parent_fk_column2 hz_dss_entities.parent_fk_column2%type;
994: l_group_assignment_level hz_dss_entities.group_assignment_level%type;
995: l_dsg_code hz_dss_secured_entities.dss_group_code%type;

Line 1108: FROM fnd_objects fo , hz_dss_entities dse

1104: fo.database_object_name,
1105: fo.pk1_column_name,
1106: fo.pk2_column_name ,
1107: dse.parent_entity_id , dse.parent_fk_column1 , dse.parent_fk_column2
1108: FROM fnd_objects fo , hz_dss_entities dse
1109: WHERE parent_entity_id is not null
1110: AND ( dse.object_id is not null and
1111: fo.object_id = dse.object_id )
1112: OR (dse.instance_set_id is not null and

Line 1358: FROM fnd_objects obj,

1354: decode(pk2_column_name , null,null, ','|| pk2_column_name) ||
1355: decode(pk3_column_name , null,null, ','|| pk3_column_name) ||
1356: decode(pk4_column_name , null,null, ','|| pk4_column_name) ||
1357: decode(pk5_column_name , null,null, ','|| pk5_column_name)
1358: FROM fnd_objects obj,
1359: hz_dss_entities dse
1360: WHERE dse.entity_id = p_entity_id
1361: AND dse.status = 'A'
1362: AND dse.object_id IS NOT NULL

Line 1372: fnd_objects obj,

1368: decode(pk3_column_name , null,null, ','|| pk3_column_name) ||
1369: decode(pk4_column_name , null,null, ','|| pk4_column_name) ||
1370: decode(pk5_column_name , null,null, ','|| pk5_column_name)
1371: FROM fnd_object_instance_sets ins,
1372: fnd_objects obj,
1373: hz_dss_entities dse
1374: WHERE dse.entity_id = p_entity_id
1375: AND dse.status = 'A'
1376: AND dse.instance_set_id IS NOT NULL

Line 2281: FROM fnd_objects_vl

2277: ) RETURN VARCHAR2 IS
2278:
2279: CURSOR c_objects IS
2280: SELECT display_name
2281: FROM fnd_objects_vl
2282: WHERE obj_name = p_object_name;
2283:
2284: CURSOR c_object_instance_sets IS
2285: SELECT display_name