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 972: FROM fnd_objects fo , hz_dss_entities dse

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

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

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

Line 979: (select object_id from fnd_objects

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

Line 989: l_pk1_column_name fnd_objects.pk1_column_name%type;

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

Line 990: l_pk2_column_name fnd_objects.pk2_column_name%type;

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

Line 1107: FROM fnd_objects fo , hz_dss_entities dse

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

Line 1357: FROM fnd_objects obj,

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

Line 1371: fnd_objects obj,

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

Line 2421: FROM fnd_objects_vl

2417: ) RETURN VARCHAR2 IS
2418:
2419: CURSOR c_objects IS
2420: SELECT display_name
2421: FROM fnd_objects_vl
2422: WHERE obj_name = p_object_name;
2423:
2424: CURSOR c_object_instance_sets IS
2425: SELECT display_name