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

Line 3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3067: END IF;
3068: RETURN lOverallStatus;
3069: END Admp_Get_Fee_Status;
3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.

Line 3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3068: RETURN lOverallStatus;
3069: END Admp_Get_Fee_Status;
3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
3076: ) IS

Line 3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,

3069: END Admp_Get_Fee_Status;
3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
3076: ) IS
3077: /*******************************************************************************

Line 3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,

3070: PROCEDURE check_adm_appl_inst_stat(
3071: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3072: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3073: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
3074: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
3075: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
3076: ) IS
3077: /*******************************************************************************
3078: Created by : Kedarnath Nag

Line 3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3325: App_Exception.Raise_Exception;
3326: END res_pending_fee_status;
3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,

Line 3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3326: END res_pending_fee_status;
3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,
3334: x_return_status OUT NOCOPY VARCHAR2,

Line 3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3327:
3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,
3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_count OUT NOCOPY NUMBER,

Line 3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

3328: PROCEDURE Admp_resub_inst(
3329: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3330: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3331: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3332: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3333: p_do_commit VARCHAR2 DEFAULT NULL,
3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_count OUT NOCOPY NUMBER,
3336: x_msg_data OUT NOCOPY VARCHAR2

Line 3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3636: -- END arvsrini - ADTD001 RE-OPEN BUILD- IGS.M
3637:
3638: -- begin APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,

Line 3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3637:
3638: -- begin APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,
3645: p_message_name out nocopy varchar2

Line 3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3638: -- begin APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,
3645: p_message_name out nocopy varchar2
3646: ) IS

Line 3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

3639: ---------------------------***************Is_inst_recon_allowed (PROCEDURE)**************-------------------------
3640: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3641: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3642: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3643: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3644: p_success out nocopy varchar2,
3645: p_message_name out nocopy varchar2
3646: ) IS
3647: cst_accepted CONSTANT VARCHAR2(10) := 'ACCEPTED';

Line 3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3767: p_success := 'N';
3768: RETURN;
3769: END Is_inst_recon_allowed;
3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )

Line 3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3768: RETURN;
3769: END Is_inst_recon_allowed;
3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )
3776: RETURN VARCHAR2 IS

Line 3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3769: END Is_inst_recon_allowed;
3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )
3776: RETURN VARCHAR2 IS
3777: p_message_name VARCHAR2(40) DEFAULT NULL;

Line 3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE

3770: ---------------------------***************Is_inst_recon_allowed (overloaded function)**************-------------------------
3771: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3772: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3773: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3774: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
3775: )
3776: RETURN VARCHAR2 IS
3777: p_message_name VARCHAR2(40) DEFAULT NULL;
3778: p_success VARCHAR2(1) DEFAULT NULL;

Line 3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

3783:
3784: ---------------------------**************Reconsider_Appl_Inst***************-------------------------
3785:
3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)

Line 3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

3784: ---------------------------**************Reconsider_Appl_Inst***************-------------------------
3785:
3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
3792: )

Line 3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

3785:
3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
3792: )
3793: IS

Line 3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

3786: PROCEDURE Reconsider_Appl_Inst (
3787: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
3788: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
3789: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
3790: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
3791: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
3792: )
3793: IS
3794:

Line 3818: FROM IGS_AD_PS_APPL_INST_ALL acai

3814: *******************************************************************************/
3815:
3816: CURSOR c_aca IS
3817: SELECT rowid,acai.*
3818: FROM IGS_AD_PS_APPL_INST_ALL acai
3819: WHERE acai.person_id = p_person_id AND
3820: acai.admission_appl_number = p_admission_appl_number AND
3821: acai.nominated_course_cd = p_nominated_course_cd AND
3822: acai.future_term_adm_appl_number IS NULL AND

Line 4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4095:
4096:
4097: -- following function would be invoked only from Admin Dashboard for reconsideration
4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)

Line 4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4096:
4097: -- following function would be invoked only from Admin Dashboard for reconsideration
4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )

Line 4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

4097: -- following function would be invoked only from Admin Dashboard for reconsideration
4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )
4105: IS

Line 4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

4098: PROCEDURE Recon_Appl_inst (
4099: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4100: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4101: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4102: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4103: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
4104: )
4105: IS
4106:

Line 4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4148: END Recon_Appl_inst;
4149:
4150: -----------------***************** check_adm_appl_inst_stat overloaded function to invoke in Selfservice ***------------------------------------
4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.

Line 4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4149:
4150: -----------------***************** check_adm_appl_inst_stat overloaded function to invoke in Selfservice ***------------------------------------
4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
4157: )

Line 4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,

4150: -----------------***************** check_adm_appl_inst_stat overloaded function to invoke in Selfservice ***------------------------------------
4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
4157: )
4158: RETURN VARCHAR2

Line 4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,

4151: FUNCTION check_adm_appl_inst_stat(
4152: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4153: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4154: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
4155: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
4156: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
4157: )
4158: RETURN VARCHAR2
4159: IS

Line 4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4173: WHEN OTHERS THEN
4174: RETURN 'N';
4175: END check_adm_appl_inst_stat;
4176:
4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
4180: )
4181: IS

Line 4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4174: RETURN 'N';
4175: END check_adm_appl_inst_stat;
4176:
4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
4180: )
4181: IS
4182:

Line 4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE

4175: END check_adm_appl_inst_stat;
4176:
4177: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4178: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4179: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
4180: )
4181: IS
4182:
4183: CURSOR c_inst IS

Line 4185: FROM igs_ad_ps_appl_inst_all acai

4181: IS
4182:
4183: CURSOR c_inst IS
4184: SELECT rowid,acai.*
4185: FROM igs_ad_ps_appl_inst_all acai
4186: WHERE acai.person_id = p_person_id AND
4187: acai.admission_appl_number = p_admission_appl_number AND
4188: acai.nominated_course_cd = p_nominated_course_cd AND
4189: acai.future_term_adm_appl_number IS NULL AND

Line 4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4195: FOR UPDATE NOWAIT;
4196:
4197: c_inst_rec c_inst%ROWTYPE;
4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )

Line 4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4196:
4197: c_inst_rec c_inst%ROWTYPE;
4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS

Line 4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

4197: c_inst_rec c_inst%ROWTYPE;
4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS
4205: SELECT last_update_date

Line 4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE

4198:
4199: CURSOR c_inst_last_who ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4200: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4201: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS
4205: SELECT last_update_date
4206: FROM igs_ad_ps_appl_inst_all acinst

Line 4206: FROM igs_ad_ps_appl_inst_all acinst

4202: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
4203: )
4204: IS
4205: SELECT last_update_date
4206: FROM igs_ad_ps_appl_inst_all acinst
4207: WHERE acinst.person_id = cp_person_id AND
4208: acinst.admission_appl_number = cp_admission_appl_number AND
4209: acinst.nominated_course_cd = cp_nominated_course_cd AND
4210: acinst.sequence_number = cp_sequence_number;

Line 4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

4211:
4212: c_inst_last_who_rec c_inst_last_who%ROWTYPE;
4213:
4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)

Line 4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

4212: c_inst_last_who_rec c_inst_last_who%ROWTYPE;
4213:
4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS

Line 4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

4213:
4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS
4221: SELECT 'x'

Line 4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

4214:
4215: CURSOR c_old_hist_dt ( cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
4216: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
4217: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS
4221: SELECT 'x'
4222: FROM IGS_AD_PS_APLINSTHST ahist