DBA Data[Home] [Help]

APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_EN_SU_ATTEMPT

Line 6: p_person_id IN igs_en_su_attempt.person_id%TYPE,

2: /* $Header: IGSEN92S.pls 120.1 2006/08/24 07:25:32 bdeviset noship $ */
3:
4:
5: PROCEDURE reorder_drop_units (
6: p_person_id IN igs_en_su_attempt.person_id%TYPE,
7: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
9: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
10: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,

Line 7: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

3:
4:
5: PROCEDURE reorder_drop_units (
6: p_person_id IN igs_en_su_attempt.person_id%TYPE,
7: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
9: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
10: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,
11: p_selected_uoo_ids IN VARCHAR2,

Line 8: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

4:
5: PROCEDURE reorder_drop_units (
6: p_person_id IN igs_en_su_attempt.person_id%TYPE,
7: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
9: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
10: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,
11: p_selected_uoo_ids IN VARCHAR2,
12: p_ret_all_uoo_ids OUT NOCOPY VARCHAR2,

Line 18: p_person_id IN igs_en_su_attempt.person_id%TYPE,

14: p_ret_nonsub_uoo_ids OUT NOCOPY VARCHAR2
15: );
16:
17: PROCEDURE create_ss_warning (
18: p_person_id IN igs_en_su_attempt.person_id%TYPE,
19: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
20: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
21: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
22: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

Line 19: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

15: );
16:
17: PROCEDURE create_ss_warning (
18: p_person_id IN igs_en_su_attempt.person_id%TYPE,
19: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
20: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
21: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
22: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
23: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,

Line 22: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

18: p_person_id IN igs_en_su_attempt.person_id%TYPE,
19: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
20: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
21: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
22: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
23: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
24: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
25: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
26: p_message_rule_text IN VARCHAR2,

Line 51: p_person_id IN igs_en_su_attempt.person_id%TYPE,

47: p_ss_session_id IN NUMBER
48: );
49:
50: FUNCTION update_dropped_units (
51: p_person_id IN igs_en_su_attempt.person_id%TYPE,
52: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
53: p_uoo_ids IN VARCHAR2,
54: p_discontinuation_reason_cd IN VARCHAR2
55: )

Line 52: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

48: );
49:
50: FUNCTION update_dropped_units (
51: p_person_id IN igs_en_su_attempt.person_id%TYPE,
52: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
53: p_uoo_ids IN VARCHAR2,
54: p_discontinuation_reason_cd IN VARCHAR2
55: )
56: RETURN VARCHAR2;

Line 58: p_person_id IN igs_en_su_attempt.person_id%TYPE,

54: p_discontinuation_reason_cd IN VARCHAR2
55: )
56: RETURN VARCHAR2;
57: FUNCTION update_dropped_units (
58: p_person_id IN igs_en_su_attempt.person_id%TYPE,
59: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
60: p_uoo_ids IN VARCHAR2,
61: p_discontinuation_reason_cd IN VARCHAR2,
62: p_admin_unit_status IN VARCHAR2

Line 59: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

55: )
56: RETURN VARCHAR2;
57: FUNCTION update_dropped_units (
58: p_person_id IN igs_en_su_attempt.person_id%TYPE,
59: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
60: p_uoo_ids IN VARCHAR2,
61: p_discontinuation_reason_cd IN VARCHAR2,
62: p_admin_unit_status IN VARCHAR2
63: )