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_DEF_APPL_PKG dependencies on IGS_AD_PS_APPL

Line 41: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,

37: errbuf out NOCOPY varchar2,
38: retcode out NOCOPY number ,
39: p_person_id hz_parties.party_id%TYPE,
40: p_group_id igs_pe_persid_group.group_id%TYPE,
41: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
42: p_prev_acad_adm_cal VARCHAR2,
43: p_def_acad_adm_cal VARCHAR2,
44: p_offer_dt VARCHAR2,
45: p_offer_response_dt VARCHAR2

Line 73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;

69: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
72:
73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
75:
76: l_message_name VARCHAR2(1000);
77: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

Line 74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

70: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE ;
71: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE ;
72:
73: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
75:
76: l_message_name VARCHAR2(1000);
77: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
78: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

Line 78: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

74: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
75:
76: l_message_name VARCHAR2(1000);
77: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
78: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
79: cst_deferral CONSTANT VARCHAR2(9) := 'DEFERRAL';
80: cst_approved CONSTANT VARCHAR2(9) := 'APPROVED';
81:
82: l_person_number hz_parties.party_number%TYPE;

Line 132: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */

128: SELECT
129: acai.*
130: FROM
131: igs_ad_appl aa,
132: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
133: igs_ad_ofr_resp_stat aous,
134: igs_ad_ofrdfrmt_stat aods
135: WHERE
136: aa.person_id = acai.person_id

Line 340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

336:
337: PROCEDURE cmn_handle_application
338: (
339: p_person_id hz_parties.party_id%TYPE,
340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

337: PROCEDURE cmn_handle_application
338: (
339: p_person_id hz_parties.party_id%TYPE,
340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

Line 342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,

338: (
339: p_person_id hz_parties.party_id%TYPE,
340: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
341: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
342: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

343: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
349: ) IS
350:
351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,

Line 348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE

344: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
345: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
346: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
349: ) IS
350:
351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

Line 351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,

347: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
349: ) IS
350:
351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
355: SELECT aods.s_adm_offer_dfrmnt_status

Line 352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,

348: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
349: ) IS
350:
351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
355: SELECT aods.s_adm_offer_dfrmnt_status
356: FROM igs_ad_ps_appl_inst apai,

Line 353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

349: ) IS
350:
351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
355: SELECT aods.s_adm_offer_dfrmnt_status
356: FROM igs_ad_ps_appl_inst apai,
357: igs_ad_ofrdfrmt_stat_v aods

Line 354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS

