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_IVR_PUB dependencies on IGS_PS_UNIT_OFR_OPT

Line 173: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

169: l_cal_type igs_ca_inst.cal_type%TYPE;
170: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
171: l_primary_code igs_ps_ver.course_cd%TYPE;
172: l_primary_version igs_ps_ver.version_number%TYPE;
173: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
174: l_error_message VARCHAR2(2000);
175: l_ret_status VARCHAR2(6);
176: l_message_count NUMBER;
177: l_message_data VARCHAR2(2000) := NULL;

Line 440: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

436: l_cal_type igs_ca_inst.cal_type%TYPE;
437: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
438: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
439: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
440: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
441:
442: -- Cursor to fetch the row_id, to clean up the cart.
443: CURSOR cur_sua (cp_person_id igs_pe_person.person_id%TYPE,
444: cp_program_cd igs_en_su_attempt.course_cd%TYPE,

Line 810: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

806: l_cal_type igs_ca_inst.cal_type%TYPE;
807: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
808: l_primary_code igs_ps_ver.course_cd%TYPE;
809: l_primary_version igs_ps_ver.version_number%TYPE;
810: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
811: l_message_data VARCHAR2(2000);
812: l_ret_status VARCHAR2(6);
813: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;
814: l_step_eval_result VARCHAR2(6);

Line 951: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

947: l_cal_type igs_ca_inst.cal_type%TYPE;
948: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
949: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
950: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
951: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
952: l_rec_count NUMBER(15);
953: l_status_not_shown VARCHAR2(100);
954:
955: CURSOR cur_schedule_type (

Line 1153: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

1149: l_cal_type igs_ca_inst.cal_type%TYPE;
1150: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1151: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
1152: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
1153: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1154: l_rec_count NUMBER(15);
1155:
1156: CURSOR cur_call_num (
1157: cp_person_id igs_pe_person.person_id%TYPE,

Line 1322: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

1318: l_cal_type igs_ca_inst.cal_type%TYPE;
1319: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1320: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
1321: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
1322: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1323: l_rec_count NUMBER(15);
1324:
1325: CURSOR cur_cart(
1326: cp_person_id igs_pe_person.person_id%TYPE,

Line 1459: || sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row

1455: || Purpose : To Update the statistic in enrollment.
1456: || Known limitations, enhancements or remarks :
1457: || Change History :
1458: || Who When What
1459: || sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
1460: || to include new parameter abort_flag.
1461: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
1462: || to include new parameter sup_uoo_id,relation_type,default_enroll_flag
1463: || vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to

Line 1461: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row

1457: || Change History :
1458: || Who When What
1459: || sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
1460: || to include new parameter abort_flag.
1461: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
1462: || to include new parameter sup_uoo_id,relation_type,default_enroll_flag
1463: || vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to
1464: || igs_ps_unit_ofr_opt_pkg.update_row to include
1465: || new parameter not_multiple_section_flag.

Line 1464: || igs_ps_unit_ofr_opt_pkg.update_row to include

1460: || to include new parameter abort_flag.
1461: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
1462: || to include new parameter sup_uoo_id,relation_type,default_enroll_flag
1463: || vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to
1464: || igs_ps_unit_ofr_opt_pkg.update_row to include
1465: || new parameter not_multiple_section_flag.
1466: */
1467: l_api_name CONSTANT VARCHAR2(30) := 'update_enroll_stats';
1468: l_api_version CONSTANT NUMBER := 1.0;

Line 1480: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

1476: l_cal_type igs_ca_inst.cal_type%TYPE;
1477: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1478: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
1479: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
1480: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1481:
1482: CURSOR cur_enroll_stat(cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
1483: SELECT puo.*
1484: FROM igs_ps_unit_ofr_opt puo

Line 1484: FROM igs_ps_unit_ofr_opt puo

1480: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1481:
1482: CURSOR cur_enroll_stat(cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
1483: SELECT puo.*
1484: FROM igs_ps_unit_ofr_opt puo
1485: WHERE puo.uoo_id = cp_uoo_id;
1486: l_rec_enroll_stat cur_enroll_stat%ROWTYPE;
1487: BEGIN
1488: --Standard start of API savepoint

Line 1546: -- Fetch the record from IGS_PS_UNIT_OFR_OPT for the fetched uoo_id to update INQ_NOT_WLST coulmn.

1542: RETURN;
1543: END IF;
1544:
1545: --
1546: -- Fetch the record from IGS_PS_UNIT_OFR_OPT for the fetched uoo_id to update INQ_NOT_WLST coulmn.
1547: --
1548: OPEN cur_enroll_stat(l_uoo_id);
1549: FETCH cur_enroll_stat INTO l_rec_enroll_stat;
1550: IF cur_enroll_stat%FOUND THEN

Line 1552: igs_ps_unit_ofr_opt_pkg.update_row(

1548: OPEN cur_enroll_stat(l_uoo_id);
1549: FETCH cur_enroll_stat INTO l_rec_enroll_stat;
1550: IF cur_enroll_stat%FOUND THEN
1551: BEGIN
1552: igs_ps_unit_ofr_opt_pkg.update_row(
1553: X_ROWID => l_rec_enroll_stat.row_id ,
1554: X_UNIT_CD => l_rec_enroll_stat.unit_cd ,
1555: X_VERSION_NUMBER => l_rec_enroll_stat.version_number ,
1556: X_CAL_TYPE => l_rec_enroll_stat.cal_type ,