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_PS_APPL_INST_PKG dependencies on IGS_AD_APPL

Line 336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

332: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
333: v_p_inserting_ind VARCHAR2(1) ;
334: v_offer_ind VARCHAR2(1) ;
335: v_crv_version_number IGS_PS_VER.version_number%TYPE;
336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

333: v_p_inserting_ind VARCHAR2(1) ;
334: v_offer_ind VARCHAR2(1) ;
335: v_crv_version_number IGS_PS_VER.version_number%TYPE;
336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

334: v_offer_ind VARCHAR2(1) ;
335: v_crv_version_number IGS_PS_VER.version_number%TYPE;
336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

Line 339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

335: v_crv_version_number IGS_PS_VER.version_number%TYPE;
336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

Line 342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

Line 343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

Line 344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

340: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;

Line 345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

341: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
349: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

Line 346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

342: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
349: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
350: v_pref_allowed_ind VARCHAR2(1) ;

Line 347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

343: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
344: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
349: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
350: v_pref_allowed_ind VARCHAR2(1) ;
351: v_pref_limit NUMBER;

Line 405: CURSOR c_appl_dt (p_person_id igs_ad_appl.person_id%TYPE,

401: AND pti.sequence_number = cp_sequence_number
402: AND ppt.person_type_code = pti.person_type_code
403: AND ppt.system_type = 'APPLICANT';
404:
405: CURSOR c_appl_dt (p_person_id igs_ad_appl.person_id%TYPE,
406: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
407: SELECT appl_dt FROM igs_ad_appl
408: WHERE person_id = p_person_id
409: AND admission_appl_number = p_admission_appl_number;

Line 406: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS

402: AND ppt.person_type_code = pti.person_type_code
403: AND ppt.system_type = 'APPLICANT';
404:
405: CURSOR c_appl_dt (p_person_id igs_ad_appl.person_id%TYPE,
406: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
407: SELECT appl_dt FROM igs_ad_appl
408: WHERE person_id = p_person_id
409: AND admission_appl_number = p_admission_appl_number;
410:

Line 407: SELECT appl_dt FROM igs_ad_appl

403: AND ppt.system_type = 'APPLICANT';
404:
405: CURSOR c_appl_dt (p_person_id igs_ad_appl.person_id%TYPE,
406: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
407: SELECT appl_dt FROM igs_ad_appl
408: WHERE person_id = p_person_id
409: AND admission_appl_number = p_admission_appl_number;
410:
411: -- Following cursors added as part of Single Response build Bug:3132406

Line 412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,

408: WHERE person_id = p_person_id
409: AND admission_appl_number = p_admission_appl_number;
410:
411: -- Following cursors added as part of Single Response build Bug:3132406
412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,

Line 413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS

409: AND admission_appl_number = p_admission_appl_number;
410:
411: -- Following cursors added as part of Single Response build Bug:3132406
412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,
417: igs_ad_ps_appl_inst_all aplinst

Line 416: igs_ad_appl_all appl,

412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,
417: igs_ad_ps_appl_inst_all aplinst
418: WHERE appl.person_id = new_references.person_id
419: AND appl.admission_appl_number = new_references.admission_appl_number
420: AND appl.person_id = aplinst.person_id

Line 429: FROM igs_ad_appl_all appl,

425: AND admprd.s_admission_process_type = p_s_admission_process_type;
426:
427: CURSOR get_aplinst_response_accepted IS
428: SELECT distinct appl.application_id, aplinst.nominated_course_cd
429: FROM igs_ad_appl_all appl,
430: igs_ad_ps_appl_inst aplinst,
431: igs_ad_prd_ad_prc_ca admprd
432: WHERE appl.person_id = aplinst.person_id
433: AND appl.admission_appl_number = aplinst.admission_appl_number

Line 450: l_appl_dt igs_ad_appl.appl_dt%TYPE;

446: WHERE cal_type = p_cal_type
447: AND sequence_number = p_sequence_number;
448:
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;

Line 452: l_application_id igs_ad_appl_all.application_id%TYPE;

448:
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:

Line 509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');

505: CLOSE c_appl_dt;
506:
507: IF (new_references.adm_outcome_status_auth_dt IS NOT NULL
508: AND new_references.adm_outcome_status_auth_dt < l_appl_dt ) THEN
509: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');
510: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_OS_AUTH_DT'));
511: IGS_GE_MSG_STACK.ADD;
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;

Line 526: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');

522: APP_EXCEPTION.RAISE_EXCEPTION;
523: END IF;
524:
525: IF (new_references.idx_calc_date IS NOT NULL AND new_references.idx_calc_date < l_appl_dt ) THEN
526: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_DATE_ERROR');
527: FND_MESSAGE.SET_TOKEN ('NAME',fnd_message.get_string('IGS','IGS_AD_CALC_DATE'));
528: IGS_GE_MSG_STACK.ADD;
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: ELSIF new_references.idx_calc_date > SYSDATE THEN

Line 738: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_WITHD');

734: AND old_references.def_appl_sequence_num IS NULL
735: )
736: OR check_non_updateable_list() THEN -- tried to update the fields which are not supposed to be updated in proced phase
737: IF IGS_AD_GEN_007.ADMP_GET_SAAS(old_references.appl_inst_status) = cst_withdrawn THEN
738: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_WITHD');
739: IGS_GE_MSG_STACK.ADD;
740: APP_EXCEPTION.RAISE_EXCEPTION;
741: ELSE
742: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_COMPL');

Line 742: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_COMPL');

738: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_WITHD');
739: IGS_GE_MSG_STACK.ADD;
740: APP_EXCEPTION.RAISE_EXCEPTION;
741: ELSE
742: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPL_INST_COMPL');
743: IGS_GE_MSG_STACK.ADD;
744: APP_EXCEPTION.RAISE_EXCEPTION;
745: END IF;
746: END IF;

Line 1968: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

1964: v_message_name VARCHAR2(30);
1965: v_cond_offer_doc_allowed_ind VARCHAR2(1) ;
1966: v_cond_offer_fee_allowed_ind VARCHAR2(1) ;
1967: v_cond_offer_ass_allowed_ind VARCHAR2(1) ;
1968: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

1965: v_cond_offer_doc_allowed_ind VARCHAR2(1) ;
1966: v_cond_offer_fee_allowed_ind VARCHAR2(1) ;
1967: v_cond_offer_ass_allowed_ind VARCHAR2(1) ;
1968: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

Line 1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

1966: v_cond_offer_fee_allowed_ind VARCHAR2(1) ;
1967: v_cond_offer_ass_allowed_ind VARCHAR2(1) ;
1968: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

Line 1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

1967: v_cond_offer_ass_allowed_ind VARCHAR2(1) ;
1968: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

1968: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

1969: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1977: v_pref_allowed_ind VARCHAR2(1) ;

Line 1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

1970: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1977: v_pref_allowed_ind VARCHAR2(1) ;
1978: v_pref_limit NUMBER;

Line 1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

1971: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1977: v_pref_allowed_ind VARCHAR2(1) ;
1978: v_pref_limit NUMBER;
1979: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

Line 1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

1972: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1973: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
1974: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1977: v_pref_allowed_ind VARCHAR2(1) ;
1978: v_pref_limit NUMBER;
1979: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
1980: v_set_outcome_allowed_ind VARCHAR2(1) ;

Line 1979: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

1975: v_aa_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
1976: v_aa_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
1977: v_pref_allowed_ind VARCHAR2(1) ;
1978: v_pref_limit NUMBER;
1979: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
1980: v_set_outcome_allowed_ind VARCHAR2(1) ;
1981: v_late_appl_allowed_ind VARCHAR2(1) ;
1982: v_fees_required_ind VARCHAR2(1) ;
1983: v_deferral_allowed_ind VARCHAR2(1) ;

Line 1989: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

1985: v_mult_offer_allowed_ind VARCHAR2(1) ;
1986: v_multi_offer_limit NUMBER;
1987: v_unit_set_appl_ind VARCHAR2(1) ;
1988: v_check_person_encumb VARCHAR2(1) ;
1989: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
1990: v_check_course_encumb VARCHAR2(1) ;
1991: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
1992: v_return_type VARCHAR2(1);
1993: cst_error CONSTANT VARCHAR2(1):= 'E';

Line 1991: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

1987: v_unit_set_appl_ind VARCHAR2(1) ;
1988: v_check_person_encumb VARCHAR2(1) ;
1989: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
1990: v_check_course_encumb VARCHAR2(1) ;
1991: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
1992: v_return_type VARCHAR2(1);
1993: cst_error CONSTANT VARCHAR2(1):= 'E';
1994: v_person_id IGS_AD_APPL.person_id%TYPE;
1995: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

Line 1994: v_person_id IGS_AD_APPL.person_id%TYPE;

1990: v_check_course_encumb VARCHAR2(1) ;
1991: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
1992: v_return_type VARCHAR2(1);
1993: cst_error CONSTANT VARCHAR2(1):= 'E';
1994: v_person_id IGS_AD_APPL.person_id%TYPE;
1995: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
1996: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
1997:
1998: -- added this cursor here to get the old outcome status from the database

Line 1995: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

1991: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
1992: v_return_type VARCHAR2(1);
1993: cst_error CONSTANT VARCHAR2(1):= 'E';
1994: v_person_id IGS_AD_APPL.person_id%TYPE;
1995: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
1996: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
1997:
1998: -- added this cursor here to get the old outcome status from the database
1999: -- by rrengara on 10-apr-2002 for bug no 2298840

Line 1996: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

1992: v_return_type VARCHAR2(1);
1993: cst_error CONSTANT VARCHAR2(1):= 'E';
1994: v_person_id IGS_AD_APPL.person_id%TYPE;
1995: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
1996: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
1997:
1998: -- added this cursor here to get the old outcome status from the database
1999: -- by rrengara on 10-apr-2002 for bug no 2298840
2000: CURSOR c_adm_appl_status (cp_person_id igs_ad_appl.person_id%TYPE,

Line 2000: CURSOR c_adm_appl_status (cp_person_id igs_ad_appl.person_id%TYPE,

1996: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
1997:
1998: -- added this cursor here to get the old outcome status from the database
1999: -- by rrengara on 10-apr-2002 for bug no 2298840
2000: CURSOR c_adm_appl_status (cp_person_id igs_ad_appl.person_id%TYPE,
2001: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
2002: SELECT adm_appl_status
2003: FROM igs_ad_appl
2004: WHERE person_id = cp_person_id

Line 2001: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS

1997:
1998: -- added this cursor here to get the old outcome status from the database
1999: -- by rrengara on 10-apr-2002 for bug no 2298840
2000: CURSOR c_adm_appl_status (cp_person_id igs_ad_appl.person_id%TYPE,
2001: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
2002: SELECT adm_appl_status
2003: FROM igs_ad_appl
2004: WHERE person_id = cp_person_id
2005: AND admission_appl_number= cp_admission_appl_number;

Line 2003: FROM igs_ad_appl

1999: -- by rrengara on 10-apr-2002 for bug no 2298840
2000: CURSOR c_adm_appl_status (cp_person_id igs_ad_appl.person_id%TYPE,
2001: cp_admission_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
2002: SELECT adm_appl_status
2003: FROM igs_ad_appl
2004: WHERE person_id = cp_person_id
2005: AND admission_appl_number= cp_admission_appl_number;
2006:
2007: BEGIN

Line 2263: v_person_id IGS_AD_APPL.person_id%TYPE;

2259: p_updating IN BOOLEAN,
2260: p_deleting IN BOOLEAN
2261: ) IS
2262: v_message_name VARCHAR2(30);
2263: v_person_id IGS_AD_APPL.person_id%TYPE;
2264: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2267: CURSOR c_aa (

Line 2264: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

2260: p_deleting IN BOOLEAN
2261: ) IS
2262: v_message_name VARCHAR2(30);
2263: v_person_id IGS_AD_APPL.person_id%TYPE;
2264: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2267: CURSOR c_aa (
2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,

Line 2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

2261: ) IS
2262: v_message_name VARCHAR2(30);
2263: v_person_id IGS_AD_APPL.person_id%TYPE;
2264: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2267: CURSOR c_aa (
2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
2269: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE) IS

Line 2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

2262: v_message_name VARCHAR2(30);
2263: v_person_id IGS_AD_APPL.person_id%TYPE;
2264: v_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
2265: v_derived_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2266: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
2267: CURSOR c_aa (
2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
2269: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE) IS
2270: SELECT adm_appl_status

Line 2271: FROM IGS_AD_APPL

2267: CURSOR c_aa (
2268: cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
2269: cp_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE) IS
2270: SELECT adm_appl_status
2271: FROM IGS_AD_APPL
2272: WHERE person_id = cp_person_id AND
2273: admission_appl_number = cp_admission_appl_number;
2274: BEGIN
2275: IF NVL(p_updating,FALSE) THEN

Line 2431: UPDATE IGS_AD_APPL

2427: v_adm_appl_status);
2428: -- Update the admission application status.
2429: IF v_derived_adm_appl_status IS NOT NULL AND
2430: v_derived_adm_appl_status <> v_adm_appl_status THEN
2431: UPDATE IGS_AD_APPL
2432: SET adm_appl_status = v_derived_adm_appl_status
2433: WHERE person_id = v_person_id AND
2434: admission_appl_number = v_admission_appl_number;
2435: igs_ad_wf_001.APP_PRCOC_STATUS_UPD_EVENT (

Line 2767: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));

2763: END IF;
2764: IF upper(column_name) = 'APPL_INST_STATUS' OR column_name IS NULL THEN --arvsrini igsm
2765: IF new_references.appl_inst_status <> UPPER(new_references.appl_inst_status) THEN
2766: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2767: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
2768: IGS_GE_MSG_STACK.ADD;
2769: APP_EXCEPTION.RAISE_EXCEPTION;
2770: END IF;
2771: END IF;

Line 3112: IF NOT IGS_AD_APPL_PKG.Get_PK_For_Validation (

3108: ((new_references.person_id IS NULL) OR
3109: (new_references.admission_appl_number IS NULL))) THEN
3110: NULL;
3111: ELSE
3112: IF NOT IGS_AD_APPL_PKG.Get_PK_For_Validation (
3113: new_references.person_id,
3114: new_references.admission_appl_number
3115: )THEN
3116: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

Line 3117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));

3113: new_references.person_id,
3114: new_references.admission_appl_number
3115: )THEN
3116: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
3117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
3118: IGS_GE_MSG_STACK.ADD;
3119: APP_EXCEPTION.RAISE_EXCEPTION;
3120: END IF;
3121: END IF;

Line 3278: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (

3274: IF (((old_references.appl_inst_status = new_references.appl_inst_status)) OR --arvsrini igsm
3275: ((new_references.appl_inst_status IS NULL))) THEN
3276: NULL;
3277: ELSE
3278: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (
3279: new_references.appl_inst_status ,'N'
3280: )THEN
3281: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));

Line 3282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));

