DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DSCFG_API_PKG

Line 1183: l_pset_id := FND_OAM_DSCFG_API_PKG.GET_CURRENT_POLICYSET_ID;

1179: -- pset_id := 3022;
1180: -- OPEN pset_policy_c(pset_id);
1181:
1182: fnd_oam_debug.log(1, l_ctxt, 'Obtaining Policy Set ID...');
1183: l_pset_id := FND_OAM_DSCFG_API_PKG.GET_CURRENT_POLICYSET_ID;
1184:
1185: fnd_oam_debug.log(1, l_ctxt, 'Querying Policies for Policy Set ID:'||l_pset_id);
1186: OPEN pset_policy_c(l_pset_id);
1187:

Line 1228: FND_OAM_DSCFG_API_PKG.ADD_DML_UPDATE_SEGMENT(P_TABLE_OWNER => attri_rec.owner,

1224: x_new_column_value => l_algo_text,
1225: X_WEIGHT_MODIFIER => l_algo_weight);
1226:
1227: --add a dml_update_segment object to the intermediate config
1228: FND_OAM_DSCFG_API_PKG.ADD_DML_UPDATE_SEGMENT(P_TABLE_OWNER => attri_rec.owner,
1229: P_TABLE_NAME => attri_rec.table_name,
1230: P_COLUMN_NAME => attri_rec.column_name,
1231: P_NEW_COLUMN_VALUE => l_algo_text,
1232: P_WHERE_CLAUSE => attri_rec.where_clause,

Line 1251: FND_OAM_DSCFG_API_PKG.ADD_DML_TRUNCATE_STMT(P_TABLE_OWNER => delete_rec.owner,

1247: EXIT WHEN policy_delete_c%NOTFOUND;
1248: fnd_oam_debug.log(1, l_ctxt, 'Processing Delete ID: '||delete_rec.delete_id);
1249: --see if the delete's a truncate
1250: IF delete_rec.use_truncate_flag IS NOT NULL AND delete_rec.USE_TRUNCATE_FLAG = FND_API.G_TRUE THEN
1251: FND_OAM_DSCFG_API_PKG.ADD_DML_TRUNCATE_STMT(P_TABLE_OWNER => delete_rec.owner,
1252: P_TABLE_NAME => delete_rec.table_name,
1253: x_object_id => l_object_id);
1254: ELSE
1255: FND_OAM_DSCFG_API_PKG.ADD_DML_DELETE_STMT(P_TABLE_OWNER => delete_rec.owner,

Line 1255: FND_OAM_DSCFG_API_PKG.ADD_DML_DELETE_STMT(P_TABLE_OWNER => delete_rec.owner,

1251: FND_OAM_DSCFG_API_PKG.ADD_DML_TRUNCATE_STMT(P_TABLE_OWNER => delete_rec.owner,
1252: P_TABLE_NAME => delete_rec.table_name,
1253: x_object_id => l_object_id);
1254: ELSE
1255: FND_OAM_DSCFG_API_PKG.ADD_DML_DELETE_STMT(P_TABLE_OWNER => delete_rec.owner,
1256: P_TABLE_NAME => delete_rec.table_name,
1257: P_WHERE_CLAUSE => delete_rec.where_clause,
1258: x_object_id => l_object_id);
1259: END IF;