350:
351: CURSOR cur_sys_offr_dfrmnt_status(p_person_id igs_ad_ps_appl_inst.person_id%TYPE,
352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
355: SELECT aods.s_adm_offer_dfrmnt_status
356: FROM igs_ad_ps_appl_inst apai,
357: igs_ad_ofrdfrmt_stat_v aods
358: WHERE apai.person_id =p_person_id

Line 356: FROM igs_ad_ps_appl_inst apai,

352: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
353: p_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
354: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
355: SELECT aods.s_adm_offer_dfrmnt_status
356: FROM igs_ad_ps_appl_inst apai,
357: igs_ad_ofrdfrmt_stat_v aods
358: WHERE apai.person_id =p_person_id
359: AND apai.admission_appl_number =p_admission_appl_number
360: AND apai.nominated_course_cd =p_nominated_course_cd

Line 366: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

362: AND apai.adm_offer_dfrmnt_status = aods.adm_offer_dfrmnt_status ;
363:
364: l_message_name VARCHAR2(1000);
365: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
366: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
367: l_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat_v.s_adm_offer_dfrmnt_status%TYPE;
368:
369: v_start_dt DATE;
370:

Line 503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,

499:
500: FUNCTION handle_application(
501: p_person_id hz_parties.party_id%TYPE,
502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

Line 504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

500: FUNCTION handle_application(
501: p_person_id hz_parties.party_id%TYPE,
502: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
503: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
504: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
505: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 510: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE

506: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
507: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
508: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
509: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
510: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
511: ) RETURN BOOLEAN IS
512: /*******************************************************************************
513: Created by : Ramesh Rengarajan
514: Date created: 20 FEB 2002

Line 545: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */

541: aca.req_for_adv_standing_ind,
542: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
543: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
544: FROM
545: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
546: igs_ad_appl aa,
547: igs_ad_ps_appl aca
548: WHERE
549: acai.admission_appl_number = p_admission_appl_number

Line 547: igs_ad_ps_appl aca

543: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
544: FROM
545: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
546: igs_ad_appl aa,
547: igs_ad_ps_appl aca
548: WHERE
549: acai.admission_appl_number = p_admission_appl_number
550: AND acai.sequence_number = p_sequence_number
551: AND acai.nominated_course_cd = p_nominated_course_cd

Line 576: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;

572:
573: -------------------Variable Declarations------------------------------------------------------
574: l_message_name VARCHAR2(1000);
575: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
576: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
577: l_return_type VARCHAR2(100);
578: l_error_code VARCHAR2(100);
579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
580: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

Line 753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

749: RETURN FALSE;
750: END handle_application;
751:
752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

Line 754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

750: END handle_application;
751:
752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

Line 755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

751:
752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,

Line 756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

752: FUNCTION validate_offer_validations(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

Line 757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

753: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

754: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

Line 759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,

755: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
756: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
757: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
758: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
759: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
760: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
761: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
762: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
763: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 786: igs_ad_ps_appl_inst apai

782: CURSOR c_appl_inst_old_cur IS
783: SELECT
784: apai.*
785: FROM
786: igs_ad_ps_appl_inst apai
787: WHERE
788: apai.person_id = p_person_id
789: AND apai.admission_appl_number = p_old_admission_appl_number
790: AND apai.nominated_course_cd = p_nominated_course_cd

Line 808: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */

804: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
805: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
806:
807: FROM
808: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
809: igs_ad_appl aa
810: WHERE
811: acai.person_id = p_person_id
812: AND acai.nominated_course_cd = p_nominated_course_cd

Line 847: igs_ad_ps_appl_inst apai

843: CURSOR c_upd_acai_cur IS
844: SELECT
845: ROWID, APAI.*
846: FROM
847: igs_ad_ps_appl_inst apai
848: WHERE
849: apai.person_id = p_person_id
850: AND apai.admission_appl_number = p_admission_appl_number
851: AND apai.nominated_course_cd = p_nominated_course_cd

Line 857: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

853: -- End Cursor Declarations ----------------------------------------------------------------------------
854:
855: -- Variable Declarations -------------------------------------------------------------------------------
856:
857: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
858: v_pref_allowed_ind VARCHAR2 (1);
859: v_pref_limit NUMBER;
860: v_cond_offer_doc_allowed_ind VARCHAR2 (1);
861: v_cond_offer_fee_allowed_ind VARCHAR2 (1);

Line 1056: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

1052:
1053: FOR c_upd_acai_rec IN c_upd_acai_cur LOOP
1054:
1055: -- Offer validations is successful then update the offer
1056: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
1057: x_rowid => c_upd_acai_rec.row_id ,
1058: x_person_id => c_upd_acai_rec.person_id ,
1059: x_admission_appl_number => c_upd_acai_rec.admission_appl_number ,
1060: x_nominated_course_cd => c_upd_acai_rec.nominated_course_cd ,

Line 1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1229: RETURN FALSE;
1230: END validate_offer_validations;
1231:
1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1237: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS

Line 1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1230: END validate_offer_validations;
1231:
1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1237: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
1238: /*******************************************************************************

Line 1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

1231:
1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1237: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
1238: /*******************************************************************************
1239: Created by : Ramesh Rengarajan

Line 1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1232: FUNCTION copy_entrycomp_qual_status(p_person_id HZ_PARTIES.PARTY_ID%TYPE,
1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1237: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
1238: /*******************************************************************************
1239: Created by : Ramesh Rengarajan
1240: Date created: 06 SEP 2002

Line 1237: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS

1233: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1234: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1235: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1236: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1237: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN IS
1238: /*******************************************************************************
1239: Created by : Ramesh Rengarajan
1240: Date created: 06 SEP 2002
1241:

Line 1254: igs_ad_ps_appl_inst apai

1250: CURSOR c_upd_acai_new_cur IS
1251: SELECT
1252: apai.*
1253: FROM
1254: igs_ad_ps_appl_inst apai
1255: WHERE
1256: apai.person_id = p_person_id
1257: AND apai.admission_appl_number = p_new_admission_appl_number
1258: AND apai.nominated_course_cd = p_nominated_course_cd

Line 1266: igs_ad_ps_appl_inst apai

1262: CURSOR c_upd_acai_old_cur IS
1263: SELECT
1264: apai.*
1265: FROM
1266: igs_ad_ps_appl_inst apai
1267: WHERE
1268: apai.person_id = p_person_id
1269: AND apai.admission_appl_number = p_admission_appl_number
1270: AND apai.nominated_course_cd = p_nominated_course_cd

Line 1280: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

1276:
1277: -- This procedure updates only entry qualification status from old to new future term application
1278: FOR c_upd_acai_old_rec IN c_upd_acai_old_cur LOOP
1279: FOR c_upd_acai_new_rec IN c_upd_acai_new_cur LOOP
1280: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
1281: x_rowid => c_upd_acai_new_rec.row_id ,
1282: x_person_id => c_upd_acai_new_rec.person_id ,
1283: x_admission_appl_number => c_upd_acai_new_rec.admission_appl_number ,
1284: x_nominated_course_cd => c_upd_acai_new_rec.nominated_course_cd ,

Line 1397: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (

1393: x_decline_ofr_reason => c_upd_acai_old_rec.decline_ofr_reason
1394: );
1395:
1396: -- Also update the future application number in the old application number for link
1397: Igs_Ad_Ps_Appl_Inst_Pkg.UPDATE_ROW (
1398: x_rowid => c_upd_acai_old_rec.row_id ,
1399: x_person_id => c_upd_acai_old_rec.person_id ,
1400: x_admission_appl_number => c_upd_acai_old_rec.admission_appl_number ,
1401: x_nominated_course_cd => c_upd_acai_old_rec.nominated_course_cd ,

Line 1526: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

1522: END copy_entrycomp_qual_status;
1523:
1524:
1525: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
1526: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1527: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1528: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN IS
1529: /*******************************************************************************
1530: Created by : hreddych

Line 1527: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

1523:
1524:
1525: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
1526: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1527: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1528: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN IS
1529: /*******************************************************************************
1530: Created by : hreddych
1531: Date created: 16 OCT 2002

Line 1528: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN IS

1524:
1525: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
1526: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1527: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1528: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN IS
1529: /*******************************************************************************
1530: Created by : hreddych
1531: Date created: 16 OCT 2002
1532:

Line 1545: CURSOR cur_appl_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,

1541: Retruned false if pre-enrollment process fails
1542: *******************************************************************************/
1543:
1544: -- Cursor Declarations-------------------------------------------------------------------
1545: CURSOR cur_appl_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1546: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1547: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1548: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1549: SELECT apai.*, apai.rowid

Line 1546: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,

1542: *******************************************************************************/
1543:
1544: -- Cursor Declarations-------------------------------------------------------------------
1545: CURSOR cur_appl_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1546: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1547: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1548: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1549: SELECT apai.*, apai.rowid
1550: FROM igs_ad_ps_appl_inst apai /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */

Line 1547: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,

1543:
1544: -- Cursor Declarations-------------------------------------------------------------------
1545: CURSOR cur_appl_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1546: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1547: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1548: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1549: SELECT apai.*, apai.rowid
1550: FROM igs_ad_ps_appl_inst apai /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
1551: WHERE apai.person_id = p_person_id

Line 1548: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS

1544: -- Cursor Declarations-------------------------------------------------------------------
1545: CURSOR cur_appl_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1546: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1547: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1548: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1549: SELECT apai.*, apai.rowid
1550: FROM igs_ad_ps_appl_inst apai /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
1551: WHERE apai.person_id = p_person_id
1552: AND apai.admission_appl_number = p_admission_appl_number

Line 1550: FROM igs_ad_ps_appl_inst apai /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */

1546: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1547: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1548: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1549: SELECT apai.*, apai.rowid
1550: FROM igs_ad_ps_appl_inst apai /* Replaced igs_ad_ps_appl_inst_aplinst_v with base tables Bug 3150054 */
1551: WHERE apai.person_id = p_person_id
1552: AND apai.admission_appl_number = p_admission_appl_number
1553: AND apai.nominated_course_cd = p_nominated_course_cd
1554: AND apai.sequence_number = p_sequence_number;

Line 1556: CURSOR cur_application_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,

1552: AND apai.admission_appl_number = p_admission_appl_number
1553: AND apai.nominated_course_cd = p_nominated_course_cd
1554: AND apai.sequence_number = p_sequence_number;
1555:
1556: CURSOR cur_application_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1557: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1558: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1559: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1560: SELECT apai.*

Line 1557: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,

1553: AND apai.nominated_course_cd = p_nominated_course_cd
1554: AND apai.sequence_number = p_sequence_number;
1555:
1556: CURSOR cur_application_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1557: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1558: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1559: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1560: SELECT apai.*
1561: FROM igs_ad_ps_appl_inst apai

Line 1558: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,

1554: AND apai.sequence_number = p_sequence_number;
1555:
1556: CURSOR cur_application_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1557: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1558: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1559: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1560: SELECT apai.*
1561: FROM igs_ad_ps_appl_inst apai
1562: WHERE apai.person_id = p_person_id

Line 1559: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS

1555:
1556: CURSOR cur_application_details (p_person_id Igs_Ad_Ps_Appl_Inst.person_id%TYPE,
1557: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1558: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1559: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1560: SELECT apai.*
1561: FROM igs_ad_ps_appl_inst apai
1562: WHERE apai.person_id = p_person_id
1563: AND apai.admission_appl_number = p_admission_appl_number

Line 1561: FROM igs_ad_ps_appl_inst apai

1557: p_admission_appl_number Igs_Ad_Ps_Appl_Inst.admission_appl_number%TYPE,
1558: p_nominated_course_cd Igs_Ad_Ps_Appl_Inst.nominated_course_cd%TYPE,
1559: p_sequence_number Igs_Ad_Ps_Appl_Inst.sequence_number%TYPE ) IS
1560: SELECT apai.*
1561: FROM igs_ad_ps_appl_inst apai
1562: WHERE apai.person_id = p_person_id
1563: AND apai.admission_appl_number = p_admission_appl_number
1564: AND apai.nominated_course_cd = p_nominated_course_cd
1565: AND apai.sequence_number = p_sequence_number;

Line 1576: l_adm_offer_resp_status Igs_Ad_Ps_Appl_Inst.adm_offer_resp_status%TYPE;

1572:
1573: -----End cursor Declarations------------------------------------------------------------------
1574:
1575: -------------------Variable Declarations------------------------------------------------------
1576: l_adm_offer_resp_status Igs_Ad_Ps_Appl_Inst.adm_offer_resp_status%TYPE;
1577: cur_appl_details_rec cur_appl_details%ROWTYPE;
1578: cur_application_details_rec cur_application_details%ROWTYPE;
1579: v_message_name VARCHAR2(100);
1580: v_warn_level VARCHAR2(10);

Line 1596: igs_ad_ps_appl_inst_pkg.update_row (

1592: FETCH cur_appl_details INTO cur_appl_details_rec;
1593: CLOSE cur_appl_details;
1594:
1595:
1596: igs_ad_ps_appl_inst_pkg.update_row (
1597: X_ROWID => cur_appl_details_rec.ROWID ,
1598: x_PERSON_ID => cur_appl_details_rec.PERSON_ID ,
1599: x_ADMISSION_APPL_NUMBER => cur_appl_details_rec.ADMISSION_APPL_NUMBER ,
1600: x_NOMINATED_COURSE_CD => cur_appl_details_rec.NOMINATED_COURSE_CD ,