APPS.IGS_EN_GEN_017 dependencies on IGS_PE_PERSON

Line 54: l_person_id igs_pe_person_base_v.person_id%TYPE;

50: || svanukur 16-jun-2003 implemented the check for unit section status of 'NOT_OFFERED'
51: || as part of validation impact CR ENCR034.
52: || (reverse chronological order - newest change first)
53: */
54: l_person_id igs_pe_person_base_v.person_id%TYPE;
55: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
56: l_cal_type igs_ca_inst.cal_type%TYPE;
57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_primary_code igs_ps_ver.course_cd%TYPE;

Line 352: l_person_id igs_pe_person.person_id%TYPE;

348: || Known limitations, enhancements or remarks :
349: || Change History :
350: || Who When What
351: */
352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;

Line 353: l_person_type igs_pe_person_types.person_type_code%TYPE;

349: || Change History :
350: || Who When What
351: */
352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

Line 372: CURSOR cur_uoo_id (cp_person_id igs_pe_person.person_id%TYPE,

368: l_return_status VARCHAR2(10) := NULL;
369: l_message_count NUMBER := NULL;
370: l_message_data VARCHAR2(1000);
371:
372: CURSOR cur_uoo_id (cp_person_id igs_pe_person.person_id%TYPE,
373: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
374: cp_cal_type igs_ca_inst.cal_type%TYPE,
375: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS
376: SELECT uoo_id

Line 958: l_person_id igs_pe_person.person_id%TYPE;

954: ******************************************************************************************/
955:
956: IS
957: -- local variables
958: l_person_id igs_pe_person.person_id%TYPE;
959: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
960: l_error_message VARCHAR2(2000);
961: l_ret_status VARCHAR2(10);
962: l_primary_program_code igs_ps_ver.course_cd%TYPE;

Line 1103: CURSOR c_vld_person (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS

1099: IS
1100: /*
1101: cursor to validate if person number is valid in the system
1102: */
1103: CURSOR c_vld_person (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS
1104: SELECT person_id
1105: FROM igs_pe_person_base_v
1106: WHERE person_number = cp_person_number;
1107: l_vld_person_id igs_pe_person_base_v.person_id%TYPE;

Line 1105: FROM igs_pe_person_base_v

1101: cursor to validate if person number is valid in the system
1102: */
1103: CURSOR c_vld_person (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS
1104: SELECT person_id
1105: FROM igs_pe_person_base_v
1106: WHERE person_number = cp_person_number;
1107: l_vld_person_id igs_pe_person_base_v.person_id%TYPE;
1108:
1109: /*

Line 1107: l_vld_person_id igs_pe_person_base_v.person_id%TYPE;

1103: CURSOR c_vld_person (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS
1104: SELECT person_id
1105: FROM igs_pe_person_base_v
1106: WHERE person_number = cp_person_number;
1107: l_vld_person_id igs_pe_person_base_v.person_id%TYPE;
1108:
1109: /*
1110: cursor to validate that person is valid apps user in system
1111: */

Line 1112: CURSOR c_vld_fnd_user (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1108:
1109: /*
1110: cursor to validate that person is valid apps user in system
1111: */
1112: CURSOR c_vld_fnd_user (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1113: SELECT user_id
1114: FROM fnd_user
1115: WHERE person_party_id = cp_person_id;
1116: l_vld_fnd_user_id fnd_user.user_id%TYPE;

Line 1121: CURSOR c_vld_student (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1117:
1118: /*
1119: cursor to validate that the person number is a valid 'STUDENT' in the system
1120: */
1121: CURSOR c_vld_student (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1122: SELECT person_type_code
1123: FROM igs_pe_typ_instances
1124: WHERE person_id = cp_person_id
1125: AND ( end_date IS NULL OR end_date > SYSDATE )

Line 1128: FROM igs_pe_person_types

1124: WHERE person_id = cp_person_id
1125: AND ( end_date IS NULL OR end_date > SYSDATE )
1126: AND person_type_code IN (
1127: SELECT person_type_code
1128: FROM igs_pe_person_types
1129: WHERE system_type = 'STUDENT'
1130: AND closed_ind = 'N'
1131: );
1132: l_person_type igs_pe_typ_instances.person_type_code%TYPE;