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_ADMAPPLICATION_PUB dependencies on IGS_AD_PS_APPL_INST_ALL

Line 120: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));

116: l_msg_index := igs_ge_msg_stack.count_msg;
117:
118: -- Validate all the parameters for their length
119: -- PERSON_ID
120: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
121: -- P_ADMISSION_APPL_NUMBER
122: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
123: -- p_nominated_program_cd
124: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));

Line 122: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));

118: -- Validate all the parameters for their length
119: -- PERSON_ID
120: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
121: -- P_ADMISSION_APPL_NUMBER
122: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
123: -- p_nominated_program_cd
124: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
125: -- P_SEQUENCE_NUMBER
126: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

Line 124: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));

120: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
121: -- P_ADMISSION_APPL_NUMBER
122: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
123: -- p_nominated_program_cd
124: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
125: -- P_SEQUENCE_NUMBER
126: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
127: -- P_ACADEMIC_INDEX
128: check_length('ACADEMIC_INDEX', 'IGS_AD_PS_APPL_INST_ALL', length(p_academic_index));

Line 126: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

122: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
123: -- p_nominated_program_cd
124: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
125: -- P_SEQUENCE_NUMBER
126: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
127: -- P_ACADEMIC_INDEX
128: check_length('ACADEMIC_INDEX', 'IGS_AD_PS_APPL_INST_ALL', length(p_academic_index));
129: -- P_PREDICTED_GPA
130: check_length('PREDICTED_GPA', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_predicted_gpa)));

Line 128: check_length('ACADEMIC_INDEX', 'IGS_AD_PS_APPL_INST_ALL', length(p_academic_index));

124: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
125: -- P_SEQUENCE_NUMBER
126: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
127: -- P_ACADEMIC_INDEX
128: check_length('ACADEMIC_INDEX', 'IGS_AD_PS_APPL_INST_ALL', length(p_academic_index));
129: -- P_PREDICTED_GPA
130: check_length('PREDICTED_GPA', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_predicted_gpa)));
131: -- END OF PARAMETER VALIDATIONS.
132:

Line 130: check_length('PREDICTED_GPA', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_predicted_gpa)));

126: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
127: -- P_ACADEMIC_INDEX
128: check_length('ACADEMIC_INDEX', 'IGS_AD_PS_APPL_INST_ALL', length(p_academic_index));
129: -- P_PREDICTED_GPA
130: check_length('PREDICTED_GPA', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_predicted_gpa)));
131: -- END OF PARAMETER VALIDATIONS.
132:
133:
134: -- Initialize API return status to success

Line 545: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));

541:
542:
543: -- Validate all the parameters for their length
544: -- PERSON_ID
545: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
546: -- P_ADMISSION_APPL_NUMBER
547: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
548: -- p_nominated_program_cd
549: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));

Line 547: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));

543: -- Validate all the parameters for their length
544: -- PERSON_ID
545: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
546: -- P_ADMISSION_APPL_NUMBER
547: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
548: -- p_nominated_program_cd
549: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
550: -- P_SEQUENCE_NUMBER
551: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

Line 549: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));