3278: IF NOT IGS_AD_APPL_STAT_PKG.Get_PK_For_Validation (
3279: new_references.appl_inst_status ,'N'
3280: )THEN
3281: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
3282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL_INST_STAT'));
3283: IGS_GE_MSG_STACK.ADD;
3284: APP_EXCEPTION.RAISE_EXCEPTION;
3285: END IF;
3286: END IF;

Line 3307: now a child of Igs_ad_appl

3303: doesn't hold true with IGS_PE_CREDENTIALS table
3304: samaresh 21-dec-2001 Bug No 2158524
3305: Removed the call to get Fk to
3306: Igs_ad_app_req, as the table is
3307: now a child of Igs_ad_appl
3308: rghosh 08-nov-2002 Bug No. 2619603
3309: Added the calls to get fk to
3310: IGS_AD_APLINS_ADMREQ
3311: IGS_AD_APPL_NOTES

Line 3311: IGS_AD_APPL_NOTES

3307: now a child of Igs_ad_appl
3308: rghosh 08-nov-2002 Bug No. 2619603
3309: Added the calls to get fk to
3310: IGS_AD_APLINS_ADMREQ
3311: IGS_AD_APPL_NOTES
3312: IGS_AD_APPL_PGMAPPRV
3313: IGS_AD_TSTSCR_USED
3314: IGS_PE_TYP_INSTANCES
3315: (reverse chronological order - newest change first)

