APPS.FND_OAM_DSCFG_COMPILER_PKG dependencies on FND_OAM_DSCFG_OBJECTS

Line 1343: FROM fnd_oam_dscfg_objects

1339: fnd_oam_debug.log(1, l_ctxt, 'Fetching compilable objects...');
1340: -- obtain all compilable objects
1341: SELECT object_id, object_type, target_type, target_id
1342: BULK COLLECT INTO l_object_ids, l_object_types, l_target_types, l_target_ids
1343: FROM fnd_oam_dscfg_objects
1344: WHERE config_instance_id = p_config_instance_id
1345: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1346: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1347: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,

Line 1363: FROM fnd_oam_dscfg_objects

1359: BULK COLLECT INTO l_prop_ids, l_prop_object_ids, l_prop_names, l_datatypes, l_canonical_values
1360: FROM fnd_oam_dscfg_properties
1361: WHERE parent_type = FND_OAM_DSCFG_API_PKG.G_TYPE_OBJECT
1362: AND parent_id in (SELECT object_id
1363: FROM fnd_oam_dscfg_objects
1364: WHERE config_instance_id = p_config_instance_id
1365: AND object_type IN (FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_UPDATE_SEGMENT,
1366: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_DELETE_STMT,
1367: FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT,

Line 3290: UPDATE fnd_oam_dscfg_objects

3286: WHILE k IS NOT NULL LOOP
3287: IF b_objects(k).is_dirty THEN
3288: --all objects in b_objects should have db objects already created so just try to update
3289: BEGIN
3290: UPDATE fnd_oam_dscfg_objects
3291: SET errors_found_flag = b_objects(k).new_errors_found_flag,
3292: message = b_objects(k).new_message,
3293: target_type = b_objects(k).target_type,
3294: target_id = b_objects(k).target_id,