545: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
546: -- P_ADMISSION_APPL_NUMBER
547: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
548: -- p_nominated_program_cd
549: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
550: -- P_SEQUENCE_NUMBER
551: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
552: -- P_ADM_OUTCOME_STATUS
553: check_length('ADM_OUTCOME_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status));

Line 551: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

547: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
548: -- p_nominated_program_cd
549: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
550: -- P_SEQUENCE_NUMBER
551: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
552: -- P_ADM_OUTCOME_STATUS
553: check_length('ADM_OUTCOME_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status));
554: -- P_DECISION_MAKER_ID
555: check_length('DECISION_MAKE_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_maker_id)));

Line 553: check_length('ADM_OUTCOME_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status));

549: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
550: -- P_SEQUENCE_NUMBER
551: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
552: -- P_ADM_OUTCOME_STATUS
553: check_length('ADM_OUTCOME_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status));
554: -- P_DECISION_MAKER_ID
555: check_length('DECISION_MAKE_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_maker_id)));
556: -- P_DECISION_REASON_ID
557: check_length('DECISION_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_reason_id)));

Line 555: check_length('DECISION_MAKE_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_maker_id)));

551: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
552: -- P_ADM_OUTCOME_STATUS
553: check_length('ADM_OUTCOME_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status));
554: -- P_DECISION_MAKER_ID
555: check_length('DECISION_MAKE_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_maker_id)));
556: -- P_DECISION_REASON_ID
557: check_length('DECISION_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_reason_id)));
558: -- P_PENDING_REASON_ID
559: check_length('PENDING_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_pending_reason_id)));

Line 557: check_length('DECISION_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_reason_id)));

553: check_length('ADM_OUTCOME_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status));
554: -- P_DECISION_MAKER_ID
555: check_length('DECISION_MAKE_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_maker_id)));
556: -- P_DECISION_REASON_ID
557: check_length('DECISION_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_reason_id)));
558: -- P_PENDING_REASON_ID
559: check_length('PENDING_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_pending_reason_id)));
560: -- P_ADM_OTCM_STATUS_AUTH_PER_ID
561: check_length('ADM_OTCM_STATUS_AUTH_PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_adm_otcm_status_auth_per_id)));

Line 559: check_length('PENDING_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_pending_reason_id)));

555: check_length('DECISION_MAKE_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_maker_id)));
556: -- P_DECISION_REASON_ID
557: check_length('DECISION_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_reason_id)));
558: -- P_PENDING_REASON_ID
559: check_length('PENDING_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_pending_reason_id)));
560: -- P_ADM_OTCM_STATUS_AUTH_PER_ID
561: check_length('ADM_OTCM_STATUS_AUTH_PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_adm_otcm_status_auth_per_id)));
562: -- P_ADM_OUTCOME_STATUS_REASON
563: check_length('ADM_OUTCOME_STATUS_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status_reason));

Line 561: check_length('ADM_OTCM_STATUS_AUTH_PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_adm_otcm_status_auth_per_id)));

557: check_length('DECISION_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_decision_reason_id)));
558: -- P_PENDING_REASON_ID
559: check_length('PENDING_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_pending_reason_id)));
560: -- P_ADM_OTCM_STATUS_AUTH_PER_ID
561: check_length('ADM_OTCM_STATUS_AUTH_PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_adm_otcm_status_auth_per_id)));
562: -- P_ADM_OUTCOME_STATUS_REASON
563: check_length('ADM_OUTCOME_STATUS_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status_reason));
564: -- P_ADM_CNDTNL_OFFER_STATUS
565: check_length('ADM_CNDTNL_OFFER_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_cndtnl_offer_status));

Line 563: check_length('ADM_OUTCOME_STATUS_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status_reason));

559: check_length('PENDING_REASON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_pending_reason_id)));
560: -- P_ADM_OTCM_STATUS_AUTH_PER_ID
561: check_length('ADM_OTCM_STATUS_AUTH_PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_adm_otcm_status_auth_per_id)));
562: -- P_ADM_OUTCOME_STATUS_REASON
563: check_length('ADM_OUTCOME_STATUS_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status_reason));
564: -- P_ADM_CNDTNL_OFFER_STATUS
565: check_length('ADM_CNDTNL_OFFER_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_cndtnl_offer_status));
566: -- P_CNDTNL_OFFER_CNDTN
567: check_length('CNDTNL_OFFER_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtnl_offer_cndtn));

Line 565: check_length('ADM_CNDTNL_OFFER_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_cndtnl_offer_status));

561: check_length('ADM_OTCM_STATUS_AUTH_PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_adm_otcm_status_auth_per_id)));
562: -- P_ADM_OUTCOME_STATUS_REASON
563: check_length('ADM_OUTCOME_STATUS_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status_reason));
564: -- P_ADM_CNDTNL_OFFER_STATUS
565: check_length('ADM_CNDTNL_OFFER_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_cndtnl_offer_status));
566: -- P_CNDTNL_OFFER_CNDTN
567: check_length('CNDTNL_OFFER_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtnl_offer_cndtn));
568: -- P_CNDTL_OFFER_MUST_STSFD_IND
569: check_length('CNDTNL_OFFER_MUST_BE_STSFD_IND', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtl_offer_must_stsfd_ind));

Line 567: check_length('CNDTNL_OFFER_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtnl_offer_cndtn));

563: check_length('ADM_OUTCOME_STATUS_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_outcome_status_reason));
564: -- P_ADM_CNDTNL_OFFER_STATUS
565: check_length('ADM_CNDTNL_OFFER_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_cndtnl_offer_status));
566: -- P_CNDTNL_OFFER_CNDTN
567: check_length('CNDTNL_OFFER_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtnl_offer_cndtn));
568: -- P_CNDTL_OFFER_MUST_STSFD_IND
569: check_length('CNDTNL_OFFER_MUST_BE_STSFD_IND', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtl_offer_must_stsfd_ind));
570: -- P_RECONSIDER_FLAG
571: check_length('REQ_FOR_RECONSIDERATION_IND', 'IGS_AD_PS_APPL', length(p_reconsider_flag));

Line 569: check_length('CNDTNL_OFFER_MUST_BE_STSFD_IND', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtl_offer_must_stsfd_ind));

565: check_length('ADM_CNDTNL_OFFER_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_cndtnl_offer_status));
566: -- P_CNDTNL_OFFER_CNDTN
567: check_length('CNDTNL_OFFER_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtnl_offer_cndtn));
568: -- P_CNDTL_OFFER_MUST_STSFD_IND
569: check_length('CNDTNL_OFFER_MUST_BE_STSFD_IND', 'IGS_AD_PS_APPL_INST_ALL', length(p_cndtl_offer_must_stsfd_ind));
570: -- P_RECONSIDER_FLAG
571: check_length('REQ_FOR_RECONSIDERATION_IND', 'IGS_AD_PS_APPL', length(p_reconsider_flag));
572:
573:

Line 1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,

1280: p_adm_offer_resp_status IN igs_ad_offresp_int.adm_offer_resp_status%TYPE ,
1281: p_actual_offer_response_dt IN igs_ad_offresp_int.actual_offer_response_dt%TYPE,
1282: p_applicant_acptnce_cndtn IN igs_ad_offresp_int.applicant_acptnce_cndtn%TYPE,
1283: -- p_attent_other_inst_cd IN igs_ad_offresp_int.attent_other_inst_cd%TYPE,
1284: p_adm_offer_defr_status IN OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
1285: -- p_authorized_dt IN DATE, -- if null then default it to sys date. and validation exists in Form(pld)
1286: -- p_authorizing_pers_id IN NUMBER, --NUMBER(15) LOV (No validation) need to write validations
1287: p_def_acad_cal_type IN igs_ad_offresp_int.def_acad_cal_type%TYPE ,
1288: p_def_acad_ci_sequence_number IN igs_ad_offresp_int.def_acad_ci_sequence_number%TYPE,

Line 1318: CURSOR cur_ad_ps_appl_inst ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE ,

1314: WHERE person_id = cp_person_id AND
1315: admission_appl_number = cp_admission_appl_number;
1316:
1317: -- to get teh application instance
1318: CURSOR cur_ad_ps_appl_inst ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE ,
1319: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE ,
1320: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE ,
1321: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
1322: ) IS

Line 1319: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE ,

1315: admission_appl_number = cp_admission_appl_number;
1316:
1317: -- to get teh application instance
1318: CURSOR cur_ad_ps_appl_inst ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE ,
1319: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE ,
1320: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE ,
1321: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
1322: ) IS
1323: SELECT aplinst.rowid, aplinst.*

Line 1320: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE ,

1316:
1317: -- to get teh application instance
1318: CURSOR cur_ad_ps_appl_inst ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE ,
1319: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE ,
1320: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE ,
1321: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
1322: ) IS
1323: SELECT aplinst.rowid, aplinst.*
1324: FROM igs_ad_ps_appl_inst_all aplinst

Line 1321: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE

1317: -- to get teh application instance
1318: CURSOR cur_ad_ps_appl_inst ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE ,
1319: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE ,
1320: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE ,
1321: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
1322: ) IS
1323: SELECT aplinst.rowid, aplinst.*
1324: FROM igs_ad_ps_appl_inst_all aplinst
1325: WHERE person_id = cp_person_id AND

Line 1324: FROM igs_ad_ps_appl_inst_all aplinst

1320: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE ,
1321: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
1322: ) IS
1323: SELECT aplinst.rowid, aplinst.*
1324: FROM igs_ad_ps_appl_inst_all aplinst
1325: WHERE person_id = cp_person_id AND
1326: admission_appl_number = cp_admission_appl_number AND
1327: nominated_course_cd = cp_nominated_course_cd AND
1328: sequence_number = cp_sequence_number;

Line 1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;

1362: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;

Line 1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;

1363: v_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE;
1364: v_aa_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1365: v_aa_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1366: v_acaiv_adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE;
1367: v_acaiv_adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE;
1368: v_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
1369: v_adm_ci_sequence_number igs_ad_appl.adm_ci_sequence_number%TYPE;
1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

Line 1375: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
1374: l_application_id igs_ad_appl_all.application_id%TYPE;
1375: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1376: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
1377: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
1378: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;
1379: l_appl_rec c_adm_appl_dtl%ROWTYPE;

Line 1442: -- Check if New Offer Response status = Production table (IGS_AD_PS_APPL_INST_ALL) Offer Response Status.

1438: END IF;
1439:
1440:
1441: -- ********** VALIDATIONS WHICH CHECK FOR THE PROPER COMBINATION OF New Offer response status Vs SYSTEM TABLE Offer Response Status. Stop processing in case of failure
1442: -- Check if New Offer Response status = Production table (IGS_AD_PS_APPL_INST_ALL) Offer Response Status.
1443: IF p_adm_offer_resp_status = l_acaiv_rec.adm_offer_resp_status THEN
1444: p_validation_success := 'N';
1445: fnd_message.set_name('IGS', 'IGS_AD_RESP_SATUS_NOT_CHANGE');
1446: IGS_GE_MSG_STACK.ADD;

Line 1725: l_response_comments igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;

1721: l_validation_success VARCHAR2(1);
1722: l_calc_actual_response_dt DATE;
1723: l_adm_offer_dfrmnt_status VARCHAR2(10);
1724:
1725: l_response_comments igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;
1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;
1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;

Line 1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;

1722: l_calc_actual_response_dt DATE;
1723: l_adm_offer_dfrmnt_status VARCHAR2(10);
1724:
1725: l_response_comments igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;
1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;
1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;
1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;

Line 1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;

1723: l_adm_offer_dfrmnt_status VARCHAR2(10);
1724:
1725: l_response_comments igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;
1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;
1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;
1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;
1731: l_attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE;

Line 1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;

1724:
1725: l_response_comments igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;
1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;
1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;
1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;
1731: l_attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE;
1732: l_enrl_message_name VARCHAR2(30);

Line 1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;

1725: l_response_comments igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE;
1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;
1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;
1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;
1731: l_attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE;
1732: l_enrl_message_name VARCHAR2(30);
1733:

Line 1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;

1726: l_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE;
1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;
1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;
1731: l_attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE;
1732: l_enrl_message_name VARCHAR2(30);
1733:
1734: CURSOR cur_ad_ps_appl_inst( cp_person_id igs_ad_ps_appl_inst.person_id%type ,

Line 1731: l_attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE;

1727: l_def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE;
1728: l_def_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE;
1729: l_def_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE;
1730: l_decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE;
1731: l_attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE;
1732: l_enrl_message_name VARCHAR2(30);
1733:
1734: CURSOR cur_ad_ps_appl_inst( cp_person_id igs_ad_ps_appl_inst.person_id%type ,
1735: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%type ,

Line 1766: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));

1762: l_msg_index := igs_ge_msg_stack.count_msg;
1763: --Assign all defaul values
1764:
1765: -- Validate all the parameters for their length
1766: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));

Line 1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));

1763: --Assign all defaul values
1764:
1765: -- Validate all the parameters for their length
1766: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));

Line 1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));

1764:
1765: -- Validate all the parameters for their length
1766: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));

Line 1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

1765: -- Validate all the parameters for their length
1766: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));

Line 1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));

1766: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));

Line 1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));

1767: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));

Line 1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));

1768: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));

Line 1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));

1769: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));
1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));

Line 1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));

1770: check_length('ADM_OFFER_RESP_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_resp_status));
1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));
1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));
1778: check_length('ATTENT_OTHER_INST_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_attent_other_inst_cd));

Line 1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));

1771: check_length('APPLICANT_ACPTNCE_CNDTN', 'IGS_AD_PS_APPL_INST_ALL', length(p_response_comments));
1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));
1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));
1778: check_length('ATTENT_OTHER_INST_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_attent_other_inst_cd));
1779:

Line 1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));