Line 3312: IGS_AD_APPL_PGMAPPRV

3308: rghosh 08-nov-2002 Bug No. 2619603
3309: Added the calls to get fk to
3310: IGS_AD_APLINS_ADMREQ
3311: IGS_AD_APPL_NOTES
3312: IGS_AD_APPL_PGMAPPRV
3313: IGS_AD_TSTSCR_USED
3314: IGS_PE_TYP_INSTANCES
3315: (reverse chronological order - newest change first)
3316: ***************************************************************/

Line 3331: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (

3327:
3328:
3329: BEGIN
3330:
3331: Igs_Ad_Appl_Eval_Pkg.Get_FK_Igs_Ad_Ps_Appl_Inst (
3332: old_references.person_id,
3333: old_references.admission_appl_number,
3334: old_references.nominated_course_cd,
3335: old_references.sequence_number

Line 3373: IGS_AD_APPL_ARP_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3369: old_references.admission_appl_number,
3370: old_references.nominated_course_cd,
3371: old_references.sequence_number
3372: );
3373: IGS_AD_APPL_ARP_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3374: old_references.person_id,
3375: old_references.admission_appl_number,
3376: old_references.nominated_course_cd,
3377: old_references.sequence_number

Line 3387: IGS_AD_APPL_NOTES_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3383: old_references.admission_appl_number,
3384: old_references.nominated_course_cd,
3385: old_references.sequence_number
3386: );
3387: IGS_AD_APPL_NOTES_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3388: old_references.person_id,
3389: old_references.admission_appl_number,
3390: old_references.nominated_course_cd,
3391: old_references.sequence_number

