DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_ARGS_PKG dependencies on FND_OAM_DSCRAM_BUNDLES_PKG

Line 225: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID);

221: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_RUN_MODE THEN
222: l_canonical_value := FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE;
223:
224: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_ID THEN
225: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID);
226:
227: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_WORKERS_ALLOWED THEN
228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);
229:

Line 228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);

224: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_ID THEN
225: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID);
226:
227: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_WORKERS_ALLOWED THEN
228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);
229:
230: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_BATCH_SIZE THEN
231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);
232:

Line 231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);

227: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_WORKERS_ALLOWED THEN
228: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED);
229:
230: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_BATCH_SIZE THEN
231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);
232:
233: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKER_ID THEN
234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);
235:

Line 234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);

230: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BUNDLE_BATCH_SIZE THEN
231: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE);
232:
233: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKER_ID THEN
234: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID);
235:
236: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_TASK_ID THEN
237: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID);
238:

Line 274: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED));

270: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(px_arg.arg_id);
271:
272: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_WORKERS_ALLOWED THEN
273: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_WORKERS_ALLOWED,
274: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED));
275:
276: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BATCH_SIZE THEN
277: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE,
278: FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE));

Line 278: FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE));

274: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKERS_ALLOWED));
275:
276: WHEN FND_OAM_DSCRAM_UTILS_PKG.G_KEY_BATCH_SIZE THEN
277: l_canonical_value := FND_NUMBER.NUMBER_TO_CANONICAL(NVL(FND_OAM_DSCRAM_UNITS_PKG.GET_BATCH_SIZE,
278: FND_OAM_DSCRAM_BUNDLES_PKG.GET_BATCH_SIZE));
279: ELSE
280: x_return_msg := 'ARG ID('||px_arg.arg_id||'), invalid state key: '||p_state_key;
281: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
282: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 972: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;

968: last_update_login = fnd_global.user_id,
969: last_update_date = SYSDATE
970: WHERE arg_id = px_arg.arg_id
971: AND parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER AND
972: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;
973: IF SQL%ROWCOUNT = 0 THEN
974: fnd_oam_debug.log(1, l_ctxt, 'Inserting per-worker arg value.');
975: INSERT_ARG_VALUE(px_arg.arg_id,
976: px_arg.valid_value_flag,

Line 979: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID,

975: INSERT_ARG_VALUE(px_arg.arg_id,
976: px_arg.valid_value_flag,
977: px_arg.canonical_value,
978: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER,
979: FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID,
980: x_arg_val_id => l_arg_val_id);
981: END IF;
982: ELSIF px_arg.write_policy = FND_OAM_DSCRAM_UTILS_PKG.G_WRITE_POLICY_PER_RANGE THEN
983: --update arg_values with range values and parent_type = range

Line 1180: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;

1176: INTO l_valid_value_flag, l_canonical_value
1177: FROM fnd_oam_dscram_arg_values
1178: WHERE arg_id = px_arg.arg_id AND
1179: parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_WORKER AND
1180: parent_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: l_valid_value_flag := NULL;
1184: END;