1772: -- check_length('ADM_OFFER_DFRMNT_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_adm_offer_dfrmnt_status));
1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));
1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));
1778: check_length('ATTENT_OTHER_INST_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_attent_other_inst_cd));
1779:
1780: l_adm_offer_dfrmnt_status := NULL;

Line 1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));

1773: check_length('DEF_ACAD_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_acad_cal_type));
1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));
1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));
1778: check_length('ATTENT_OTHER_INST_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_attent_other_inst_cd));
1779:
1780: l_adm_offer_dfrmnt_status := NULL;
1781:

Line 1778: check_length('ATTENT_OTHER_INST_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_attent_other_inst_cd));

1774: check_length('DEF_ACAD_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_acad_ci_sequence_num)));
1775: check_length('DEFERRED_ADM_CAL_TYPE', 'IGS_AD_PS_APPL_INST_ALL', length(p_def_adm_cal_type));
1776: check_length('DEFERRED_ADM_CI_SEQUENCE_NUM', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_def_adm_ci_sequence_num)));
1777: check_length('DECLINE_OFR_REASON', 'IGS_AD_PS_APPL_INST_ALL', length(p_decline_ofr_reason));
1778: check_length('ATTENT_OTHER_INST_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_attent_other_inst_cd));
1779:
1780: l_adm_offer_dfrmnt_status := NULL;
1781:
1782: OPEN cur_ad_ps_appl_inst(p_person_id,

Line 2170: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));

2166: l_msg_index := igs_ge_msg_stack.count_msg;
2167:
2168: -- Validate all the parameters for their length
2169: -- PERSON_ID
2170: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
2171: -- P_ADMISSION_APPL_NUMBER
2172: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2173: -- p_nominated_course_cd
2174: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_course_cd));

