DBA Data[Home] [Help]

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_VAL_ACAI_STATUS

Line 1112: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aeqs (

1108: --
1109: -- Validate admission entry qualification status.
1110: --
1111: IF NVL(old_references.adm_entry_qual_status, '-1') <> new_references.adm_entry_qual_status THEN
1112: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aeqs (
1113: new_references.adm_entry_qual_status,
1114: new_references.adm_outcome_status,
1115: v_s_admission_process_type,
1116: v_message_name) = FALSE THEN

Line 1126: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ads (

1122: --
1123: -- Validate admission documentation status.
1124: --
1125: IF NVL(old_references.adm_doc_status, '-1') <> new_references.adm_doc_status THEN
1126: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ads (
1127: new_references.adm_doc_status,
1128: new_references.adm_outcome_status,
1129: new_references.adm_cndtnl_offer_status,
1130: v_s_admission_process_type,

Line 1150: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_lafs (

1146: NVL(old_references.attendance_mode, '-1') <> NVL(new_references.attendance_type, '-1') OR
1147: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1148: NVL(old_references.adm_ci_sequence_number, -1) <>
1149: NVL(new_references.adm_ci_sequence_number, -1) THEN
1150: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_lafs (
1151: new_references.late_adm_fee_status,
1152: v_late_appl_allowed_ind,
1153: v_late_fees_required_ind,
1154: v_cond_offer_fee_allowed_ind,

Line 1191: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (

1187: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status AND
1188: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'SUSPENDED' AND
1189: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'WITHDRAWN') --nshee bug 2630217
1190: THEN
1191: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (
1192: new_references.person_id,
1193: new_references.admission_appl_number,
1194: new_references.nominated_course_cd,
1195: new_references.sequence_number,

Line 1244: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aos_update (

1240: END IF;
1241: END IF;
1242: IF NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status THEN
1243: -- Validate update of admission outcome status.
1244: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aos_update (
1245: new_references.person_id,
1246: new_references.admission_appl_number,
1247: new_references.adm_outcome_status,
1248: NVL(old_references.adm_outcome_status, IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING')),

Line 1263: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ais (

1259:
1260: ---validate application instance status
1261: IF NVL(old_references.appl_inst_status, '-1') <> NVL(new_references.appl_inst_status,'-1') THEN --arvsrini igsm
1262:
1263: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ais (
1264: new_references.appl_inst_status,
1265: new_references.ais_reason ,
1266: new_references.adm_outcome_status,
1267: v_message_name)= FALSE THEN

Line 1284: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (

1280: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1281: NVL(old_references.adm_offer_resp_status, '-1') <> new_references.adm_offer_resp_status OR
1282: NVL(TRUNC(old_references.actual_response_dt), IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1283: NVL(new_references.actual_response_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
1284: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (
1285: new_references.person_id,
1286: new_references.admission_appl_number,
1287: new_references.nominated_course_cd,
1288: new_references.sequence_number,

Line 1322: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_acos (

1318: -- Validate admission conditional offer.
1319: --
1320: IF NVL(old_references.adm_cndtnl_offer_status, '-1') <> new_references.adm_cndtnl_offer_status OR
1321: NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status THEN
1322: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_acos (
1323: new_references.adm_cndtnl_offer_status,
1324: NVL(old_references.adm_cndtnl_offer_status, IGS_AD_GEN_009.ADMP_GET_SYS_ACOS('NOT-APPLIC')),
1325: new_references.adm_outcome_status,
1326: new_references.adm_outcome_status,

Line 1345: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aods (

1341: -- Validate admission offer deferment status.
1342: --
1343: IF NVL(old_references.course_cd, '-1') <> new_references.course_cd OR
1344: NVL(old_references.adm_offer_dfrmnt_status, '-1') <> new_references.adm_offer_dfrmnt_status THEN
1345: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aods (
1346: new_references.person_id,
1347: new_references.admission_appl_number,
1348: new_references.nominated_course_cd,
1349: new_references.sequence_number,

Line 2146: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (

2142: IF NVL(p_inserting,FALSE) OR NVL(p_updating,FALSE) THEN
2143: --
2144: -- Validate admission outcome status.
2145: --
2146: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (
2147: new_references.person_id,
2148: new_references.admission_appl_number,
2149: new_references.nominated_course_cd,
2150: new_references.sequence_number,

Line 2199: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (

2195: END IF;
2196: --
2197: -- Validate admission offer response status.
2198: --
2199: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors (
2200: new_references.person_id,
2201: new_references.admission_appl_number,
2202: new_references.nominated_course_cd,
2203: new_references.sequence_number,

Line 2234: IF IGS_AD_VAL_ACAI_STATUS.admp_val_offer_x_apc (

2230: END IF;
2231: --
2232: -- Validate multiple offers across admission process categories.
2233: --
2234: IF IGS_AD_VAL_ACAI_STATUS.admp_val_offer_x_apc (
2235: new_references.person_id,
2236: new_references.admission_appl_number,
2237: new_references.nominated_course_cd,
2238: new_references.sequence_number,