Line 3393: IGS_AD_APPL_PGMAPPRV_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3389: old_references.admission_appl_number,
3390: old_references.nominated_course_cd,
3391: old_references.sequence_number
3392: );
3393: IGS_AD_APPL_PGMAPPRV_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3394: old_references.person_id,
3395: old_references.admission_appl_number,
3396: old_references.nominated_course_cd,
3397: old_references.sequence_number

Line 4050: FROM IGS_AD_PS_APPL_INST_ALL ainst, IGS_AD_APPL_ALL apl

4046: x_acad_cal_type VARCHAR2
4047: ) IS
4048: CURSOR cur_rowid IS
4049: SELECT ainst.rowid
4050: FROM IGS_AD_PS_APPL_INST_ALL ainst, IGS_AD_APPL_ALL apl
4051: WHERE ainst.person_id = apl.person_id
4052: AND ainst.admission_appl_number = apl.admission_appl_number
4053: AND ainst.unit_set_cd = x_unit_set_cd
4054: AND ainst.us_version_number = x_version_number

Line 4076: PROCEDURE GET_FK_IGS_AD_APPL (

4072: -- end oxford unit set code bug 5194658
4073:
4074:
4075:
4076: PROCEDURE GET_FK_IGS_AD_APPL (
4077: x_person_id IN NUMBER,
4078: x_admission_appl_number IN NUMBER
4079: ) IS
4080: CURSOR cur_rowid IS

Line 4097: END GET_FK_IGS_AD_APPL;

4093: App_Exception.Raise_Exception;
4094: Return;
4095: END IF;
4096: Close cur_rowid;
4097: END GET_FK_IGS_AD_APPL;
4098:
4099: PROCEDURE GET_FK_IGS_AD_PS_APPL (
4100: x_person_id IN NUMBER,
4101: x_admission_appl_number IN NUMBER,

Line 4402: CURSOR c_get_appl_details (cp_person_id igs_ad_appl. person_id %TYPE,

4398:
4399:
4400: --rghosh bug# 2860860 (UCAS Conditional Offer build)
4401: -- cursor to fetch the alt_appl_id and choice number for the current Admission Application
4402: CURSOR c_get_appl_details (cp_person_id igs_ad_appl. person_id %TYPE,
4403: cp_admission_appl_number igs_ad_appl. admission_appl_number%TYPE) IS
4404: SELECT alt_appl_id, choice_number,s_admission_process_type
4405: FROM igs_ad_appl
4406: WHERE person_id = cp_person_id AND

Line 4403: cp_admission_appl_number igs_ad_appl. admission_appl_number%TYPE) IS

4399:
4400: --rghosh bug# 2860860 (UCAS Conditional Offer build)
4401: -- cursor to fetch the alt_appl_id and choice number for the current Admission Application
4402: CURSOR c_get_appl_details (cp_person_id igs_ad_appl. person_id %TYPE,
4403: cp_admission_appl_number igs_ad_appl. admission_appl_number%TYPE) IS
4404: SELECT alt_appl_id, choice_number,s_admission_process_type
4405: FROM igs_ad_appl
4406: WHERE person_id = cp_person_id AND
4407: admission_appl_number = cp_admission_appl_number;

Line 4405: FROM igs_ad_appl

4401: -- cursor to fetch the alt_appl_id and choice number for the current Admission Application
4402: CURSOR c_get_appl_details (cp_person_id igs_ad_appl. person_id %TYPE,
4403: cp_admission_appl_number igs_ad_appl. admission_appl_number%TYPE) IS
4404: SELECT alt_appl_id, choice_number,s_admission_process_type
4405: FROM igs_ad_appl
4406: WHERE person_id = cp_person_id AND
4407: admission_appl_number = cp_admission_appl_number;
4408:
4409: c_get_appl_details_rec c_get_appl_details%ROWTYPE;

Line 4712: FROM igs_ad_appl

4708: l_appl_inst_exist_rec NUMBER;
4709:
4710: CURSOR c_adm_ca_seq_acad IS
4711: SELECT acad_cal_type, acad_ci_sequence_number
4712: FROM igs_ad_appl
4713: WHERE admission_appl_number = new_references.admission_appl_number
4714: AND person_id = new_references.person_id;
4715:
4716: cv_adm_ca_seq_acad c_adm_ca_seq_acad%ROWTYPE;

Line 4718: CURSOR c_get_teach_period (p_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

4714: AND person_id = new_references.person_id;
4715:
4716: cv_adm_ca_seq_acad c_adm_ca_seq_acad%ROWTYPE;
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'

Line 4719: p_acad_ci_sequence_number igs_ad_appl.acad_ci_sequence_number%TYPE) IS

4715:
4716: cv_adm_ca_seq_acad c_adm_ca_seq_acad%ROWTYPE;
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

Line 7043: knag 21-Nov-2002 fetch and pass alt_appl_id from cursor c_igs_ad_appl for bug 2664410

7039: Who When What
7040: nsinha 26-Nov-2002 For bug 2664410 alt_appl_id :
7041: Modified the cursor c_igs_pe_ucas to check for
7042: person_id_type IN ('UCASID', 'SWASID', 'NMASID', 'GTTRID') for UCAS small systems.
7043: knag 21-Nov-2002 fetch and pass alt_appl_id from cursor c_igs_ad_appl for bug 2664410
7044: also passing NULL for P_UCAS_ID as is made obsolete by UCAS
7045: ayedubat 10-NOV-2003 Changed the ucas_user_hook procedure to add a new OUT parameter to procedure call,
7046: igs_uc_trx_gen_hook.create_ucas_transactions for UC208 Enhancement Bug, 3009203
7047: (reverse chronological order - newest change first)

Line 7049: CURSOR c_igs_ad_appl(cp_n_person_id igs_pe_person.person_id%TYPE,

7045: ayedubat 10-NOV-2003 Changed the ucas_user_hook procedure to add a new OUT parameter to procedure call,
7046: igs_uc_trx_gen_hook.create_ucas_transactions for UC208 Enhancement Bug, 3009203
7047: (reverse chronological order - newest change first)
7048: ***************************************************************/
7049: CURSOR c_igs_ad_appl(cp_n_person_id igs_pe_person.person_id%TYPE,
7050: cp_n_admission_appl_no igs_ad_appl.admission_appl_number%TYPE
7051: ) IS
7052: SELECT choice_number, alt_appl_id
7053: FROM igs_ad_appl

Line 7050: cp_n_admission_appl_no igs_ad_appl.admission_appl_number%TYPE

7046: igs_uc_trx_gen_hook.create_ucas_transactions for UC208 Enhancement Bug, 3009203
7047: (reverse chronological order - newest change first)
7048: ***************************************************************/
7049: CURSOR c_igs_ad_appl(cp_n_person_id igs_pe_person.person_id%TYPE,
7050: cp_n_admission_appl_no igs_ad_appl.admission_appl_number%TYPE
7051: ) IS
7052: SELECT choice_number, alt_appl_id
7053: FROM igs_ad_appl
7054: WHERE person_id = cp_n_person_id

Line 7053: FROM igs_ad_appl

7049: CURSOR c_igs_ad_appl(cp_n_person_id igs_pe_person.person_id%TYPE,
7050: cp_n_admission_appl_no igs_ad_appl.admission_appl_number%TYPE
7051: ) IS
7052: SELECT choice_number, alt_appl_id
7053: FROM igs_ad_appl
7054: WHERE person_id = cp_n_person_id
7055: AND admission_appl_number = cp_n_admission_appl_no ;
7056: rec_c_igs_ad_appl c_igs_ad_appl%ROWTYPE;
7057:

Line 7056: rec_c_igs_ad_appl c_igs_ad_appl%ROWTYPE;

7052: SELECT choice_number, alt_appl_id
7053: FROM igs_ad_appl
7054: WHERE person_id = cp_n_person_id
7055: AND admission_appl_number = cp_n_admission_appl_no ;
7056: rec_c_igs_ad_appl c_igs_ad_appl%ROWTYPE;
7057:
7058:
7059: CURSOR c_igs_pe_person(cp_n_person_id igs_pe_person.person_id%TYPE) IS
7060: SELECT party_number person_number

Line 7083: OPEN c_igs_ad_appl(p_person_id,

7079: IF c_igs_pe_ucas%FOUND THEN
7080: IF (NVL(p_adm_outcome_status_old, '-1') <> p_adm_outcome_status) OR
7081: (NVL(p_cond_offer_status_old, '-1') <> p_cond_offer_status) THEN
7082:
7083: OPEN c_igs_ad_appl(p_person_id,
7084: p_admission_appl_number
7085: );
7086: FETCH c_igs_ad_appl INTO rec_c_igs_ad_appl;
7087: CLOSE c_igs_ad_appl;

Line 7086: FETCH c_igs_ad_appl INTO rec_c_igs_ad_appl;

7082:
7083: OPEN c_igs_ad_appl(p_person_id,
7084: p_admission_appl_number
7085: );
7086: FETCH c_igs_ad_appl INTO rec_c_igs_ad_appl;
7087: CLOSE c_igs_ad_appl;
7088:
7089:
7090: OPEN c_igs_pe_person(p_person_id);

Line 7087: CLOSE c_igs_ad_appl;

7083: OPEN c_igs_ad_appl(p_person_id,
7084: p_admission_appl_number
7085: );
7086: FETCH c_igs_ad_appl INTO rec_c_igs_ad_appl;
7087: CLOSE c_igs_ad_appl;
7088:
7089:
7090: OPEN c_igs_pe_person(p_person_id);
7091: FETCH c_igs_pe_person INTO rec_c_igs_pe_person;

Line 7110: rec_c_igs_ad_appl.choice_number,

7106: P_CONDITION_NAME => :11,
7107: P_UC_TRAN_ID => :12); END;'
7108: USING
7109: IGS_GE_NUMBER.TO_CANN(NULL), -- made obsolete, earlier passed rec_c_igs_pe_ucas.api_person_id,
7110: rec_c_igs_ad_appl.choice_number,
7111: rec_c_igs_pe_person.person_number,
7112: p_admission_appl_number,
7113: p_nominated_course_cd,
7114: p_sequence_number,

Line 7117: rec_c_igs_ad_appl.alt_appl_id,

7113: p_nominated_course_cd,
7114: p_sequence_number,
7115: p_adm_outcome_status,
7116: p_cond_offer_status,
7117: rec_c_igs_ad_appl.alt_appl_id,
7118: p_condition_category,
7119: p_condition_name,
7120: OUT p_uc_tran_id;
7121: