eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_GEN_008

Line 34: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);

30: END IF;
31: -- Perform cross-status validations.
32: -- Get the system status values.
33: v_s_adm_entry_qual_status := IGS_AD_GEN_007.ADMP_GET_SAEQS (p_adm_entry_qual_status);
34: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
35: -- Validate against the admission outcome status.
36: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aeqs_aos (
37: v_s_adm_entry_qual_status,
38: v_s_adm_outcome_status,

Line 233: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);

229: END IF;
230: -- Perform cross-status validations.
231: -- Get the system status values.
232: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS (p_adm_doc_status);
233: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
234: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (p_adm_cndtnl_offer_status);
235: -- Validate against the admission outcome status.
236: IF IGS_AD_VAL_ACAI_STATUS.admp_val_ads_aos (
237: v_s_adm_doc_status,

Line 475: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (

471: p_message_name := v_message_name;
472: RETURN FALSE;
473: END IF;
474: -- Set local variables to system values
475: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
476: p_adm_offer_dfrmnt_status);
477: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
478: p_old_adm_dfrmnt_status);
479: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (

Line 477: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (

473: END IF;
474: -- Set local variables to system values
475: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
476: p_adm_offer_dfrmnt_status);
477: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
478: p_old_adm_dfrmnt_status);
479: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
480: p_adm_offer_resp_status);
481: -- Validate against the admission offer response status.

Line 479: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (

475: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
476: p_adm_offer_dfrmnt_status);
477: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
478: p_old_adm_dfrmnt_status);
479: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
480: p_adm_offer_resp_status);
481: -- Validate against the admission offer response status.
482: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aods_aors (
483: v_s_adm_offer_dfrmnt_status,

Line 550: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(

546: v_message_name) THEN
547: p_message_name := v_message_name;
548: RETURN FALSE;
549: END IF;
550: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(
551: p_adm_offer_dfrmnt_status);
552: -- Validate the offer response status against the system admission
553: -- process type and the admission process category step.
554: IF v_s_adm_offer_dfrmnt_status <> 'NOT-APPLIC' THEN

Line 752: v_s_late_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS (

748: v_message_name) THEN
749: p_message_name := v_message_name;
750: RETURN FALSE;
751: END IF;
752: v_s_late_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS (
753: p_late_adm_fee_status);
754: -- Validate against the course offering option details.
755: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_coo (
756: v_s_late_adm_fee_status,

Line 774: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (

770: v_message_name) THEN
771: p_message_name := v_message_name;
772: RETURN FALSE;
773: END IF;
774: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (
775: p_adm_outcome_status);
776: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (
777: p_adm_cndtnl_offer_status);
778: -- Validate against the admission outcome status.

Line 826: v_s_late_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(

822: p_message_name := v_message_name;
823: RETURN FALSE;
824: END IF;
825: -- Get the late admission fee status system value.
826: v_s_late_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(
827: p_late_adm_fee_status);
828: -- Validate when late applications are not allowed.
829: IF p_late_appl_allowed = 'N' AND
830: v_s_late_adm_fee_status <> 'NOT-APPLIC' THEN

Line 1129: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (

1125: p_message_name := v_message_name;
1126: RETURN FALSE;
1127: END IF;
1128:
1129: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
1130: p_adm_offer_resp_status);
1131: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
1132: p_old_adm_offer_resp_status);
1133: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (

Line 1131: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (

1127: END IF;
1128:
1129: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
1130: p_adm_offer_resp_status);
1131: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
1132: p_old_adm_offer_resp_status);
1133: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (
1134: p_adm_outcome_status);
1135:

Line 1133: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (

1129: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
1130: p_adm_offer_resp_status);
1131: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
1132: p_old_adm_offer_resp_status);
1133: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (
1134: p_adm_outcome_status);
1135:
1136: IF v_s_adm_offer_resp_status IN (cst_notcoming, cst_rejected) AND p_decline_ofr_reason IS NULL THEN --arvsrini igsm
1137: p_message_name := 'IGS_AD_ADMOFR_WITH_REAS';

Line 1157: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (

1153: v_message_name) THEN
1154: p_message_name := v_message_name;
1155: RETURN FALSE;
1156: END IF;
1157: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
1158: p_adm_offer_dfrmnt_status);
1159: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
1160: p_old_adm_offer_dfrmnt_status);
1161: -- Validate against the admission offer deferment status.

Line 1159: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (

1155: RETURN FALSE;
1156: END IF;
1157: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
1158: p_adm_offer_dfrmnt_status);
1159: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
1160: p_old_adm_offer_dfrmnt_status);
1161: -- Validate against the admission offer deferment status.
1162: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aods_aors (
1163: v_s_adm_offer_dfrmnt_status,

Line 1186: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);

