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_SS_EN_WRAPPERS dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);

1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',

Line 1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);

1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',
1845: p_event_key =>'oracle.apps.igs.en.dropnotification'||l_cur_seq_val.seq_val,

Line 2470: Igs_En_Su_Attempt_Pkg.update_row

2466: OPEN get_sua_dtls;
2467: FETCH get_sua_dtls INTO l_sua_dtls_rec;
2468: CLOSE get_sua_dtls;
2469:
2470: Igs_En_Su_Attempt_Pkg.update_row
2471: (x_rowid => l_sua_dtls_rec.ROWID,
2472: x_person_id =>l_sua_dtls_rec.person_id,
2473: x_course_cd =>l_sua_dtls_rec.course_cd,
2474: x_unit_cd =>l_sua_dtls_rec.unit_cd,

Line 3273: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(l_source_rowid);

3269: FETCH cur_get_source_rowid INTO l_source_rowid;
3270: CLOSE cur_get_source_rowid;
3271:
3272: -- Delete the source unit attempt
3273: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(l_source_rowid);
3274:
3275: -- Get the Person Number
3276: OPEN cur_get_person_num(p_person_id);
3277: FETCH cur_get_person_num INTO l_person_number;

Line 3316: igs_en_su_attempt_pkg.pkg_reason := NULL;

3312: || Change History :
3313: || Who When What
3314: */
3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;

Line 3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;

3313: || Who When What
3314: */
3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;
3321: END drop_notif_variable;

Line 3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;

3314: */
3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;
3321: END drop_notif_variable;
3322:

Line 3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;

3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;
3321: END drop_notif_variable;
3322:
3323: PROCEDURE ENRP_CHK_DEL_SUB_UNITS(

Line 3389: igs_en_su_attempt_pkg.delete_row(v_sua_rec.row_id);

3385:
3386: FOR v_sua_rec IN c_sua_rec LOOP
3387: --phisically delelte if sua status is "unconfirm"
3388: IF v_sua_rec.unit_attempt_status = 'UNCONFIRM' THEN
3389: igs_en_su_attempt_pkg.delete_row(v_sua_rec.row_id);
3390:
3391: --update to dropped if status is invalid
3392:
3393: ELSIF v_sua_rec.unit_attempt_status = 'INVALID' THEN

Line 3813: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG

3809: l_enc_message_name VARCHAR2(2000);
3810: l_app_short_name VARCHAR2(10);
3811: l_msg_index NUMBER;
3812: BEGIN
3813: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
3814: OPEN cur_grading(p_person_id,p_course_cd,p_uoo_id);
3815: FETCH cur_grading INTO l_data;
3816: IF cur_grading%FOUND THEN
3817: igs_en_su_attempt_pkg.update_row (

Line 3817: igs_en_su_attempt_pkg.update_row (

3813: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
3814: OPEN cur_grading(p_person_id,p_course_cd,p_uoo_id);
3815: FETCH cur_grading INTO l_data;
3816: IF cur_grading%FOUND THEN
3817: igs_en_su_attempt_pkg.update_row (
3818: x_rowid => l_data.rowid,
3819: x_person_id => l_data.person_id,
3820: x_course_cd => l_data.course_cd,
3821: x_unit_cd => l_data.unit_cd,

Line 3966: igs_en_su_attempt_pkg.update_row (

3962: OPEN cur_credit(p_person_id,p_course_cd,p_uoo_id);
3963: FETCH cur_credit INTO l_data;
3964:
3965: IF cur_credit%FOUND THEN
3966: igs_en_su_attempt_pkg.update_row (
3967: x_rowid => l_data.rowid,
3968: x_person_id => l_data.person_id,
3969: x_course_cd => l_data.course_cd,
3970: x_unit_cd => l_data.unit_cd,

Line 4351: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG

4347:
4348: OPEN c_crs_ver;
4349: FETCH c_crs_ver INTO l_crs_ver;
4350: CLOSE c_crs_ver;
4351: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
4352: OPEN cur_grading(p_person_id,p_course_cd,p_uoo_id);
4353: FETCH cur_grading INTO l_data;
4354: IF cur_grading%FOUND THEN
4355:

Line 4366: igs_en_su_attempt_pkg.update_row (

4362: l_override_eftsu := l_data.override_eftsu ;
4363: l_override_credit_reason := l_data.override_credit_reason ;
4364: END IF;
4365:
4366: igs_en_su_attempt_pkg.update_row (
4367: x_rowid => l_data.rowid,
4368: x_person_id => l_data.person_id,
4369: x_course_cd => l_data.course_cd,
4370: x_unit_cd => l_data.unit_cd,

Line 4577: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG

4573: SAVEPOINT update_core_indicator;
4574:
4575: l_core_indicator := p_core_indicator;
4576:
4577: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
4578: OPEN cur_core_ind(p_person_id, p_program_cd, p_uoo_id);
4579: FETCH cur_core_ind INTO l_data;
4580: CLOSE cur_core_ind;
4581:

Line 4586: -- make call to update_row of IGS_EN_SU_ATTEMPT_PKG to update core indicator code value l_core_indicator

4582: -- IF length(l_core_indicator)=0 THEN
4583: -- l_core_indicator := p_core_indicator;
4584: -- END IF;
4585:
4586: -- make call to update_row of IGS_EN_SU_ATTEMPT_PKG to update core indicator code value l_core_indicator
4587: Igs_En_Su_Attempt_Pkg.update_row(
4588: x_rowid =>l_data.ROWID,
4589: x_person_id =>l_data.person_id,
4590: x_course_cd =>l_data.course_cd,

Line 4587: Igs_En_Su_Attempt_Pkg.update_row(

4583: -- l_core_indicator := p_core_indicator;
4584: -- END IF;
4585:
4586: -- make call to update_row of IGS_EN_SU_ATTEMPT_PKG to update core indicator code value l_core_indicator
4587: Igs_En_Su_Attempt_Pkg.update_row(
4588: x_rowid =>l_data.ROWID,
4589: x_person_id =>l_data.person_id,
4590: x_course_cd =>l_data.course_cd,
4591: x_unit_cd =>l_data.unit_cd,

Line 4862: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW( -- calling the TBH

4858:
4859: OPEN c_sua(p_person_id, p_course_cd, p_uoo_id);
4860: FETCH c_sua INTO l_sua_rec;
4861: IF c_sua%FOUND THEN
4862: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW( -- calling the TBH
4863: X_ROWID => l_sua_rec.ROW_ID,
4864: X_PERSON_ID => l_sua_rec.PERSON_ID,
4865: X_COURSE_CD => l_sua_rec.COURSE_CD ,
4866: X_UNIT_CD => l_sua_rec.UNIT_CD,