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_ENROLL_WLST dependencies on IGS_EN_SU_ATTEMPT

Line 13: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,

9: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
10: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
11: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
12: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
13: p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
14: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
15: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
16: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
17: p_deny_warn OUT NOCOPY VARCHAR2,

Line 18: p_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE)

14: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
15: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
16: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
17: p_deny_warn OUT NOCOPY VARCHAR2,
18: p_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE)
19:
20: RETURN BOOLEAN;
21:
22:

Line 25: p_person_id igs_en_su_attempt.person_id%TYPE,

21:
22:
23: /** Program - For the validations Programs **/
24: FUNCTION validate_prog (
25: p_person_id igs_en_su_attempt.person_id%TYPE,
26: p_cal_type igs_ca_inst.cal_type%TYPE,
27: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
28: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
29: p_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 29: p_course_cd igs_en_su_attempt.course_cd%TYPE,

25: p_person_id igs_en_su_attempt.person_id%TYPE,
26: p_cal_type igs_ca_inst.cal_type%TYPE,
27: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
28: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
29: p_course_cd igs_en_su_attempt.course_cd%TYPE,
30: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
31: p_message_name OUT NOCOPY VARCHAR2,
32: p_deny_warn OUT NOCOPY VARCHAR2)
33: RETURN BOOLEAN;

Line 30: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

26: p_cal_type igs_ca_inst.cal_type%TYPE,
27: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
28: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
29: p_course_cd igs_en_su_attempt.course_cd%TYPE,
30: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
31: p_message_name OUT NOCOPY VARCHAR2,
32: p_deny_warn OUT NOCOPY VARCHAR2)
33: RETURN BOOLEAN;
34:

Line 37: p_person_id igs_en_su_attempt.person_id%TYPE,

33: RETURN BOOLEAN;
34:
35: /** Unit Steps - For the validations Unit Steps **/
36: FUNCTION validate_unit_steps(
37: p_person_id igs_en_su_attempt.person_id%TYPE,
38: p_cal_type igs_ca_inst.cal_type%TYPE,
39: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
40: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
41: p_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 41: p_course_cd igs_en_su_attempt.course_cd%TYPE,

37: p_person_id igs_en_su_attempt.person_id%TYPE,
38: p_cal_type igs_ca_inst.cal_type%TYPE,
39: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
40: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
41: p_course_cd igs_en_su_attempt.course_cd%TYPE,
42: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
43: p_message_name OUT NOCOPY VARCHAR2,
44: p_deny_warn OUT NOCOPY VARCHAR2,
45: p_calling_obj IN VARCHAR2)

Line 42: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

38: p_cal_type igs_ca_inst.cal_type%TYPE,
39: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
40: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
41: p_course_cd igs_en_su_attempt.course_cd%TYPE,
42: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
43: p_message_name OUT NOCOPY VARCHAR2,
44: p_deny_warn OUT NOCOPY VARCHAR2,
45: p_calling_obj IN VARCHAR2)
46: RETURN BOOLEAN;

Line 50: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

46: RETURN BOOLEAN;
47:
48: /** For Combined validations for Unit Steps and Units - Not used in this package for external use**/
49: FUNCTION validate_combined_unit(
50: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
51: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
52: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
53: p_cal_type igs_ca_inst.cal_type%TYPE,
54: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

Line 58: p_course_cd igs_en_su_attempt.course_cd%TYPE,

54: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
55: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
56: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
57: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
58: p_course_cd igs_en_su_attempt.course_cd%TYPE,
59: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
60: p_message_name OUT NOCOPY VARCHAR2,
61: p_deny_warn OUT NOCOPY VARCHAR2,
62: p_calling_obj IN VARCHAR2)

Line 59: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

55: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
56: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
57: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
58: p_course_cd igs_en_su_attempt.course_cd%TYPE,
59: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
60: p_message_name OUT NOCOPY VARCHAR2,
61: p_deny_warn OUT NOCOPY VARCHAR2,
62: p_calling_obj IN VARCHAR2)
63: RETURN BOOLEAN;

