APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_ARGS_B

Line 423: FROM fnd_oam_dscram_args_b

419: AND valid_value_flag = FND_API.G_TRUE;
420: ELSE
421: SELECT valid_value_flag, canonical_value
422: INTO l_valid_value_flag, l_canonical_value
423: FROM fnd_oam_dscram_args_b
424: WHERE arg_id = p_c2_arg_id;
425: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
426: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C2 Sum is incorrect: '||l_valid_value_flag);
427: RETURN FALSE;

Line 453: FROM fnd_oam_dscram_args_b

449: AND valid_value_flag = FND_API.G_TRUE;
450: ELSE
451: SELECT valid_value_flag, canonical_value
452: INTO l_valid_value_flag, l_canonical_value
453: FROM fnd_oam_dscram_args_b
454: WHERE arg_id = p_c3_arg_id;
455: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
456: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C3 Bad Count is incorrect: '||l_valid_value_flag);
457: RETURN FALSE;

Line 484: FROM fnd_oam_dscram_args_b

480: AND valid_value_flag = FND_API.G_TRUE;
481: ELSE
482: SELECT valid_value_flag, canonical_value
483: INTO l_valid_value_flag, l_canonical_value
484: FROM fnd_oam_dscram_args_b
485: WHERE arg_id = p_c4_arg_id;
486: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
487: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of C4 Bad Count is incorrect: '||l_valid_value_flag);
488: RETURN FALSE;

Line 629: DELETE FROM fnd_oam_dscram_args_b

625: k := p_global_arg_names.FIRST;
626: WHILE k IS NOT NULL LOOP
627: l_arg_name := p_global_arg_names(k);
628: fnd_oam_debug.log(1, l_ctxt, 'Deleting Global Arg: '||l_arg_name);
629: DELETE FROM fnd_oam_dscram_args_b
630: WHERE parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_GLOBAL
631: AND arg_name = l_arg_name
632: RETURNING arg_id INTO l_arg_id;
633: DELETE FROM fnd_oam_dscram_args_tl

Line 1294: INSERT INTO FND_OAM_DSCRAM_ARGS_B (ARG_ID,

1290: l_retval NUMBER;
1291: BEGIN
1292: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1293:
1294: INSERT INTO FND_OAM_DSCRAM_ARGS_B (ARG_ID,
1295: ARG_NAME,
1296: PARENT_TYPE,
1297: PARENT_ID,
1298: ENABLED_FLAG,

Line 3104: FROM fnd_oam_dscram_args_b

3100: --check the row count
3101: BEGIN
3102: SELECT valid_value_flag, canonical_value
3103: INTO l_valid_value_flag, l_canonical_value
3104: FROM fnd_oam_dscram_args_b
3105: WHERE arg_id = p_c2_final_arg_id;
3106: EXCEPTION
3107: WHEN OTHERS THEN
3108: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for final C2 sum: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 3914: FROM fnd_oam_dscram_args_b

3910: --check the arg id
3911: BEGIN
3912: SELECT arg_id
3913: INTO l_id
3914: FROM fnd_oam_dscram_args_b
3915: WHERE arg_id = p_arg_id
3916: AND parent_type = FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL
3917: AND parent_id = p_plsql_id;
3918: EXCEPTION

Line 4426: FROM fnd_oam_dscram_args_b

4422: fnd_oam_debug.log(1, l_ctxt, 'Checking intermediate run C2 arg value...');
4423: BEGIN
4424: SELECT valid_value_flag, canonical_value
4425: INTO l_valid_value_flag, l_canonical_value
4426: FROM fnd_oam_dscram_args_b
4427: WHERE arg_id = p_c2_run_arg_id;
4428: IF l_valid_value_flag IS NULL OR l_valid_value_flag <> FND_API.G_TRUE THEN
4429: fnd_oam_debug.log(6, l_ctxt, 'Valid value flag of run C2 intermediate sum is incorrect: '||l_valid_value_flag);
4430: RAISE VALIDATE_FAILED;