[Home] [Help]
438: AND admprd.admission_cat = appl.admission_cat
439: AND admprd.s_admission_process_type = appl.s_admission_process_type
440: AND admprd.single_response_flag = 'Y';
441:
442: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
443: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
444: SELECT alternate_code
445: FROM igs_ca_inst
446: WHERE cal_type = p_cal_type
439: AND admprd.s_admission_process_type = appl.s_admission_process_type
440: AND admprd.single_response_flag = 'Y';
441:
442: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
443: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
444: SELECT alternate_code
445: FROM igs_ca_inst
446: WHERE cal_type = p_cal_type
447: AND sequence_number = p_sequence_number;
441:
442: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
443: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
444: SELECT alternate_code
445: FROM igs_ca_inst
446: WHERE cal_type = p_cal_type
447: AND sequence_number = p_sequence_number;
448:
449:
449:
450: l_appl_dt igs_ad_appl.appl_dt%TYPE;
451: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
452: l_application_id igs_ad_appl_all.application_id%TYPE;
453: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
454: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
455: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
456:
457: l_s_adm_outcome_status VARCHAR2(30) ;
450: l_appl_dt igs_ad_appl.appl_dt%TYPE;
451: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
452: l_application_id igs_ad_appl_all.application_id%TYPE;
453: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
454: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
455: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
456:
457: l_s_adm_outcome_status VARCHAR2(30) ;
458: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
2789: Know limitations, enhancements or remarks
2790: Change History
2791: Who When What
2792: smadathi 13-Feb-2002 Bug 2217104. Added foreign key references
2793: to IGS_CA_INST_ALL table
2794: (reverse chronological order - newest change first)
2795: ***************************************************************/
2796: BEGIN
2797: IF (((old_references.edu_goal_prior_enroll_id = new_references.edu_goal_prior_enroll_id)) OR
2937: ((new_references.deferred_adm_cal_type IS NULL) OR
2938: (new_references.deferred_adm_ci_sequence_num IS NULL))) THEN
2939: NULL;
2940: ELSE
2941: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
2942: new_references.deferred_adm_cal_type,
2943: new_references.deferred_adm_ci_sequence_num
2944: )THEN
2945: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
2953: ((new_references.adm_cal_type IS NULL) OR
2954: (new_references.adm_ci_sequence_number IS NULL))) THEN
2955: NULL;
2956: ELSE
2957: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
2958: new_references.adm_cal_type,
2959: new_references.adm_ci_sequence_number
2960: )THEN
2961: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3196: ((new_references.future_acad_cal_type IS NULL) OR
3197: (new_references.future_acad_ci_sequence_number IS NULL))) THEN
3198: NULL;
3199: ELSE
3200: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
3201: new_references.future_acad_cal_type,
3202: new_references.future_acad_ci_sequence_number
3203: )THEN
3204: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3213: ((new_references.future_adm_cal_type IS NULL) OR
3214: (new_references.future_adm_ci_sequence_number IS NULL))) THEN
3215: NULL;
3216: ELSE
3217: IF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
3218: new_references.future_adm_cal_type,
3219: new_references.future_adm_ci_sequence_number
3220: )THEN
3221: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3805: END IF;
3806: Close cur_rowid;
3807: END GET_FK_IGS_CO_CAT;
3808:
3809: PROCEDURE GET_FK_IGS_CA_INST (
3810: x_cal_type IN VARCHAR2,
3811: x_sequence_number IN NUMBER
3812: ) IS
3813: ------------------------------------------------------------------
3840: App_Exception.Raise_Exception;
3841: Return;
3842: END IF;
3843: Close cur_rowid;
3844: END GET_FK_IGS_CA_INST;
3845:
3846: PROCEDURE GET_FK_IGS_PS_COURSE (
3847: x_course_cd IN VARCHAR2
3848: ) IS
4717:
4718: CURSOR c_get_teach_period (p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
4719: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE) IS
4720: SELECT cr.sub_cal_type, cr.sub_ci_sequence_number
4721: FROM igs_ca_inst_rel cr, igs_ca_type ct
4722: WHERE ct.s_cal_cat ='TEACHING'
4723: AND cr.sub_cal_type = ct.cal_type
4724: AND cr.sup_cal_type = p_acad_cal_type
4725: AND cr.sup_ci_sequence_number = p_acad_ci_sequence_number;
4725: AND cr.sup_ci_sequence_number = p_acad_ci_sequence_number;
4726:
4727: cv_get_teach_period c_get_teach_period%ROWTYPE;
4728:
4729: CURSOR c_get_load_start_date (p_sub_cal_type igs_ca_inst.cal_type%TYPE,
4730: p_sub_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4731: SELECT TRUNC(load_start_dt) load_start_dt, load_cal_type, load_ci_sequence_number
4732: FROM igs_ca_teach_to_load_v ctl
4733: WHERE ctl.teach_cal_type = p_sub_cal_type
4726:
4727: cv_get_teach_period c_get_teach_period%ROWTYPE;
4728:
4729: CURSOR c_get_load_start_date (p_sub_cal_type igs_ca_inst.cal_type%TYPE,
4730: p_sub_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4731: SELECT TRUNC(load_start_dt) load_start_dt, load_cal_type, load_ci_sequence_number
4732: FROM igs_ca_teach_to_load_v ctl
4733: WHERE ctl.teach_cal_type = p_sub_cal_type
4734: AND ctl.teach_ci_sequence_number = p_sub_ci_sequence_number;