APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_PS_STDNT_TRN

Line 3078: l_trans_comments igs_ps_stdnt_trn.comments%TYPE;

3074: l_dest_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3075: l_course_attempt_status IGS_EN_STDNT_PS_ATT.COURSE_ATTEMPT_STATUS%TYPE;
3076: l_status_date CONSTANT DATE := SYSDATE;
3077: l_trans_rowid VARCHAR2(25);
3078: l_trans_comments igs_ps_stdnt_trn.comments%TYPE;
3079: l_trans_date igs_ps_stdnt_trn.transfer_dt%TYPE;
3080: l_trans_status igs_ps_stdnt_trn.status_flag%TYPE;
3081: l_unit_sets_to_transfer VARCHAR2(4000);
3082:

Line 3079: l_trans_date igs_ps_stdnt_trn.transfer_dt%TYPE;

3075: l_course_attempt_status IGS_EN_STDNT_PS_ATT.COURSE_ATTEMPT_STATUS%TYPE;
3076: l_status_date CONSTANT DATE := SYSDATE;
3077: l_trans_rowid VARCHAR2(25);
3078: l_trans_comments igs_ps_stdnt_trn.comments%TYPE;
3079: l_trans_date igs_ps_stdnt_trn.transfer_dt%TYPE;
3080: l_trans_status igs_ps_stdnt_trn.status_flag%TYPE;
3081: l_unit_sets_to_transfer VARCHAR2(4000);
3082:
3083: CURSOR c_get_key_val_frm_prg(c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS

Line 3080: l_trans_status igs_ps_stdnt_trn.status_flag%TYPE;

3076: l_status_date CONSTANT DATE := SYSDATE;
3077: l_trans_rowid VARCHAR2(25);
3078: l_trans_comments igs_ps_stdnt_trn.comments%TYPE;
3079: l_trans_date igs_ps_stdnt_trn.transfer_dt%TYPE;
3080: l_trans_status igs_ps_stdnt_trn.status_flag%TYPE;
3081: l_unit_sets_to_transfer VARCHAR2(4000);
3082:
3083: CURSOR c_get_key_val_frm_prg(c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
3084: SELECT key_program ,student_confirmed_ind,commencement_dt, course_attempt_status

Line 3103: CURSOR c_chk_trans_rec (c_person_id igs_ps_stdnt_trn.person_id%TYPE,

3099: crv.version_number = c_course_ver AND
3100: crv.course_type = cty.course_type ;
3101:
3102: -- select any UNPROCESSED transfer record for the student with the same source and destination combo
3103: CURSOR c_chk_trans_rec (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3104: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3105: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3106: SELECT rowid, transfer_dt, comments
3107: FROM igs_ps_stdnt_trn

Line 3104: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,

3100: crv.course_type = cty.course_type ;
3101:
3102: -- select any UNPROCESSED transfer record for the student with the same source and destination combo
3103: CURSOR c_chk_trans_rec (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3104: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3105: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3106: SELECT rowid, transfer_dt, comments
3107: FROM igs_ps_stdnt_trn
3108: WHERE person_id = c_person_id

Line 3105: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS

3101:
3102: -- select any UNPROCESSED transfer record for the student with the same source and destination combo
3103: CURSOR c_chk_trans_rec (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3104: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3105: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3106: SELECT rowid, transfer_dt, comments
3107: FROM igs_ps_stdnt_trn
3108: WHERE person_id = c_person_id
3109: AND course_cd = c_course_cd

Line 3107: FROM igs_ps_stdnt_trn

3103: CURSOR c_chk_trans_rec (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3104: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3105: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3106: SELECT rowid, transfer_dt, comments
3107: FROM igs_ps_stdnt_trn
3108: WHERE person_id = c_person_id
3109: AND course_cd = c_course_cd
3110: AND transfer_course_cd = c_transfer_course_cd
3111: AND STATUS_FLAG = 'U';

Line 3129: CURSOR c_trans_exists (c_person_id igs_ps_stdnt_trn.person_id%TYPE,

3125: AND nominated_course_cd = cp_course_cd
3126: AND transfer_course_cd = cp_transfer_course_cd;
3127:
3128: -- check if a transfer record exists for the passed source and destination or not
3129: CURSOR c_trans_exists (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3130: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3131: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3132: SELECT transfer_dt
3133: FROM igs_ps_stdnt_trn

Line 3130: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,

3126: AND transfer_course_cd = cp_transfer_course_cd;
3127:
3128: -- check if a transfer record exists for the passed source and destination or not
3129: CURSOR c_trans_exists (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3130: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3131: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3132: SELECT transfer_dt
3133: FROM igs_ps_stdnt_trn
3134: WHERE person_id = c_person_id

Line 3131: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS

3127:
3128: -- check if a transfer record exists for the passed source and destination or not
3129: CURSOR c_trans_exists (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3130: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3131: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3132: SELECT transfer_dt
3133: FROM igs_ps_stdnt_trn
3134: WHERE person_id = c_person_id
3135: AND course_cd = c_course_cd

Line 3133: FROM igs_ps_stdnt_trn

3129: CURSOR c_trans_exists (c_person_id igs_ps_stdnt_trn.person_id%TYPE,
3130: c_course_cd igs_ps_stdnt_trn.course_cd%TYPE,
3131: c_transfer_course_cd igs_ps_stdnt_trn.transfer_course_cd%TYPE) IS
3132: SELECT transfer_dt
3133: FROM igs_ps_stdnt_trn
3134: WHERE person_id = c_person_id
3135: AND course_cd = c_course_cd
3136: AND transfer_course_cd = c_transfer_course_cd
3137: AND status_flag <> 'C';

Line 3399: igs_ps_stdnt_trn_pkg.update_row(

3395: -- NOTE: The transfer term calendar information should be same as the old
3396: -- else the logic would need to change to delete the old term calendars
3397: -- and create new ones.
3398:
3399: igs_ps_stdnt_trn_pkg.update_row(
3400: x_rowid => l_trans_rowid,
3401: x_person_id => p_person_id,
3402: x_course_cd => p_dest_program_cd,
3403: x_transfer_course_cd => p_source_program_cd,