DBA Data[Home] [Help]

APPS.IGS_AV_GEN_001 dependencies on IGS_AV_VAL_ASU

Line 761: IF (IGS_AV_VAL_ASU.advp_val_as_grant(

757: NULL; -- do nothing, continue IGS_AV_STND_UNIT
758: ELSE
759: v_last_course_cd := v_asu_rec.as_course_cd;
760: v_last_version_number := v_asu_rec.as_version_number;
761: IF (IGS_AV_VAL_ASU.advp_val_as_grant(
762: v_asu_rec.person_id,
763: v_asu_rec.as_course_cd,
764: v_asu_rec.as_version_number,
765: v_asu_rec.s_adv_stnd_granting_status,

Line 788: IF (IGS_AV_VAL_ASU.advp_val_as_totals(

784: GOTO continue;
785: END IF;
786: END IF;
787: -- Validate course version advanced standing internal/external limits
788: IF (IGS_AV_VAL_ASU.advp_val_as_totals(
789: v_asu_rec.person_id,
790: v_asu_rec.as_course_cd,
791: v_asu_rec.as_version_number,
792: TRUE,

Line 1067: IF (IGS_AV_VAL_ASU.advp_val_as_grant(

1063: NULL; -- do nothing, continue IGS_AV_STND_UNIT
1064: ELSE
1065: v_last_course_cd := v_asul_rec.as_course_cd;
1066: v_last_version_number := v_asul_rec.as_version_number;
1067: IF (IGS_AV_VAL_ASU.advp_val_as_grant(
1068: v_asul_rec.person_id,
1069: v_asul_rec.as_course_cd,
1070: v_asul_rec.as_version_number,
1071: v_asul_rec.s_adv_stnd_granting_status,

Line 1095: IF (IGS_AV_VAL_ASU.advp_val_as_totals(

1091: GOTO continue1;
1092: END IF;
1093: END IF;
1094: -- Validate course version advanced standing limits
1095: IF (IGS_AV_VAL_ASU.advp_val_as_totals(
1096: v_asul_rec.person_id,
1097: v_asul_rec.as_course_cd,
1098: v_asul_rec.as_version_number,
1099: TRUE,

Line 1266: IF (IGS_AV_VAL_ASU.advp_val_as_totals (

1262: p_message_name := 'IGS_AV_INSUFFICIENT_INFO_VER';
1263: RETURN FALSE;
1264: END IF;
1265: -- get advanced standing exemption totals
1266: IF (IGS_AV_VAL_ASU.advp_val_as_totals (
1267: p_person_id,
1268: p_course_cd,
1269: p_version_number,
1270: TRUE,

Line 1471: IF (IGS_AV_VAL_ASU.advp_get_ua_del_alwd (

1467: -- (will need to return TRUE or FALSE)
1468: -- this determines if a IGS_EN_SU_ATTEMPT
1469: -- can be deleted because advanced standing is
1470: -- granted prior to the advanced standing cut-off date
1471: IF (IGS_AV_VAL_ASU.advp_get_ua_del_alwd (
1472: p_del_cal_type,
1473: p_del_ci_seq_num,
1474: p_del_granted_dt) = TRUE) THEN
1475: -- delete the record

Line 2022: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');

2018: RETURN 'Y';
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2022: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');
2023: App_Exception.Raise_Exception;
2024: IGS_GE_MSG_STACK.ADD;
2025: END;
2026: END advp_val_basis_year;

Line 2145: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.eval_unit_repeat');

2141: RETURN 'Y';
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2145: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.eval_unit_repeat');
2146: App_Exception.Raise_Exception;
2147: IGS_GE_MSG_STACK.ADD;
2148: END eval_unit_repeat;
2149:

Line 2239: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.advp_updt_advstnd' || sqlerrm);

2235: EXCEPTION
2236: WHEN OTHERS
2237: THEN
2238: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2239: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.advp_updt_advstnd' || sqlerrm);
2240: App_Exception.Raise_Exception;
2241: IGS_GE_MSG_STACK.ADD;
2242:
2243: END advp_updt_advstnd;