48: CURSOR c_dss_ois (
49: p_dss_group_code IN VARCHAR2
50: ) IS
51: SELECT fois.instance_set_id
52: FROM fnd_object_instance_sets fois,
53: fnd_objects fo
54: WHERE fo.obj_name = l_obj_name
55: AND fo.object_id = fois.object_id
56: AND fois.predicate LIKE '%''' || p_dss_group_code || '''%';
81: CLOSE c_obj;
82: --
83: -- Create the Object Instance Set!
84: --
85: SELECT fnd_object_instance_sets_s.NEXTVAL INTO l_instance_set_id FROM DUAL;
86:
87: fnd_object_instance_sets_pkg.insert_row(
88: x_rowid => l_rowid,
89: x_instance_set_id => l_instance_set_id,
83: -- Create the Object Instance Set!
84: --
85: SELECT fnd_object_instance_sets_s.NEXTVAL INTO l_instance_set_id FROM DUAL;
86:
87: fnd_object_instance_sets_pkg.insert_row(
88: x_rowid => l_rowid,
89: x_instance_set_id => l_instance_set_id,
90: x_instance_set_name => 'HZ_DSS_BASE_' || l_instance_set_id,
91: x_object_id => l_object_id,
160: SELECT dse.dss_instance_set_id,
161: fo.obj_name,
162: dse.status
163: FROM hz_dss_secured_entities dse,
164: fnd_object_instance_sets fois,
165: fnd_objects fo
166: WHERE dse.dss_group_code = p_dss_group_code
167: AND fois.instance_set_id = dse.dss_instance_set_id
168: AND fo.object_id = fois.object_id ;
581:
582: CURSOR c_objects IS
583: SELECT obj_name
584: FROM fnd_objects obj,
585: fnd_object_instance_sets ins
586: WHERE instance_set_id = p_dss_instance_set_id
587: AND ins.object_id = obj.object_id;
588:
589: CURSOR c_grants IS
1010: SELECT grants.grant_guid,
1011: grants.start_date,
1012: dse.status
1013: FROM fnd_grants grants,
1014: fnd_object_instance_sets ins,
1015: hz_dss_secured_entities dse
1016: WHERE grants.program_name = G_API_NAME
1017: AND grants.program_tag = p_dss_group_code
1018: AND grants.instance_set_id = ins.instance_set_id