APPS.AMW_VALID_INSTANCE_SET_GRANTS dependencies on FND_OBJECTS

Line 32: fnd_objects obj

28: sets.predicate predicate
29: from
30: fnd_grants grants,
31: fnd_object_instance_sets sets,
32: fnd_objects obj
33: where obj.obj_name = p_obj_name
34: AND grants.object_id = obj.object_id
35: AND grants.instance_type='SET'
36: AND nvl(grants.end_date, sysdate+1) >= trunc(sysdate)

Line 44: PK5_COLUMN_NAME from fnd_objects where OBJ_NAME = p_obj_name;

40: CURSOR obj_meta_data IS
41: select DATABASE_OBJECT_NAME,
42: PK1_COLUMN_NAME,PK2_COLUMN_NAME,
43: PK3_COLUMN_NAME,PK4_COLUMN_NAME,
44: PK5_COLUMN_NAME from fnd_objects where OBJ_NAME = p_obj_name;
45: obj_meta_data_rec obj_meta_data%ROWTYPE;
46: i NUMBER := 1;
47: -- bug 3748547 setting varchar2 fields to maximum size
48: query_to_exec VARCHAR2(32767);

Line 201: fnd_objects obj

197: l_param10
198: from
199: fnd_grants grants,
200: fnd_object_instance_sets sets,
201: fnd_objects obj
202: where obj.obj_name = p_obj_name
203: AND grants.object_id = obj.object_id
204: AND grants.instance_type='SET'
205: AND nvl(grants.end_date, sysdate+1) >= trunc(sysdate)

Line 319: PK5_COLUMN_NAME from fnd_objects where OBJ_NAME = p_object_name;

315: CURSOR obj_meta_data IS
316: select DATABASE_OBJECT_NAME,
317: PK1_COLUMN_NAME,PK2_COLUMN_NAME,
318: PK3_COLUMN_NAME,PK4_COLUMN_NAME,
319: PK5_COLUMN_NAME from fnd_objects where OBJ_NAME = p_object_name;
320:
321: obj_meta_data_rec obj_meta_data%ROWTYPE;
322: i NUMBER := 1;
323: j NUMBER := 1;

Line 395: fnd_objects obj

391: db_obj_name
392: from
393: fnd_grants grants,
394: fnd_object_instance_sets sets,
395: fnd_objects obj
396: where grants.grant_guid = p_guid
397: AND sets.instance_set_id = grants.instance_set_id
398: and obj.obj_name = p_object_name;
399:

Line 537: ' from fnd_grants gr, fnd_object_instance_sets inst, fnd_objects fo ' ||

533: ' select '||''''''||' PERSON_NAME, to_number(ltrim(gr.grantee_key, '||''''||'HZ_PARTY:'||''''||')) PERSON_ID, '||''''''||' COMPANY_NAME, gr.menu_id ROLE_ID ' ||
534: /**05.03.2006 npanandi: appending below in the SELECT clause for PLM's R12 SQL change**/
535: ',gr.object_id '||
536: /**05.03.2006 npanandi: ends**/
537: ' from fnd_grants gr, fnd_object_instance_sets inst, fnd_objects fo ' ||
538: ' where gr.object_id = fo.object_id ' ||
539: ' and fo.obj_name = ' || ''''||p_object_name ||''''||
540: ' and gr.instance_type = '||''''||'SET'||'''' ||
541: ' and grantee_type = '||''''||'USER'||'''' ||