1 PACKAGE igs_en_drop_units_api AS
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,
11 p_selected_uoo_ids IN VARCHAR2,
12 p_ret_all_uoo_ids OUT NOCOPY VARCHAR2,
13 p_ret_sub_uoo_ids OUT NOCOPY VARCHAR2,
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,
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,
27 p_message_tokens IN VARCHAR2,
28 p_message_action IN VARCHAR2,
29 p_destination IN IGS_EN_STD_WARNINGS.destination%TYPE,
30 p_parameters IN IGS_EN_STD_WARNINGS.p_parameters%TYPE,
31 p_step_type IN IGS_EN_STD_WARNINGS.step_type%TYPE
32 );
33
34 PROCEDURE drop_ss_unit_attempt (
35 p_person_id IN NUMBER,
36 p_course_cd IN VARCHAR2,
37 p_course_version IN NUMBER ,
38 p_uoo_id IN NUMBER,
39 p_load_cal_type IN VARCHAR2,
40 p_load_sequence_number IN NUMBER,
41 p_dcnt_reason_cd IN VARCHAR2 ,
42 p_admin_unit_status IN VARCHAR2 ,
43 p_effective_date IN DATE ,
44 p_dropped_uooids OUT NOCOPY VARCHAR2,
45 p_return_status OUT NOCOPY VARCHAR2,
46 p_message OUT NOCOPY VARCHAR2,
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 )
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 )
64 RETURN VARCHAR2;
65
66 END igs_en_drop_units_api;
[Home] [Help]