1182: -- Determine the system admission outcome status and system admission
1183: -- offer response status. Will have already been determined if
1184: -- called from FORM.
1185: IF p_called_from = cst_trg_as THEN
1186: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
1187: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status);
1188: END IF;
1189: -- Validate multiple offers.
1190: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_offer_mult (

Line 1187: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status);

1183: -- offer response status. Will have already been determined if
1184: -- called from FORM.
1185: IF p_called_from = cst_trg_as THEN
1186: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
1187: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status);
1188: END IF;
1189: -- Validate multiple offers.
1190: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_offer_mult (
1191: p_person_id,

Line 1298: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(

1294: p_message_name := v_message_name;
1295: RETURN FALSE;
1296: END IF;
1297: -- Validate each value of offer response status.
1298: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(
1299: p_adm_offer_resp_status);
1300: IF v_s_adm_offer_resp_status = cst_pending THEN
1301: -- Re-admission only has accepted or rejected response status.
1302: IF p_s_admission_process_type = cst_readmit THEN

Line 1629: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);

1625: v_message_name) = FALSE) THEN
1626: p_message_name := v_message_name;
1627: RETURN FALSE;
1628: END IF;
1629: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1630: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_old_adm_outcome_status);
1631: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS(p_adm_doc_status);
1632: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
1633: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_late_adm_fee_status);

Line 1630: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_old_adm_outcome_status);

1626: p_message_name := v_message_name;
1627: RETURN FALSE;
1628: END IF;
1629: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1630: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_old_adm_outcome_status);
1631: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS(p_adm_doc_status);
1632: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
1633: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_late_adm_fee_status);
1634: -- Validate against the other admission course

Line 1632: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);

1628: END IF;
1629: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1630: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_old_adm_outcome_status);
1631: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS(p_adm_doc_status);
1632: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
1633: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_late_adm_fee_status);
1634: -- Validate against the other admission course
1635: -- application instance status values
1636: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aos_status(

Line 1633: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_late_adm_fee_status);

1629: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1630: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_old_adm_outcome_status);
1631: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS(p_adm_doc_status);
1632: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
1633: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_late_adm_fee_status);
1634: -- Validate against the other admission course
1635: -- application instance status values
1636: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aos_status(
1637: v_s_adm_outcome_status,

Line 1684: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);

1680: v_message_name) = FALSE) THEN
1681: p_message_name := v_message_name;
1682: RETURN FALSE;
1683: END IF;
1684: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
1685: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_old_adm_offer_resp_status);
1686: -- Validate the admission outcome status against
1687: -- the admission offer response status
1688: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aors_aos(

Line 1685: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_old_adm_offer_resp_status);

1681: p_message_name := v_message_name;
1682: RETURN FALSE;
1683: END IF;
1684: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
1685: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_old_adm_offer_resp_status);
1686: -- Validate the admission outcome status against
1687: -- the admission offer response status
1688: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aors_aos(
1689: v_s_adm_offer_resp_status,

Line 1705: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);

1701: -- Determine the system admission outcome status and system admission offer
1702: -- response status.
1703: -- If called from Form then this will have already been determined.
1704: IF p_called_from = cst_trg_as THEN
1705: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1706: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
1707: END IF;
1708: -- Validate the admission course application instance outcome
1709: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acai_otcome(

Line 1706: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);

1702: -- response status.
1703: -- If called from Form then this will have already been determined.
1704: IF p_called_from = cst_trg_as THEN
1705: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1706: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
1707: END IF;
1708: -- Validate the admission course application instance outcome
1709: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acai_otcome(
1710: p_person_id,

Line 1850: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (

1846: v_message_name) = FALSE) THEN
1847: p_message_name := v_message_name;
1848: RETURN FALSE;
1849: END IF;
1850: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (
1851: p_adm_outcome_status);
1852: -- Validate the admission outcome status against the admission process
1853: -- category steps.
1854: -- Validate if outcome can be set.

