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_CA_INST

Line 169: l_cal_type igs_ca_inst.cal_type%TYPE;

165: l_api_name VARCHAR2(30) := 'ENROLL_CART';
166:
167: l_person_id igs_pe_person_base_v.person_id%TYPE;
168: l_person_type igs_pe_typ_instances.person_type_code%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;

Line 170: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

166:
167: l_person_id igs_pe_person_base_v.person_id%TYPE;
168: l_person_type igs_pe_typ_instances.person_type_code%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);

Line 436: l_cal_type igs_ca_inst.cal_type%TYPE;

432: l_return_status VARCHAR2(10);
433:
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;

Line 437: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

433:
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:

Line 806: l_cal_type igs_ca_inst.cal_type%TYPE;

802: l_api_name CONSTANT VARCHAR2(30) := 'PERSON_STEPS';
803:
804: l_person_id igs_pe_person_base_v.person_id%TYPE;
805: l_person_type igs_pe_typ_instances.person_type_code%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;

Line 807: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

803:
804: l_person_id igs_pe_person_base_v.person_id%TYPE;
805: l_person_type igs_pe_typ_instances.person_type_code%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);

Line 947: l_cal_type igs_ca_inst.cal_type%TYPE;

943: l_return_status VARCHAR2(10);
944:
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;

Line 948: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

944:
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);

Line 958: cp_load_cal_type igs_ca_inst.cal_type%TYPE,

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
962: sua.unit_cd unit_code ,

Line 959: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

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
962: sua.unit_cd unit_code ,
963: sua1.unit_class unit_class ,

Line 976: igs_ca_inst ci

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
980: sua.person_id = cp_person_id AND

Line 1149: l_cal_type igs_ca_inst.cal_type%TYPE;

1145: l_return_status VARCHAR2(10);
1146:
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;

Line 1150: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1146:
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);

Line 1159: cp_load_cal_type igs_ca_inst.cal_type%TYPE,

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,
1163: igs_ca_inst ci

Line 1160: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS

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,
1163: igs_ca_inst ci
1164: WHERE

Line 1163: igs_ca_inst ci

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,
1163: igs_ca_inst ci
1164: WHERE
1165: ci.cal_type = sua.cal_type AND
1166: ci.sequence_number = sua.ci_sequence_number AND
1167: sua.person_id = cp_person_id AND

Line 1318: l_cal_type igs_ca_inst.cal_type%TYPE;

1314: l_return_status VARCHAR2(10);
1315:
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;

Line 1319: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1315:
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);

Line 1476: l_cal_type igs_ca_inst.cal_type%TYPE;

1472: l_return_status VARCHAR2(10);
1473:
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;

Line 1477: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1473:
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:

Line 2099: l_cal_type igs_ca_inst.cal_type%TYPE;

2095: */
2096:
2097: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TERM';
2098: l_api_version CONSTANT NUMBER := 1.0;
2099: l_cal_type igs_ca_inst.cal_type%TYPE;
2100: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2101: l_message fnd_new_messages.message_name%TYPE;
2102: l_ret_status VARCHAR2(6);
2103: l_message_count NUMBER;

Line 2100: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2096:
2097: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TERM';
2098: l_api_version CONSTANT NUMBER := 1.0;
2099: l_cal_type igs_ca_inst.cal_type%TYPE;
2100: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2101: l_message fnd_new_messages.message_name%TYPE;
2102: l_ret_status VARCHAR2(6);
2103: l_message_count NUMBER;
2104: l_message_data VARCHAR2(2000);