APPS.HZ_DSS_VALIDATE_PKG dependencies on HZ_DSS_ENTITIES

Line 34: -- Return object_id from hz_dss_entities, based on the given entity id

30: --------------------------------------------
31: -- get_object_id_entities
32: --------------------------------------------
33: FUNCTION get_object_id_entities
34: -- Return object_id from hz_dss_entities, based on the given entity id
35: (p_entity_id NUMBER)
36: RETURN NUMBER
37: IS
38: CURSOR c0

Line 41: FROM hz_dss_entities

37: IS
38: CURSOR c0
39: IS
40: SELECT object_id
41: FROM hz_dss_entities
42: WHERE entity_id = p_entity_id;
43: l_yn number ;
44: result VARCHAR2(1);
45: BEGIN

Line 57: -- Return instance_set_id from hz_dss_entities, based on the given entity id

53: --------------------------------------------
54: -- get_instance_set_id_entities
55: --------------------------------------------
56: FUNCTION get_instance_set_id_entities
57: -- Return instance_set_id from hz_dss_entities, based on the given entity id
58: (p_entity_id NUMBER)
59: RETURN NUMBER
60: IS
61: CURSOR c0

Line 64: FROM hz_dss_entities

60: IS
61: CURSOR c0
62: IS
63: SELECT instance_set_id
64: FROM hz_dss_entities
65: WHERE entity_id = p_entity_id;
66: l_yn number ;
67: result VARCHAR2(1);
68: BEGIN

Line 251: -- Return Y if the assignment exists in hz_dss_entities

247: -- exist_in_dss_entities
248: --------------------------------------------
249:
250: FUNCTION exist_in_dss_entities
251: -- Return Y if the assignment exists in hz_dss_entities
252: -- N otherwise
253: (p_database_object_name VARCHAR2 )
254: RETURN VARCHAR2
255: IS

Line 259: from fnd_objects FND , hz_dss_entities ENT

255: IS
256: CURSOR c0
257: IS
258: select 'y'
259: from fnd_objects FND , hz_dss_entities ENT
260: where FND.database_object_name = p_database_object_name and
261: FND.object_id = ENT.object_id and
262: ENT.group_assignment_level = 'ASSIGN';
263: l_yn VARCHAR2(1);

Line 282: -- Return Y if the assignment exists in hz_dss_entities

278: -- exist_in_dss_entities
279: --------------------------------------------
280:
281: FUNCTION exist_in_dss_entities
282: -- Return Y if the assignment exists in hz_dss_entities
283: -- N otherwise
284: (p_entity_id NUMBER )
285: RETURN VARCHAR2
286: IS

Line 290: from hz_dss_entities

286: IS
287: CURSOR c0
288: IS
289: select 'y'
290: from hz_dss_entities
291: where entity_id = p_entity_id ;
292: l_yn VARCHAR2(1);
293: result VARCHAR2(1);
294: BEGIN

Line 311: -- Return Y if the passed in entity id corresponds to an object in hz_dss_entities

307: -- is_an_obj_id_in_dss_entities
308: --------------------------------------------
309:
310: FUNCTION is_an_obj_id_in_dss_entities
311: -- Return Y if the passed in entity id corresponds to an object in hz_dss_entities
312: -- N otherwise
313: (p_entity_id NUMBER )
314: RETURN VARCHAR2
315: IS

Line 319: from hz_dss_entities

315: IS
316: CURSOR c0
317: IS
318: select 'y'
319: from hz_dss_entities
320: where entity_id = p_entity_id
321: and object_id is not null ;
322: l_yn VARCHAR2(1);
323: result VARCHAR2(1);

Line 520: -- Return Y if the entity id exists in HZ_DSS_ENTITIES

516: --------------------------------------------
517: -- exist_entity_id
518: --------------------------------------------
519: FUNCTION exist_entity_id
520: -- Return Y if the entity id exists in HZ_DSS_ENTITIES
521: -- N otherwise
522: (p_entity_id NUMBER )
523: RETURN VARCHAR2
524: IS

Line 528: FROM hz_dss_entities

524: IS
525: CURSOR c0
526: IS
527: SELECT 'Y'
528: FROM hz_dss_entities
529: WHERE entity_id = p_entity_id ;
530: l_yn VARCHAR2(1);
531: result VARCHAR2(1);
532: BEGIN