DBA Data[Home] [Help]

APPS.IGS_EN_ENROLL_WLST dependencies on IGS_PS_UNIT_OFR_OPT

Line 8: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,

4:
5: /** Unit - For the Existing Unit validations **/
6:
7: FUNCTION validate_unit (
8: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%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,

Line 9: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,

5: /** Unit - For the Existing Unit validations **/
6:
7: FUNCTION validate_unit (
8: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%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,

Line 10: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,

6:
7: FUNCTION validate_unit (
8: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%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,

Line 11: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,

7: FUNCTION validate_unit (
8: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%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,

Line 12: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

8: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%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,

Line 14: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%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,
18: p_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE)

Line 15: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%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,
18: p_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE)
19:

Line 28: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

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,
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)

Line 40: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

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,
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,

Line 51: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

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,
55: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

Line 52: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

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,
55: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
56: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 55: p_location_cd igs_ps_unit_ofr_opt.location_cd%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,
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,

Line 56: p_unit_class igs_ps_unit_ofr_opt.unit_class%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,
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,

Line 57: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

53: p_cal_type igs_ca_inst.cal_type%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,

Line 69: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

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,
73: p_cal_type igs_ca_inst.cal_type%TYPE,

Line 71: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

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,
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,

Line 72: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

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,
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,

Line 75: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

71: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
72: p_version_number igs_ps_unit_ofr_opt.version_number%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,

Line 76: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

72: p_version_number igs_ps_unit_ofr_opt.version_number%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)

Line 115: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

111: /** The main auto enroll procedure - Called from conc now Also to be called from the TBH of IGSPI085B.pls **/
112:
113: PROCEDURE enroll_from_waitlist (errbuf OUT NOCOPY VARCHAR2,
114: retcode OUT NOCOPY NUMBER,
115: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
116: p_org_id IN NUMBER
117: );
118:
119: FUNCTION get_message (p_messages VARCHAR2,

Line 130: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

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,
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,