APPS.QP_SECURITY dependencies on FND_OBJECTS

Line 28: FROM FND_OBJECTS

24: END IF;
25:
26: SELECT object_id
27: INTO v_object_id
28: FROM FND_OBJECTS
29: WHERE obj_name = v_object_name and application_id=661;
30:
31: G_INSTANCE_TYPE_CACHE := v_instance_type;
32: G_OBJECT_ID_CACHE := v_object_id;

Line 332: l_database_object_name fnd_objects.database_object_name%TYPE;

328: qp_inst_pk_vals_cur qp_inst_pk_vals_cur_type;
329: err_msg varchar2(256);
330: count_num number := 0;
331:
332: l_database_object_name fnd_objects.database_object_name%TYPE;
333: l_pk1_column_name fnd_objects.pk1_column_name%TYPE;
334: l_pk2_column_name fnd_objects.pk2_column_name%TYPE;
335: l_predicate varchar2(32767);
336: l_return_status varchar2(1);

Line 333: l_pk1_column_name fnd_objects.pk1_column_name%TYPE;

329: err_msg varchar2(256);
330: count_num number := 0;
331:
332: l_database_object_name fnd_objects.database_object_name%TYPE;
333: l_pk1_column_name fnd_objects.pk1_column_name%TYPE;
334: l_pk2_column_name fnd_objects.pk2_column_name%TYPE;
335: l_predicate varchar2(32767);
336: l_return_status varchar2(1);
337: l_sql_stmt varchar2(32767);

Line 334: l_pk2_column_name fnd_objects.pk2_column_name%TYPE;

330: count_num number := 0;
331:
332: l_database_object_name fnd_objects.database_object_name%TYPE;
333: l_pk1_column_name fnd_objects.pk1_column_name%TYPE;
334: l_pk2_column_name fnd_objects.pk2_column_name%TYPE;
335: l_predicate varchar2(32767);
336: l_return_status varchar2(1);
337: l_sql_stmt varchar2(32767);
338:

Line 590: --get database_object_name and primary key column name from FND_OBJECTS

586: ----------------------------------------------------------------------
587: -- check fnd_grants SET table to get all list_header_ids which
588: -- can be accessed
589: ------------------------------------------------------------------------
590: --get database_object_name and primary key column name from FND_OBJECTS
591: SELECT database_object_name,
592: pk1_column_name,
593: pk2_column_name
594: INTO l_database_object_name,

Line 597: FROM fnd_objects

593: pk2_column_name
594: INTO l_database_object_name,
595: l_pk1_column_name,
596: l_pk2_column_name
597: FROM fnd_objects
598: WHERE obj_name = l_object_name;
599:
600:
601: --get security predicate to filter authorized instances