APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_ARG_VALUES

Line 417: FROM fnd_oam_dscram_arg_values

413: BEGIN
414: IF p_using_splitting THEN
415: SELECT SUM(to_number(canonical_value))
416: INTO l_c2_sum
417: FROM fnd_oam_dscram_arg_values
418: WHERE arg_id = p_c2_arg_id
419: AND valid_value_flag = FND_API.G_TRUE;
420: ELSE
421: SELECT valid_value_flag, canonical_value

Line 447: FROM fnd_oam_dscram_arg_values

443: BEGIN
444: IF p_using_splitting THEN
445: SELECT SUM(to_number(canonical_value))
446: INTO l_c3_bad_count
447: FROM fnd_oam_dscram_arg_values
448: WHERE arg_id = p_c3_arg_id
449: AND valid_value_flag = FND_API.G_TRUE;
450: ELSE
451: SELECT valid_value_flag, canonical_value

Line 478: FROM fnd_oam_dscram_arg_values

474: BEGIN
475: IF p_using_splitting THEN
476: SELECT SUM(to_number(canonical_value))
477: INTO l_c4_bad_count
478: FROM fnd_oam_dscram_arg_values
479: WHERE arg_id = p_c4_arg_id
480: AND valid_value_flag = FND_API.G_TRUE;
481: ELSE
482: SELECT valid_value_flag, canonical_value

Line 635: DELETE FROM fnd_oam_dscram_arg_values

631: AND arg_name = l_arg_name
632: RETURNING arg_id INTO l_arg_id;
633: DELETE FROM fnd_oam_dscram_args_tl
634: WHERE arg_id = l_arg_id;
635: DELETE FROM fnd_oam_dscram_arg_values
636: WHERE arg_id = l_arg_id;
637: k := p_global_arg_names.NEXT(k);
638: END LOOP;
639: RETURN TRUE;

Line 3125: FROM fnd_oam_dscram_arg_values

3121: --make sure that the run c2 sum also equals the # of rows.
3122: BEGIN
3123: SELECT SUM(to_number(canonical_value))
3124: INTO l_c2_run_sum
3125: FROM fnd_oam_dscram_arg_values
3126: WHERE arg_id = p_c2_run_arg_id
3127: AND valid_value_flag = FND_API.G_TRUE
3128: AND rownum < 2;
3129: EXCEPTION

Line 3715: FROM fnd_oam_dscram_arg_values

3711: --get the value of the verdict output arg
3712: BEGIN
3713: SELECT valid_value_flag, canonical_value
3714: INTO l_valid_value_flag, l_canonical_value
3715: FROM fnd_oam_dscram_arg_values
3716: WHERE arg_id = p_verdict_arg_id;
3717: EXCEPTION
3718: WHEN OTHERS THEN
3719: fnd_oam_debug.log(6, l_ctxt, 'Failed to query arg value for verdict: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 4407: FROM fnd_oam_dscram_arg_values

4403: --make sure the plsql's verdict came out ok
4404: BEGIN
4405: SELECT COUNT(ROWID)
4406: INTO l_count
4407: FROM fnd_oam_dscram_arg_values
4408: WHERE arg_id = p_verdict_arg_id
4409: AND (valid_value_flag IS NULL OR valid_value_flag <> FND_API.G_TRUE)
4410: AND (canonical_value IS NULL OR canonical_value <> FND_API.G_TRUE);
4411: EXCEPTION