Line 68: p_person_id igs_en_su_attempt.person_id%TYPE,

64:
65:
66: /** Finalize Unit - For All the validations - Unit , Unit Steps , Program **/
67: FUNCTION finalize_unit (
68: p_person_id igs_en_su_attempt.person_id%TYPE,
69: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
70: p_called_from_wlst VARCHAR2,
71: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
72: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

Line 77: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

73: p_cal_type igs_ca_inst.cal_type%TYPE,
74: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
75: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
76: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
77: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
78: p_course_cd igs_en_su_attempt.course_cd%TYPE,
79: p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,
80: p_message_name OUT NOCOPY VARCHAR2)
81: RETURN BOOLEAN;

Line 78: p_course_cd igs_en_su_attempt.course_cd%TYPE,

74: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
75: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
76: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
77: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
78: p_course_cd igs_en_su_attempt.course_cd%TYPE,
79: p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,
80: p_message_name OUT NOCOPY VARCHAR2)
81: RETURN BOOLEAN;
82:

Line 79: p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,

75: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
76: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
77: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
78: p_course_cd igs_en_su_attempt.course_cd%TYPE,
79: p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,
80: p_message_name OUT NOCOPY VARCHAR2)
81: RETURN BOOLEAN;
82:
83: /**************************Declaration of globally used PL-SQL Tables *****/

Line 87: RECORD (person_id igs_en_su_attempt.person_id%TYPE,

83: /**************************Declaration of globally used PL-SQL Tables *****/
84:
85: TYPE rec_succ_mail
86: IS
87: RECORD (person_id igs_en_su_attempt.person_id%TYPE,
88: course_cd igs_en_su_attempt.course_cd%TYPE);
89:
90: TYPE tab_succ_mail
91: IS

Line 88: course_cd igs_en_su_attempt.course_cd%TYPE);

84:
85: TYPE rec_succ_mail
86: IS
87: RECORD (person_id igs_en_su_attempt.person_id%TYPE,
88: course_cd igs_en_su_attempt.course_cd%TYPE);
89:
90: TYPE tab_succ_mail
91: IS
92: TABLE OF rec_succ_mail

Line 99: RECORD (person_id igs_en_su_attempt.person_id%TYPE,

95:
96:
97: TYPE rec_fail_mail
98: IS
99: RECORD (person_id igs_en_su_attempt.person_id%TYPE,
100: course_cd igs_en_su_attempt.course_cd%TYPE,
101: message_name fnd_new_messages.message_name%TYPE);
102:
103: TYPE tab_fail_mail

Line 100: course_cd igs_en_su_attempt.course_cd%TYPE,

96:
97: TYPE rec_fail_mail
98: IS
99: RECORD (person_id igs_en_su_attempt.person_id%TYPE,
100: course_cd igs_en_su_attempt.course_cd%TYPE,
101: message_name fnd_new_messages.message_name%TYPE);
102:
103: TYPE tab_fail_mail
104: IS

Line 127: p_person_id IN igs_en_su_attempt.person_id%TYPE,

123: FUNCTION get_message_count(p_messages IN VARCHAR2)
124: RETURN NUMBER;
125:
126: PROCEDURE ss_eval_min_or_max_cp(
127: p_person_id IN igs_en_su_attempt.person_id%TYPE,
128: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
129: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
130: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
131: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,

Line 131: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,

127: p_person_id IN igs_en_su_attempt.person_id%TYPE,
128: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
129: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
130: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
131: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
132: p_step_type IN igs_en_cpd_ext.s_enrolment_step_type%TYPE,
133: p_credit_points IN NUMBER,
134: p_message_name OUT NOCOPY VARCHAR2,
135: p_deny_warn OUT NOCOPY VARCHAR2,