Line 1873: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(

1869: -- when conditional offers are not allowed.
1870: p_message_name := 'IGS_AD_CONDOFR_NOT_MADE';
1871: RETURN FALSE;
1872: END IF;
1873: v_old_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(
1874: p_old_adm_outcome_status);
1875: -- Validate change of the admission outcome status value.
1876: IF(v_s_adm_outcome_status IN (cst_withdrawn, cst_voided) AND
1877: v_old_s_adm_outcome_status IN (cst_pending, cst_rejected, cst_no_quota) AND

Line 1909: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS (

1905: END IF;
1906: CLOSE c_sap;
1907: END IF;
1908:
1909: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS (
1910: p_adm_fee_status);
1911: -- Validate a non-fee conditional offer.
1912: IF(v_s_adm_outcome_status = cst_cond_offer AND
1913: p_cond_offer_fee_allowed = 'N' AND

Line 2854: v_s_adm_outcome_status := (IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status));

2850: -- Set the default message number
2851: p_message_name := NULL;
2852: p_return_type := NULL;
2853: -- Get the status system values.
2854: v_s_adm_outcome_status := (IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status));
2855: v_s_adm_offer_resp_status := (IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status));
2856: IF v_s_adm_outcome_status IN (
2857: cst_offer,
2858: cst_cond_offer) AND

Line 2855: v_s_adm_offer_resp_status := (IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status));

2851: p_message_name := NULL;
2852: p_return_type := NULL;
2853: -- Get the status system values.
2854: v_s_adm_outcome_status := (IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status));
2855: v_s_adm_offer_resp_status := (IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status));
2856: IF v_s_adm_outcome_status IN (
2857: cst_offer,
2858: cst_cond_offer) AND
2859: v_s_adm_offer_resp_status not in (cst_rejected, cst_not_applic) THEN

Line 2996: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(

2992: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS(
2993: p_adm_cndtnl_offer_status);
2994: v_old_s_adm_cndtnl_offer_stat := IGS_AD_GEN_007.ADMP_GET_SACOS(
2995: p_old_adm_cndtnl_offer_status);
2996: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(
2997: p_adm_outcome_status);
2998: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS(
2999: p_adm_doc_status);
3000: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(

Line 3000: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(

2996: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(
2997: p_adm_outcome_status);
2998: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS(
2999: p_adm_doc_status);
3000: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(
3001: p_late_adm_fee_status);
3002: --Validate against the other admission course application instance status
3003: -- values.
3004: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acos_status (

Line 3074: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);

3070: IF (p_fees_required = 'Y' AND
3071: v_s_adm_cndtnl_offer_status = 'SATISFIED') THEN
3072: --The admission conditional offer status cannot be satisfied if
3073: --application fees are still being assessed or haven't been determined.
3074: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
3075: IF (v_s_adm_fee_status IN ('PENDING', 'ASSESSED')) THEN
3076: p_message_name := 'IGS_AD_CONDOFR_NOTSATISFIED';
3077: RETURN FALSE;
3078: END IF;

Line 3256: v_new_ofr_dfrmnt_status := igs_ad_gen_008.admp_get_saods(p_offer_deferment_status);

3252: v_new_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3253: v_ofr_dfrmnt_status igs_ad_ps_appl_inst.adm_offer_dfrmnt_status%TYPE;
3254: v_s_ofr_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
3255: BEGIN
3256: v_new_ofr_dfrmnt_status := igs_ad_gen_008.admp_get_saods(p_offer_deferment_status);
3257: IF v_new_ofr_dfrmnt_status = 'CONFIRM' THEN
3258: OPEN cur_offer_dfrmnt_status (p_person_id,p_admission_appl_number,p_nominated_course_cd,
3259: p_sequence_number);
3260: FETCH cur_offer_dfrmnt_status INTO v_ofr_dfrmnt_status ;

Line 3262: v_s_ofr_dfrmnt_status :=igs_ad_gen_008.admp_get_saods(v_ofr_dfrmnt_status) ;

3258: OPEN cur_offer_dfrmnt_status (p_person_id,p_admission_appl_number,p_nominated_course_cd,
3259: p_sequence_number);
3260: FETCH cur_offer_dfrmnt_status INTO v_ofr_dfrmnt_status ;
3261: CLOSE cur_offer_dfrmnt_status;
3262: v_s_ofr_dfrmnt_status :=igs_ad_gen_008.admp_get_saods(v_ofr_dfrmnt_status) ;
3263: IF v_s_ofr_dfrmnt_status NOT IN ('APPROVED','CONFIRM') THEN
3264: p_message_name := 'IGS_AD_CONF_WITHOUT_APR';
3265: RETURN FALSE;
3266: ELSE

Line 3311: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);

3307: END IF;
3308:
3309: -- Set local variables to system values
3310: v_s_appl_inst_status := IGS_AD_GEN_007.ADMP_GET_SAAS(p_appl_inst_status);
3311: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
3312:
3313: IF v_s_appl_inst_status = 'WITHDRAWN' and p_ais_reason IS NULL THEN
3314: p_message_name := 'IGS_AD_WITHD_RSN_MISSING';
3315: RETURN FALSE;