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_EN_TRANSFER_APIS dependencies on IGS_EN_STDNT_PS_ATT

Line 121: From IGS_EN_STDNT_PS_ATT_ALL

117:
118: l_val VARCHAR2(10);
119: CURSOR c_get_prgm_att_status IS
120: Select 'Y'
121: From IGS_EN_STDNT_PS_ATT_ALL
122: Where person_id = p_person_id and
123: course_cd = p_dest_program_cd and
124: version_number = p_dest_prog_ver and
125: course_attempt_status = 'DISCONTIN';

Line 170: FROM IGS_EN_STDNT_PS_ATT

166: -- stutta 26-Sep-2005 Added call to create_update_term_rec for bug 4588264
167: --------------------------------------------------------------------------------------------
168: CURSOR c_get_stdnt_ps_att_dtls IS
169: SELECT *
170: FROM IGS_EN_STDNT_PS_ATT
171: WHERE person_id = p_person_id AND
172: course_cd = p_course_cd;
173:
174: CURSOR c_get_discont_reason IS

Line 184: FROM IGS_EN_STDNT_PS_ATT

180: s_discontinuation_reason_type = 'TRANSFER';
181:
182: CURSOR c_get_comm_dt_of_src_prg IS
183: SELECT commencement_dt
184: FROM IGS_EN_STDNT_PS_ATT
185: WHERE person_id = p_person_id AND
186: course_cd = p_src_course_cd;
187:
188: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;

Line 188: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;

184: FROM IGS_EN_STDNT_PS_ATT
185: WHERE person_id = p_person_id AND
186: course_cd = p_src_course_cd;
187:
188: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
189: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
190: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
191: l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
192: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE := FND_API.G_MISS_CHAR;

Line 189: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

185: WHERE person_id = p_person_id AND
186: course_cd = p_src_course_cd;
187:
188: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
189: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
190: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
191: l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
192: l_key_program_flag igs_en_spa_terms.key_program_flag%TYPE := FND_API.G_MISS_CHAR;
193: l_message_name VARCHAR2(2000);

Line 233: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

229: p_course_rqrmnt_complete_ind => l_stdnt_ps_attempt_dtls_rec.COURSE_RQRMNT_COMPLETE_IND,
230: p_logical_delete_dt => l_stdnt_ps_attempt_dtls_rec.logical_delete_dt );
231: igs_en_spa_terms_api.set_spa_term_cal_type(P_TERM_CAL_TYPE);
232: igs_en_spa_terms_api.set_spa_term_sequence_number (p_term_seq_num);
233: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
234: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
235: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
236: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
237: X_ADVANCED_STANDING_IND => l_stdnt_ps_attempt_dtls_rec.ADVANCED_STANDING_IND,

Line 330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire

326:
327: EXCEPTION
328:
329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;

Line 331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

327: EXCEPTION
328:
329: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
330: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
331: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN

Line 336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

332: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
333: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
334: RAISE;
335: WHEN FND_API.G_EXC_ERROR THEN
336: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
337: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
339:
340: RAISE;

Line 342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire

338: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
339:
340: RAISE;
341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

339:
340: RAISE;
341: WHEN OTHERS THEN
342: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
343: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
344: igs_en_spa_terms_api.set_spa_term_cal_type(NULL);
345: igs_en_spa_terms_api.set_spa_term_sequence_number (NULL);
346: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
347: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_destination_prgm');

Line 389: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

385: */
386:
387: l_begin_trans_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE;
388: l_begin_trans_dt_alias_val DATE;
389: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
390: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
391: CURSOR c_get_key_val_frm_src_prg IS
392: SELECT key_program,commencement_dt
393: FROM IGS_EN_STDNT_PS_ATT

Line 390: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;

386:
387: l_begin_trans_dt_alias IGS_EN_CAL_CONF.BEGIN_TRANS_DT_ALIAS%TYPE;
388: l_begin_trans_dt_alias_val DATE;
389: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
390: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
391: CURSOR c_get_key_val_frm_src_prg IS
392: SELECT key_program,commencement_dt
393: FROM IGS_EN_STDNT_PS_ATT
394: WHERE person_id = p_person_id AND

Line 393: FROM IGS_EN_STDNT_PS_ATT

389: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
390: l_src_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
391: CURSOR c_get_key_val_frm_src_prg IS
392: SELECT key_program,commencement_dt
393: FROM IGS_EN_STDNT_PS_ATT
394: WHERE person_id = p_person_id AND
395: course_cd = p_src_program_cd;
396: CURSOR c_get_begin_trans_dt_alias IS
397: SELECT begin_trans_dt_alias

