[Home] [Help]
441: PROCEDURE admp_val_offer_future_term(
442: errbuf out NOCOPY varchar2,
443: retcode out NOCOPY number ,
444: p_person_id hz_parties.party_id%TYPE,
445: p_group_id igs_pe_persid_group.group_id%TYPE,
446: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
447: p_prev_acad_adm_cal VARCHAR2,
448: p_future_acad_adm_cal VARCHAR2,
449: p_offer_dt VARCHAR2,
487: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
488: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
489:
490: l_person_number hz_parties.party_number%TYPE;
491: l_group_desc igs_pe_persid_group.description%TYPE;
492:
493: ---End Variable Declarations--------------------------------------------------------------------------------------------
494:
495: -------------Cursor Declarations ----------------------------------------------------------------------------------------
506: CURSOR c_pergr_cur IS
507: SELECT
508: description
509: FROM
510: igs_pe_persid_group
511: WHERE
512: group_id = p_group_id;
513:
514: -- Cursor for getting the alternade academic/admission code for a given academic/admission cal type and sequence number
557: AND NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) = NVL ( p_prev_adm_cal_seq_no, acai.adm_ci_sequence_number)
558: AND aa.APPLICATION_TYPE = NVL(p_application_type,aa.APPLICATION_TYPE)
559: AND aa.APPLICATION_ID = NVL(p_application_id,aa.APPLICATION_ID);
560:
561: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS
562: SELECT 'X'
563: FROM igs_pe_prsid_grp_mem
564: WHERE person_id = p_person_id
565: AND group_id = p_group_id
590: c_ref_cur_rec c_ref_cur_rec_typ;
591:
592: -- for bug 5245277 and sql id 17651699 and 17651677
593: l_status VARCHAR2(1);
594: l_group_type IGS_PE_PERSID_GROUP_V.group_type%type;
595:
596: -- End cursor declarations -----------------------------------------------------------------------------------------------
597: BEGIN
598: