1 PACKAGE igs_pr_stdnt_pr_ou_be_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSPR35S.pls 115.0 2002/10/04 14:31:06 ddey noship $ */
3
4 /*************************************************************
5 Created By :Deepankar Dey
6 Date Created on : 21-Sept-2002
7 Purpose : After successful Insertion / Updation record , Business Event needs to be raised to send
8 notification to student.The Business Event Package needs to be created, to raise Business
9 Event from different points.
10 Change History
11 Who When What
12
13 (reverse chronological order - newest change first)
14 ***************************************************************/
15
16 PROCEDURE approve_otcm(
17 p_person_id IN NUMBER,
18 p_course_cd IN VARCHAR2,
19 p_sequence_number IN NUMBER,
20 p_decision_status IN VARCHAR2,
21 p_decision_dt IN VARCHAR2,
22 p_progression_outcome_type IN VARCHAR2,
23 p_description IN VARCHAR2,
24 p_appeal_expiry_dt IN VARCHAR2,
25 p_show_cause_expiry_dt IN VARCHAR2
26 );
27
28
29
30
31 PROCEDURE apply_positive_otcm(
32 p_person_id IN NUMBER,
33 p_course_cd IN VARCHAR2,
34 p_sequence_number IN NUMBER,
35 p_decision_status IN VARCHAR2,
36 p_decision_dt IN VARCHAR2,
37 p_progression_outcome_type IN VARCHAR2,
38 p_description IN VARCHAR2,
39 p_applied_dt IN VARCHAR2
40 );
41
42
43
44 PROCEDURE apply_otcm(
45 p_person_id IN NUMBER,
46 p_course_cd IN VARCHAR2,
47 p_sequence_number IN NUMBER,
48 p_decision_status IN VARCHAR2,
49 p_decision_dt IN VARCHAR2,
50 p_progression_outcome_type IN VARCHAR2,
51 p_appeal_expiry_dt IN VARCHAR2,
52 p_show_cause_expiry_dt IN VARCHAR2,
53 p_applied_dt IN VARCHAR2,
54 p_description IN VARCHAR2
55 );
56
57
58
59 PROCEDURE show_cause_uph_dsm(
60 p_person_id IN NUMBER,
61 p_course_cd IN VARCHAR2,
62 p_sequence_number IN NUMBER,
63 p_decision_status IN VARCHAR2,
64 p_decision_dt IN VARCHAR2,
65 p_progression_outcome_type IN VARCHAR2,
66 p_description IN VARCHAR2,
67 p_applied_dt IN VARCHAR2,
68 p_show_cause_dt IN VARCHAR2,
69 p_show_cause_outcome_dt IN VARCHAR2,
70 p_show_cause_outcome_type IN VARCHAR2
71 );
72
73
74
75 PROCEDURE appeal_uph_dsm(
76 p_person_id IN NUMBER,
77 p_course_cd IN VARCHAR2,
78 p_sequence_number IN NUMBER,
79 p_decision_status IN VARCHAR2,
80 p_decision_dt IN VARCHAR2,
81 p_progression_outcome_type IN VARCHAR2,
82 p_description IN VARCHAR2,
83 p_applied_dt IN VARCHAR2,
84 p_appeal_dt IN VARCHAR2,
85 p_appeal_outcome_dt IN VARCHAR2,
86 p_appeal_outcome_type IN VARCHAR2
87 );
88
89
90
91 PROCEDURE remove_waive_cancel_otcm(
92 p_person_id IN NUMBER,
93 p_course_cd IN VARCHAR2,
94 p_sequence_number IN NUMBER,
95 p_decision_status IN VARCHAR2,
96 p_decision_dt IN VARCHAR2,
97 p_progression_outcome_type IN VARCHAR2,
98 p_applied_dt IN VARCHAR2 ,
99 p_description IN VARCHAR2
100 );
101
102
103 END igs_pr_stdnt_pr_ou_be_pkg;