Line 565: CURSOR c_get_dest_prg_dtls(c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS

561:
562: -------------------------------------------------------------------------------------------
563:
564:
565: CURSOR c_get_dest_prg_dtls(c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
566: SELECT *
567: FROM IGS_EN_STDNT_PS_ATT
568: WHERE person_id = c_person_id AND
569: course_cd = c_program_cd;

Line 567: FROM IGS_EN_STDNT_PS_ATT

563:
564:
565: CURSOR c_get_dest_prg_dtls(c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
566: SELECT *
567: FROM IGS_EN_STDNT_PS_ATT
568: WHERE person_id = c_person_id AND
569: course_cd = c_program_cd;
570: l_val_sca_confrm_status BOOLEAN;
571: l_val_sca_elgbl_status BOOLEAN;

Line 1455: CURSOR c_enroll_sua (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1451:
1452: -------------------------------------------------------------------------------------------
1453:
1454: -- cursor to get all the enrolled unit attempts uooid against destination program
1455: CURSOR c_enroll_sua (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1456: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1457:
1458: SELECT uoo_id
1459: FROM IGS_EN_SU_ATTEMPT sua

Line 1456: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

1452: -------------------------------------------------------------------------------------------
1453:
1454: -- cursor to get all the enrolled unit attempts uooid against destination program
1455: CURSOR c_enroll_sua (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1456: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1457:
1458: SELECT uoo_id
1459: FROM IGS_EN_SU_ATTEMPT sua
1460: WHERE sua.person_id = cp_person_id

Line 1500: CURSOR c_sca_detls (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1496: p_dest_program_cd IN VARCHAR2,
1497: p_uoo_id IN NUMBER,
1498: p_message_name OUT NOCOPY VARCHAR2)
1499: RETURN BOOLEAN AS
1500: CURSOR c_sca_detls (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1501: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1502: SELECT cal_type
1503: FROM igs_en_stdnt_ps_att
1504: WHERE person_id = cp_person_id AND

Line 1501: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

1497: p_uoo_id IN NUMBER,
1498: p_message_name OUT NOCOPY VARCHAR2)
1499: RETURN BOOLEAN AS
1500: CURSOR c_sca_detls (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1501: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1502: SELECT cal_type
1503: FROM igs_en_stdnt_ps_att
1504: WHERE person_id = cp_person_id AND
1505: course_cd = cp_course_cd ;

Line 1503: FROM igs_en_stdnt_ps_att

1499: RETURN BOOLEAN AS
1500: CURSOR c_sca_detls (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1501: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1502: SELECT cal_type
1503: FROM igs_en_stdnt_ps_att
1504: WHERE person_id = cp_person_id AND
1505: course_cd = cp_course_cd ;
1506: l_old_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1507: l_new_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

Line 1506: l_old_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

1502: SELECT cal_type
1503: FROM igs_en_stdnt_ps_att
1504: WHERE person_id = cp_person_id AND
1505: course_cd = cp_course_cd ;
1506: l_old_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1507: l_new_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1508: BEGIN
1509: -- get source acad cal type
1510: OPEN c_sca_detls(p_person_id, p_source_program_cd );

Line 1507: l_new_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

1503: FROM igs_en_stdnt_ps_att
1504: WHERE person_id = cp_person_id AND
1505: course_cd = cp_course_cd ;
1506: l_old_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1507: l_new_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
1508: BEGIN
1509: -- get source acad cal type
1510: OPEN c_sca_detls(p_person_id, p_source_program_cd );
1511: FETCH c_sca_detls INTO l_old_cal_type;

Line 2776: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

2772: -- instead of 'N'
2773: -------------------------------------------------------------------------------------------
2774:
2775:
2776: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2777: l_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2778: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
2779: l_status BOOLEAN;
2780: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 2777: l_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

2773: -------------------------------------------------------------------------------------------
2774:
2775:
2776: l_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2777: l_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2778: l_discont_reason_code IGS_EN_DCNT_REASONCD.discontinuation_reason_cd%TYPE;
2779: l_status BOOLEAN;
2780: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2781: CURSOR c_course_type IS

Line 2788: FROM IGS_EN_STDNT_PS_ATT

2784: WHERE COURSE_CD = p_source_program_cd
2785: AND VERSION_NUMBER = p_source_prog_ver;
2786: CURSOR c_get_stdnt_ps_att_dtls IS
2787: SELECT *
2788: FROM IGS_EN_STDNT_PS_ATT
2789: WHERE person_id = p_person_id AND
2790: course_cd = p_source_program_cd;
2791: l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
2792:

Line 2803: FROM IGS_EN_STDNT_PS_ATT sca,

2799: s_discontinuation_reason_type = 'TRANSFER';
2800: -- check if any other active program exists in the source career other than the source program
2801: CURSOR c_act_src_prg_exists_as_prmy IS
2802: SELECT 'x'
2803: FROM IGS_EN_STDNT_PS_ATT sca,
2804: IGS_PS_VER pv
2805: WHERE sca.person_id = p_person_id AND
2806: sca.course_cd = pv.course_cd AND
2807: sca.version_number = pv.version_number AND

Line 2824: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

2820: -- this procedure will automatically make the source secondary and make some other program in that career primary
2821: OPEN c_get_discont_reason;
2822: FETCH c_get_discont_reason INTO l_discont_reason_code;
2823: CLOSE c_get_discont_reason;
2824: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
2825: -- discontinue the source program attempt on the same date as the program ransfer record was created
2826: l_status := IGS_EN_GEN_012.ENRP_UPD_SCA_DISCONT (
2827: p_person_id,
2828: p_source_program_cd,

Line 2887: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

2883: l_course_type ,
2884: p_dest_program_cd);
2885: END IF;
2886:
2887: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
2888: X_ROWID => l_stdnt_ps_attempt_dtls_rec.row_id,
2889: X_PERSON_ID => l_stdnt_ps_attempt_dtls_rec.PERSON_ID,
2890: X_COURSE_CD => l_stdnt_ps_attempt_dtls_rec.COURSE_CD,
2891: X_ADVANCED_STANDING_IND => l_stdnt_ps_attempt_dtls_rec.ADVANCED_STANDING_IND,

Line 2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

2966: END IF;-- end of p_discontinue_source = 'Y' AND p_dest_fut_dt_trans_flag = 'N' IF THEN
2967:
2968: EXCEPTION
2969: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2971: RAISE;
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2974: RAISE;

Line 2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

2969: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2970: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2971: RAISE;
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2974: RAISE;
2975: WHEN OTHERS THEN
2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

2972: WHEN FND_API.G_EXC_ERROR THEN
2973: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2974: RAISE;
2975: WHEN OTHERS THEN
2976: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
2977: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2978: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_TRANSFER_APIS.update_source_prgm');
2979: IGS_GE_MSG_STACK.ADD;
2980: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

Line 3049: l_discon_reason_code IGS_EN_STDNT_PS_ATT.DISCONTINUED_DT%TYPE ;

3045:
3046: -------------------------------------------------------------------------------------------
3047:
3048: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_TRANSFER_APIS';
3049: l_discon_reason_code IGS_EN_STDNT_PS_ATT.DISCONTINUED_DT%TYPE ;
3050: l_discon_dt IGS_EN_STDNT_PS_ATT.DISCONTINUATION_REASON_CD%TYPE ;
3051: l_status BOOLEAN;
3052: l_return_value BOOLEAN;
3053: l_career_model_enabled BOOLEAN;

Line 3050: l_discon_dt IGS_EN_STDNT_PS_ATT.DISCONTINUATION_REASON_CD%TYPE ;

3046: -------------------------------------------------------------------------------------------
3047:
3048: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_TRANSFER_APIS';
3049: l_discon_reason_code IGS_EN_STDNT_PS_ATT.DISCONTINUED_DT%TYPE ;
3050: l_discon_dt IGS_EN_STDNT_PS_ATT.DISCONTINUATION_REASON_CD%TYPE ;
3051: l_status BOOLEAN;
3052: l_return_value BOOLEAN;
3053: l_career_model_enabled BOOLEAN;
3054: l_tran_across_careers BOOLEAN;

Line 3063: l_src_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;

3059: l_debt_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3060: l_hold_status BOOLEAN;
3061:
3062: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
3063: l_src_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3064: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:

Line 3064: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

3060: l_hold_status BOOLEAN;
3061:
3062: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
3063: l_src_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3064: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;

Line 3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;

3061:
3062: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
3063: l_src_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3064: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

Line 3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;

3064: l_src_key_prgm IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;

Line 3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

3065: l_src_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%TYPE;

Line 3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;

3066: l_src_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%TYPE;
3074: l_dest_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;

Line 3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;

3067:
3068: l_dest_primary_prg_type IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%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;

Line 3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%TYPE;

3069: l_old_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%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);

Line 3074: l_dest_std_confrm_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;

3070: l_new_dest_key_prgm_flag IGS_EN_STDNT_PS_ATT.KEY_PROGRAM%TYPE;
3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%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;

Line 3075: l_course_attempt_status IGS_EN_STDNT_PS_ATT.COURSE_ATTEMPT_STATUS%TYPE;

3071: l_dest_commence_dt IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;
3072: l_dest_prg_reasearch_ind IGS_PS_TYPE.research_type_ind%TYPE;
3073: l_dest_fut_dt_trans_flag IGS_EN_STDNT_PS_ATT.FUTURE_DATED_TRANS_FLAG%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;

Line 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

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
3085: FROM IGS_EN_STDNT_PS_ATT
3086: WHERE person_id = c_person_id and
3087: course_cd = c_program_cd;

Line 3085: FROM IGS_EN_STDNT_PS_ATT

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
3085: FROM IGS_EN_STDNT_PS_ATT
3086: WHERE person_id = c_person_id and
3087: course_cd = c_program_cd;
3088:
3089: CURSOR c_get_std_course_ind_of_src (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS

Line 3089: CURSOR c_get_std_course_ind_of_src (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS

3085: FROM IGS_EN_STDNT_PS_ATT
3086: WHERE person_id = c_person_id and
3087: course_cd = c_program_cd;
3088:
3089: CURSOR c_get_std_course_ind_of_src (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
3090: SELECT student_confirmed_ind, primary_program_type
3091: FROM IGS_EN_STDNT_PS_ATT
3092: WHERE person_id = c_person_id and
3093: course_cd = c_program_cd;

Line 3091: FROM IGS_EN_STDNT_PS_ATT

3087: course_cd = c_program_cd;
3088:
3089: CURSOR c_get_std_course_ind_of_src (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
3090: SELECT student_confirmed_ind, primary_program_type
3091: FROM IGS_EN_STDNT_PS_ATT
3092: WHERE person_id = c_person_id and
3093: course_cd = c_program_cd;
3094: CURSOR c_get_progam_type(c_course_cd IGS_PS_VER.course_cd%TYPE,c_course_ver IGS_PS_VER.version_number%TYPE) IS
3095: SELECT cty.research_type_ind

Line 3362: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;

3358:
3359: -- Updating destination program attempt during transfer.
3360: -- in this case the setting global variable to skip auto calculations of primary/secondary
3361: -- since the rank calculations need not be done. The destination will always be primary.
3362: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;
3363: update_destination_prgm(p_person_id,
3364: p_source_program_cd,
3365: p_dest_program_cd,
3366: l_new_dest_key_prgm_flag,

Line 3578: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3574: l_src_career_type);
3575: END IF;
3576: -- its an immediate transfer.
3577:
3578: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3579: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3580: p_data => p_msg_data);
3581:
3582: IF p_show_warning = 'Y' AND p_msg_count > 0 THEN

Line 3588: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3584: END IF;
3585:
3586: EXCEPTION
3587: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3588: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3589: p_return_status := FND_API.G_RET_STS_ERROR;
3590: FND_MESSAGE.SET_ENCODED(FND_MESSAGE.GET_ENCODED());
3591: FND_MSG_PUB.ADD;
3592: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,

Line 3596: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3592: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3593: p_data => p_msg_data);
3594: ROLLBACK TO TRANSFER_PRGM;
3595: WHEN FND_API.G_EXC_ERROR THEN
3596: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3597: p_return_status := FND_API.G_RET_STS_ERROR;
3598: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3599: p_data => p_msg_data);
3600: ROLLBACK TO TRANSFER_PRGM;

Line 3602: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3598: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3599: p_data => p_msg_data);
3600: ROLLBACK TO TRANSFER_PRGM;
3601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3602: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: FND_MSG_PUB.COUNT_AND_GET( p_count => p_msg_count,
3605: p_data => p_msg_data);
3606: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

Line 3611: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;

3607: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_program_transfer_apis.program_transfer_api :',SQLERRM);
3608: END IF;
3609: ROLLBACK TO TRANSFER_PRGM;
3610: WHEN OTHERS THEN
3611: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE;
3612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3613: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3614: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
3615: l_api_name);

Line 3718: CURSOR c_parent_exist (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,

3714: --Who When What
3715: --ctyagi 25-Nov-2005 changed the order of unitset_attempt string
3716: -------------------------------------------------------------------------------------------
3717:
3718: CURSOR c_parent_exist (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3719: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3720: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3721: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3722: IS

Line 3719: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,

3715: --ctyagi 25-Nov-2005 changed the order of unitset_attempt string
3716: -------------------------------------------------------------------------------------------
3717:
3718: CURSOR c_parent_exist (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3719: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3720: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3721: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3722: IS
3723: SELECT 'x' FROM igs_as_su_setatmpt

Line 3730: CURSOR c_get_child (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,

3726: AND UNIT_SET_CD = c_unitset_cd
3727: AND SEQUENCE_NUMBER= c_seq_no
3728: AND PARENT_UNIT_SET_CD IS NOT NULL;
3729:
3730: CURSOR c_get_child (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3731: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3732: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3733: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3734: IS

Line 3731: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,

3727: AND SEQUENCE_NUMBER= c_seq_no
3728: AND PARENT_UNIT_SET_CD IS NOT NULL;
3729:
3730: CURSOR c_get_child (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3731: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3732: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3733: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3734: IS
3735: select susa.unit_set_cd || ',' || susa.sequence_number AS unitcd_seqno