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_PE_PERSON

Line 167: l_person_id igs_pe_person_base_v.person_id%TYPE;

163: || (reverse chronological order - newest change first)
164: */
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;

Line 434: l_person_id igs_pe_person.person_id%TYPE;

430: l_message_data VARCHAR2(1000);
431: l_error_message VARCHAR2(1000);
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;

Line 435: l_person_type igs_pe_person_types.person_type_code%TYPE;

431: l_error_message VARCHAR2(1000);
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;

Line 443: CURSOR cur_sua (cp_person_id igs_pe_person.person_id%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,
445: cp_version_number igs_en_su_attempt.version_number%TYPE)IS
446: SELECT sua.row_id
447: FROM igs_en_su_attempt sua

Line 804: l_person_id igs_pe_person_base_v.person_id%TYPE;

800: */
801:
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;

Line 945: l_person_id igs_pe_person.person_id%TYPE;

941: l_message_data VARCHAR2(1000);
942: l_error_message VARCHAR2(1000);
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;

Line 946: l_person_type igs_pe_person_types.person_type_code%TYPE;

942: l_error_message VARCHAR2(1000);
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;

Line 956: cp_person_id igs_pe_person.person_id%TYPE,

952: l_rec_count NUMBER(15);
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

Line 1147: l_person_id igs_pe_person.person_id%TYPE;

1143: l_message_data VARCHAR2(1000);
1144: l_error_message VARCHAR2(1000);
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;

Line 1148: l_person_type igs_pe_person_types.person_type_code%TYPE;

1144: l_error_message VARCHAR2(1000);
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;

Line 1157: cp_person_id igs_pe_person.person_id%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,
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

Line 1316: l_person_id igs_pe_person.person_id%TYPE;

1312: l_message_data VARCHAR2(1000);
1313: l_error_message VARCHAR2(1000);
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;

Line 1317: l_person_type igs_pe_person_types.person_type_code%TYPE;

1313: l_error_message VARCHAR2(1000);
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;

Line 1326: cp_person_id igs_pe_person.person_id%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,
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

Line 1474: l_person_id igs_pe_person.person_id%TYPE;

1470: l_message_data VARCHAR2(1000);
1471: l_error_message VARCHAR2(1000);
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;

Line 1475: l_person_type igs_pe_person_types.person_type_code%TYPE;

1471: l_error_message VARCHAR2(1000);
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;

Line 1675: l_person_id igs_pe_person.person_id%TYPE;

1671: l_message_data VARCHAR2(1000);
1672: l_error_message VARCHAR2(1000);
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);

Line 1676: l_person_type igs_pe_person_types.person_type_code%TYPE;

1672: l_error_message VARCHAR2(1000);
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:

Line 1682: cp_person_id igs_pe_person.person_id%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,
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

Line 1885: l_person_id igs_pe_person.person_id%TYPE;

1881: l_api_name CONSTANT VARCHAR2(30) := 'validate_person_details';
1882: l_api_version CONSTANT NUMBER := 1.0;
1883:
1884: -- local variables
1885: l_person_id igs_pe_person.person_id%TYPE;
1886: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
1887: l_error_message VARCHAR2(2000):= NULL;
1888: l_ret_status VARCHAR2(10) := 'TRUE';
1889:

Line 1898: CURSOR c_career_mode (lc_person_id igs_pe_person.person_id%TYPE) IS

1894:
1895: /*
1896: cursor to get career mode details
1897: */
1898: CURSOR c_career_mode (lc_person_id igs_pe_person.person_id%TYPE) IS
1899: SELECT course_type,
1900: course_cd,
1901: version_number
1902: FROM igs_en_sca_v

Line 1910: CURSOR c_program_mode (lc_person_id igs_pe_person.person_id%TYPE) IS

1906:
1907: /*
1908: cursor to get program mode details
1909: */
1910: CURSOR c_program_mode (lc_person_id igs_pe_person.person_id%TYPE) IS
1911: SELECT course_type,
1912: course_cd,
1913: version_number
1914: FROM igs_en_sca_v