APPS.HZ_DSS_GROUPS_PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 2239: select fnd_object_instance_sets_s.nextval

2235: RAISE FND_API.G_EXC_ERROR;
2236: END IF;
2237:
2238: -- GET A SEQUENCE GENERATED DSS_INSTANCE_SET_ID TO BE INSERTED INTO FND_GRANTS
2239: select fnd_object_instance_sets_s.nextval
2240: into l_dss_instance_set_id
2241: from sys.dual;
2242:
2243: -- GET OBJECT ID TO BE INSERTED INTO FND_OBJECT_INSTANCE_SETS

Line 2243: -- GET OBJECT ID TO BE INSERTED INTO FND_OBJECT_INSTANCE_SETS

2239: select fnd_object_instance_sets_s.nextval
2240: into l_dss_instance_set_id
2241: from sys.dual;
2242:
2243: -- GET OBJECT ID TO BE INSERTED INTO FND_OBJECT_INSTANCE_SETS
2244:
2245: -- If there is an object id (non null) corresponding to the given entity id
2246: -- in HZ_DSS_ENTITIIES, grab it
2247:

Line 2262: -- CALL FND_OBJECT_INSTANCE_SETS_PKG INSERT ROW HANDLER TO INSERT

2258: (l_instance_set_id);
2259: END IF;
2260:
2261:
2262: -- CALL FND_OBJECT_INSTANCE_SETS_PKG INSERT ROW HANDLER TO INSERT
2263: -- ALL THE INFORMATION COLLECTED BEFORE
2264:
2265: -- Construct an Object Instance Set Name
2266:

Line 2269: select count(*) into l_dup_ois_cnt from fnd_object_instance_sets

2265: -- Construct an Object Instance Set Name
2266:
2267: l_dss_ois_name := 'HZ_DSS_' || substrb(p_dss_secured_entity.dss_group_code,1,18) ||
2268: '_';
2269: select count(*) into l_dup_ois_cnt from fnd_object_instance_sets
2270: where instance_set_name like l_dss_ois_name || '%';
2271: l_dss_ois_name := l_dss_ois_name || to_char(l_dup_ois_cnt + 1);
2272:
2273:

Line 2274: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (

2270: where instance_set_name like l_dss_ois_name || '%';
2271: l_dss_ois_name := l_dss_ois_name || to_char(l_dup_ois_cnt + 1);
2272:
2273:
2274: FND_OBJECT_INSTANCE_SETS_PKG.INSERT_ROW (
2275: x_rowid => row_id,
2276: x_instance_set_id => l_dss_instance_set_id,
2277: x_instance_set_name => l_dss_ois_name,
2278: x_object_id => l_object_id,