Line 2172: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));

2168: -- Validate all the parameters for their length
2169: -- PERSON_ID
2170: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
2171: -- P_ADMISSION_APPL_NUMBER
2172: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2173: -- p_nominated_course_cd
2174: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_course_cd));
2175: -- P_SEQUENCE_NUMBER
2176: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

Line 2174: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_course_cd));

2170: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
2171: -- P_ADMISSION_APPL_NUMBER
2172: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2173: -- p_nominated_course_cd
2174: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_course_cd));
2175: -- P_SEQUENCE_NUMBER
2176: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2177: -- P_qualifying_type_code
2178: check_length('QUALIFYING_TYPE_CODE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_type_code));

Line 2176: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

2172: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2173: -- p_nominated_course_cd
2174: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_course_cd));
2175: -- P_SEQUENCE_NUMBER
2176: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2177: -- P_qualifying_type_code
2178: check_length('QUALIFYING_TYPE_CODE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_type_code));
2179: -- P_QUALIFYING_CODE
2180: check_length('NAME', 'IGS_AD_CODE_CLASSES', length(p_qualifying_code));

Line 2473: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));

2469:
2470:
2471: -- Validate all the parameters for their length
2472: -- person_id
2473: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
2474:
2475: -- p_admission_appl_number
2476: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2477:

