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.

[Home] [Help]

APPS.IGS_EN_IVR_PUB dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 438: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

434: l_person_id igs_pe_person.person_id%TYPE;
435: l_person_type igs_pe_person_types.person_type_code%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.

Line 439: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

435: l_person_type igs_pe_person_types.person_type_code%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,

Line 949: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

945: l_person_id igs_pe_person.person_id%TYPE;
946: l_person_type igs_pe_person_types.person_type_code%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);

Line 950: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

946: l_person_type igs_pe_person_types.person_type_code%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:

Line 1151: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

1147: l_person_id igs_pe_person.person_id%TYPE;
1148: l_person_type igs_pe_person_types.person_type_code%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:

Line 1152: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

1148: l_person_type igs_pe_person_types.person_type_code%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 (

Line 1320: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

1316: l_person_id igs_pe_person.person_id%TYPE;
1317: l_person_type igs_pe_person_types.person_type_code%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:

Line 1321: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

1317: l_person_type igs_pe_person_types.person_type_code%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(

Line 1327: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

1323: l_rec_count NUMBER(15);
1324:
1325: CURSOR cur_cart(
1326: cp_person_id igs_pe_person.person_id%TYPE,
1327: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
1328: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
1329: SELECT sua.rowid
1330: FROM igs_en_su_attempt_all sua
1331: WHERE person_id = cp_person_id AND

Line 1328: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS

1324:
1325: CURSOR cur_cart(
1326: cp_person_id igs_pe_person.person_id%TYPE,
1327: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
1328: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
1329: SELECT sua.rowid
1330: FROM igs_en_su_attempt_all sua
1331: WHERE person_id = cp_person_id AND
1332: course_cd = cp_course_cd AND

Line 1330: FROM igs_en_su_attempt_all sua

1326: cp_person_id igs_pe_person.person_id%TYPE,
1327: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
1328: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS
1329: SELECT sua.rowid
1330: FROM igs_en_su_attempt_all sua
1331: WHERE person_id = cp_person_id AND
1332: course_cd = cp_course_cd AND
1333: uoo_id = cp_uoo_id;
1334: l_rec_cart cur_cart%ROWTYPE;

Line 1478: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

1474: l_person_id igs_pe_person.person_id%TYPE;
1475: l_person_type igs_pe_person_types.person_type_code%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

Line 1479: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

1475: l_person_type igs_pe_person_types.person_type_code%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.*

Line 1482: CURSOR cur_enroll_stat(cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE)IS

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
1485: WHERE puo.uoo_id = cp_uoo_id;
1486: l_rec_enroll_stat cur_enroll_stat%ROWTYPE;

Line 1677: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

1673: l_return_status VARCHAR2(1000);
1674:
1675: l_person_id igs_pe_person.person_id%TYPE;
1676: l_person_type igs_pe_person_types.person_type_code%TYPE;
1677: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
1678: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
1679: l_programlist VARCHAR2(1000);
1680:
1681: CURSOR cur_get_ver(

Line 1678: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

1674:
1675: l_person_id igs_pe_person.person_id%TYPE;
1676: l_person_type igs_pe_person_types.person_type_code%TYPE;
1677: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
1678: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
1679: l_programlist VARCHAR2(1000);
1680:
1681: CURSOR cur_get_ver(
1682: cp_person_id igs_pe_person.person_id%TYPE,

Line 1683: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS

1679: l_programlist VARCHAR2(1000);
1680:
1681: CURSOR cur_get_ver(
1682: cp_person_id igs_pe_person.person_id%TYPE,
1683: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS
1684: SELECT version_number
1685: FROM igs_en_stdnt_ps_att
1686: WHERE person_id = cp_person_id AND
1687: course_cd = cp_course_cd;