APPS.EGO_SECURITY_PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 1464: l_instance_set_name fnd_object_instance_sets.instance_set_name%TYPE;

1460: p_instance_set_id IN NUMBER,
1461: p_instance_pk1_value IN VARCHAR2
1462: ) return VARCHAR2
1463: IS
1464: l_instance_set_name fnd_object_instance_sets.instance_set_name%TYPE;
1465: CURSOR get_instance_set_name (cp_instance_set_id NUMBER)
1466: IS
1467: SELECT instance_set_name
1468: FROM fnd_object_instance_sets

Line 1468: FROM fnd_object_instance_sets

1464: l_instance_set_name fnd_object_instance_sets.instance_set_name%TYPE;
1465: CURSOR get_instance_set_name (cp_instance_set_id NUMBER)
1466: IS
1467: SELECT instance_set_name
1468: FROM fnd_object_instance_sets
1469: WHERE instance_set_id=cp_instance_set_id ;
1470:
1471: BEGIN
1472: OPEN get_instance_set_name(cp_instance_set_id=>p_instance_set_id);

Line 1528: fnd_object_instance_sets sets

1524: cp_instance_set_id NUMBER)
1525: IS
1526: SELECT DISTINCT obj.pk1_column_name, obj.database_object_name, sets.predicate
1527: FROM fnd_objects obj,
1528: fnd_object_instance_sets sets
1529: WHERE obj.obj_name = cp_object_name
1530: AND obj.object_id = sets.object_id
1531: AND sets.instance_set_id = cp_instance_set_id;
1532:

Line 1966: FROM fnd_object_instance_sets

1962:
1963: CURSOR get_set_c (cp_instance_set_name VARCHAR2)
1964: IS
1965: SELECT instance_set_id
1966: FROM fnd_object_instance_sets
1967: WHERE instance_set_name = cp_instance_set_name;
1968:
1969:
1970: BEGIN

Line 1979: FND_OBJECT_INSTANCE_SETS_PKG.LOAD_ROW

1975:
1976: IF(get_set_c%NOTFOUND) THEN
1977: CLOSE get_set_c;
1978:
1979: FND_OBJECT_INSTANCE_SETS_PKG.LOAD_ROW
1980: (
1981: X_INSTANCE_SET_NAME => p_instance_set_name,
1982: X_OWNER => 'ORACLE',
1983: X_OBJECT_NAME => p_object_name,