Line 2476: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));

2472: -- person_id
2473: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
2474:
2475: -- p_admission_appl_number
2476: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2477:
2478: -- p_nominated_course_cd
2479: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
2480:

Line 2479: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));

2475: -- p_admission_appl_number
2476: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_admission_appl_number)));
2477:
2478: -- p_nominated_course_cd
2479: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
2480:
2481: -- p_sequence_number
2482: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2483:

Line 2482: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));

2478: -- p_nominated_course_cd
2479: check_length('NOMINATED_COURSE_CD', 'IGS_AD_PS_APPL_INST_ALL', length(p_nominated_program_cd));
2480:
2481: -- p_sequence_number
2482: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2483:
2484: -- p_entry_qual_status
2485: check_length('ADM_ENTRY_QUAL_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_entry_qual_status));
2486:

Line 2485: check_length('ADM_ENTRY_QUAL_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_entry_qual_status));

2481: -- p_sequence_number
2482: check_length('SEQUENCE_NUMBER', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_sequence_number)));
2483:
2484: -- p_entry_qual_status
2485: check_length('ADM_ENTRY_QUAL_STATUS', 'IGS_AD_PS_APPL_INST_ALL', length(p_entry_qual_status));
2486:
2487: -- end of parameter validations.
2488:
2489: -- Show appropriate message when the parameter values are missing