APPS.EGO_SECURITY_PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 1409: l_instance_set_name fnd_object_instance_sets.instance_set_name%TYPE;

1405: p_instance_set_id IN NUMBER,
1406: p_instance_pk1_value IN VARCHAR2
1407: ) return VARCHAR2
1408: IS
1409: l_instance_set_name fnd_object_instance_sets.instance_set_name%TYPE;
1410: CURSOR get_instance_set_name (cp_instance_set_id NUMBER)
1411: IS
1412: SELECT instance_set_name
1413: FROM fnd_object_instance_sets

Line 1413: FROM fnd_object_instance_sets

1409: l_instance_set_name fnd_object_instance_sets.instance_set_name%TYPE;
1410: CURSOR get_instance_set_name (cp_instance_set_id NUMBER)
1411: IS
1412: SELECT instance_set_name
1413: FROM fnd_object_instance_sets
1414: WHERE instance_set_id=cp_instance_set_id ;
1415:
1416: BEGIN
1417: OPEN get_instance_set_name(cp_instance_set_id=>p_instance_set_id);

Line 1473: fnd_object_instance_sets sets

1469: cp_instance_set_id NUMBER)
1470: IS
1471: SELECT DISTINCT obj.pk1_column_name, obj.database_object_name, sets.predicate
1472: FROM fnd_objects obj,
1473: fnd_object_instance_sets sets
1474: WHERE obj.obj_name = cp_object_name
1475: AND obj.object_id = sets.object_id
1476: AND sets.instance_set_id = cp_instance_set_id;
1477:

Line 1880: FROM fnd_object_instance_sets

1876:
1877: CURSOR get_set_c (cp_instance_set_name VARCHAR2)
1878: IS
1879: SELECT instance_set_id
1880: FROM fnd_object_instance_sets
1881: WHERE instance_set_name = cp_instance_set_name;
1882:
1883:
1884: BEGIN

Line 1893: FND_OBJECT_INSTANCE_SETS_PKG.LOAD_ROW

1889:
1890: IF(get_set_c%NOTFOUND) THEN
1891: CLOSE get_set_c;
1892:
1893: FND_OBJECT_INSTANCE_SETS_PKG.LOAD_ROW
1894: (
1895: X_INSTANCE_SET_NAME => p_instance_set_name,
1896: X_OWNER => 'ORACLE',
1897: X_OBJECT_NAME => p_object_name,