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_EN_SU_ATTEMPT

Line 188: FROM igs_en_su_attempt sua

184: CURSOR c_us_in_cart IS
185: SELECT sua.uoo_id,
186: sua.enr_method_type,
187: sua.cart
188: FROM igs_en_su_attempt sua
189: WHERE sua.person_id = l_person_id
190: AND sua.course_cd = l_primary_code
191: AND (sua.cal_type, sua.ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number
192: FROM igs_ca_load_to_teach_v

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 444: cp_program_cd igs_en_su_attempt.course_cd%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,
445: cp_version_number igs_en_su_attempt.version_number%TYPE)IS
446: SELECT sua.row_id
447: FROM igs_en_su_attempt sua
448: WHERE unit_attempt_status = 'UNCONFIRM' AND

Line 445: cp_version_number igs_en_su_attempt.version_number%TYPE)IS

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,
445: cp_version_number igs_en_su_attempt.version_number%TYPE)IS
446: SELECT sua.row_id
447: FROM igs_en_su_attempt sua
448: WHERE unit_attempt_status = 'UNCONFIRM' AND
449: cart = 'I' AND

Line 447: FROM igs_en_su_attempt sua

443: CURSOR cur_sua (cp_person_id igs_pe_person.person_id%TYPE,
444: cp_program_cd igs_en_su_attempt.course_cd%TYPE,
445: cp_version_number igs_en_su_attempt.version_number%TYPE)IS
446: SELECT sua.row_id
447: FROM igs_en_su_attempt sua
448: WHERE unit_attempt_status = 'UNCONFIRM' AND
449: cart = 'I' AND
450: person_id = cp_person_id AND
451: course_cd = cp_program_cd AND

Line 513: igs_en_su_attempt_pkg.delete_row(rec_sua.row_id);

509: END IF;
510:
511: -- Loop through the records and call the delete row to drop the cart.
512: FOR rec_sua IN cur_sua(l_person_id, l_primary_code, l_primary_version) LOOP
513: igs_en_su_attempt_pkg.delete_row(rec_sua.row_id);
514: END LOOP;
515:
516: --Standard check of p_commit.
517: IF FND_API.to_Boolean(p_commit) THEN

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 957: cp_program_cd igs_en_su_attempt.course_cd%TYPE,

953: l_status_not_shown VARCHAR2(100);
954:
955: CURSOR cur_schedule_type (
956: cp_person_id igs_pe_person.person_id%TYPE,
957: cp_program_cd igs_en_su_attempt.course_cd%TYPE,
958: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
959: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
960: cp_unit_status_not_shown VARCHAR2)IS
961: SELECT

Line 975: igs_en_su_attempt sua1,

971: sua.uoo_id uoo_id ,
972: sua.administrative_priority administrative_priority
973: FROM
974: igs_ss_en_sua_dtls_v sua,
975: igs_en_su_attempt sua1,
976: igs_ca_inst ci
977: WHERE
978: ci.cal_type = sua.cal_type AND
979: ci.sequence_number = sua.ci_sequence_number AND

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 1158: cp_program_cd igs_en_su_attempt.course_cd%TYPE,

1154: l_rec_count NUMBER(15);
1155:
1156: CURSOR cur_call_num (
1157: cp_person_id igs_pe_person.person_id%TYPE,
1158: cp_program_cd igs_en_su_attempt.course_cd%TYPE,
1159: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1160: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS
1161: SELECT sua.call_number
1162: FROM igs_ss_en_sua_dtls_v sua,

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 1395: -- To remove from the cart we need to call the igs_en_su_attempt.delete_row

1391: RETURN;
1392: END IF;
1393:
1394: --
1395: -- To remove from the cart we need to call the igs_en_su_attempt.delete_row
1396: --
1397: OPEN cur_cart(l_person_id, l_primary_code, l_uoo_id);
1398: FETCH cur_cart INTO l_rec_cart;
1399: IF cur_cart%FOUND THEN

Line 1400: igs_en_su_attempt_pkg.delete_row(x_rowid => l_rec_cart.rowid);

1396: --
1397: OPEN cur_cart(l_person_id, l_primary_code, l_uoo_id);
1398: FETCH cur_cart INTO l_rec_cart;
1399: IF cur_cart%FOUND THEN
1400: igs_en_su_attempt_pkg.delete_row(x_rowid => l_rec_cart.rowid);
1401: END IF;
1402: CLOSE cur_cart;
1403:
1404: --Standard check of p_commit.

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;