1 package IGS_PR_RU_OU_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSQI13S.pls 115.6 2003/02/26 06:59:37 shtatiko ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PROGRESSION_RULE_CAT in VARCHAR2,
6 X_PRA_SEQUENCE_NUMBER in NUMBER,
7 X_SEQUENCE_NUMBER in NUMBER,
8 X_NUMBER_OF_FAILURES in NUMBER,
9 X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
10 X_APPLY_AUTOMATICALLY_IND in VARCHAR2,
11 X_PRG_RULE_REPEAT_FAIL_TYPE in VARCHAR2,
12 X_OVERRIDE_SHOW_CAUSE_IND in VARCHAR2,
13 X_OVERRIDE_APPEAL_IND in VARCHAR2,
14 X_DURATION in NUMBER,
15 X_DURATION_TYPE in VARCHAR2,
16 X_RANK in NUMBER,
17 X_ENCMB_COURSE_GROUP_CD in VARCHAR2,
18 X_RESTRICTED_ENROLMENT_CP in NUMBER,
19 X_RESTRICTED_ATTENDANCE_TYPE in VARCHAR2,
20 X_COMMENTS in VARCHAR2,
21 X_MODE in VARCHAR2 default 'R' ,
22 X_ORG_ID in NUMBER ,
23 -- anilk, bug#2784198
24 X_LOGICAL_DELETE_DT in DATE DEFAULT NULL
25 );
26 procedure LOCK_ROW (
27 X_ROWID in VARCHAR2,
28 X_PROGRESSION_RULE_CAT in VARCHAR2,
29 X_PRA_SEQUENCE_NUMBER in NUMBER,
30 X_SEQUENCE_NUMBER in NUMBER,
31 X_NUMBER_OF_FAILURES in NUMBER,
32 X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
33 X_APPLY_AUTOMATICALLY_IND in VARCHAR2,
34 X_PRG_RULE_REPEAT_FAIL_TYPE in VARCHAR2,
35 X_OVERRIDE_SHOW_CAUSE_IND in VARCHAR2,
36 X_OVERRIDE_APPEAL_IND in VARCHAR2,
37 X_DURATION in NUMBER,
38 X_DURATION_TYPE in VARCHAR2,
39 X_RANK in NUMBER,
40 X_ENCMB_COURSE_GROUP_CD in VARCHAR2,
41 X_RESTRICTED_ENROLMENT_CP in NUMBER,
42 X_RESTRICTED_ATTENDANCE_TYPE in VARCHAR2,
43 X_COMMENTS in VARCHAR2,
44 -- anilk, bug#2784198
45 X_LOGICAL_DELETE_DT in DATE DEFAULT NULL
46 );
47 procedure UPDATE_ROW (
48 X_ROWID in VARCHAR2,
49 X_PROGRESSION_RULE_CAT in VARCHAR2,
50 X_PRA_SEQUENCE_NUMBER in NUMBER,
51 X_SEQUENCE_NUMBER in NUMBER,
52 X_NUMBER_OF_FAILURES in NUMBER,
53 X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
54 X_APPLY_AUTOMATICALLY_IND in VARCHAR2,
55 X_PRG_RULE_REPEAT_FAIL_TYPE in VARCHAR2,
56 X_OVERRIDE_SHOW_CAUSE_IND in VARCHAR2,
57 X_OVERRIDE_APPEAL_IND in VARCHAR2,
58 X_DURATION in NUMBER,
59 X_DURATION_TYPE in VARCHAR2,
60 X_RANK in NUMBER,
61 X_ENCMB_COURSE_GROUP_CD in VARCHAR2,
62 X_RESTRICTED_ENROLMENT_CP in NUMBER,
63 X_RESTRICTED_ATTENDANCE_TYPE in VARCHAR2,
64 X_COMMENTS in VARCHAR2,
65 X_MODE in VARCHAR2 default 'R',
66 -- anilk, bug#2784198
67 X_LOGICAL_DELETE_DT in DATE DEFAULT NULL
68 );
69 procedure ADD_ROW (
70 X_ROWID in out NOCOPY VARCHAR2,
71 X_PROGRESSION_RULE_CAT in VARCHAR2,
72 X_PRA_SEQUENCE_NUMBER in NUMBER,
73 X_SEQUENCE_NUMBER in NUMBER,
74 X_NUMBER_OF_FAILURES in NUMBER,
75 X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
76 X_APPLY_AUTOMATICALLY_IND in VARCHAR2,
77 X_PRG_RULE_REPEAT_FAIL_TYPE in VARCHAR2,
78 X_OVERRIDE_SHOW_CAUSE_IND in VARCHAR2,
79 X_OVERRIDE_APPEAL_IND in VARCHAR2,
80 X_DURATION in NUMBER,
81 X_DURATION_TYPE in VARCHAR2,
82 X_RANK in NUMBER,
83 X_ENCMB_COURSE_GROUP_CD in VARCHAR2,
84 X_RESTRICTED_ENROLMENT_CP in NUMBER,
85 X_RESTRICTED_ATTENDANCE_TYPE in VARCHAR2,
86 X_COMMENTS in VARCHAR2,
87 X_MODE in VARCHAR2 default 'R',
88 X_ORG_ID in NUMBER ,
89 -- anilk, bug#2784198
90 X_LOGICAL_DELETE_DT in DATE DEFAULT NULL
91 );
92
93 FUNCTION Get_PK_For_Validation (
94 x_progression_rule_cat IN VARCHAR2,
95 x_pra_sequence_number IN NUMBER,
96 x_sequence_number IN NUMBER
97 ) RETURN BOOLEAN;
98
99 PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
100 x_attendance_type IN varchar2
101 );
102
103 PROCEDURE GET_FK_IGS_PR_OU_TYPE (
104 x_progression_outcome_type IN VARCHAR2
105 );
106
107 PROCEDURE GET_FK_IGS_PR_RU_APPL (
108 x_progression_rule_cat IN VARCHAR2,
109 x_sequence_number IN NUMBER
110 );
111
112 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
113 x_s_prg_rule_repeat_fail_type IN NUMBER
114 );
115 PROCEDURE Check_Constraints(
116 Column_Name IN VARCHAR2 DEFAULT NULL,
117 Column_Value IN VARCHAR2 DEFAULT NULL
118 );
119 PROCEDURE Before_DML (
120 p_action IN VARCHAR2,
121 x_rowid IN VARCHAR2 DEFAULT NULL,
122 x_progression_rule_cat IN VARCHAR2 DEFAULT NULL,
123 x_pra_sequence_number IN NUMBER DEFAULT NULL,
124 x_sequence_number IN NUMBER DEFAULT NULL,
125 x_number_of_failures IN NUMBER DEFAULT NULL,
126 x_progression_outcome_type IN VARCHAR2 DEFAULT NULL,
127 x_apply_automatically_ind IN VARCHAR2 DEFAULT NULL,
128 x_prg_rule_repeat_fail_type IN VARCHAR2 DEFAULT NULL,
129 x_override_show_cause_ind IN VARCHAR2 DEFAULT NULL,
130 x_override_appeal_ind IN VARCHAR2 DEFAULT NULL,
131 x_duration IN NUMBER DEFAULT NULL,
132 x_duration_type IN VARCHAR2 DEFAULT NULL,
133 x_rank IN NUMBER DEFAULT NULL,
134 x_encmb_course_group_cd IN VARCHAR2 DEFAULT NULL,
135 x_restricted_enrolment_cp IN NUMBER DEFAULT NULL,
136 x_restricted_attendance_type IN VARCHAR2 DEFAULT NULL,
137 x_comments IN VARCHAR2 DEFAULT NULL,
138 x_creation_date IN DATE DEFAULT NULL,
139 x_created_by IN NUMBER DEFAULT NULL,
140 x_last_update_date IN DATE DEFAULT NULL,
141 x_last_updated_by IN NUMBER DEFAULT NULL,
142 x_last_update_login IN NUMBER DEFAULT NULL,
143 X_ORG_ID in NUMBER DEFAULT NULL,
144 -- anilk, bug#2784198
145 X_LOGICAL_DELETE_DT in DATE DEFAULT NULL
146 );
147
148 FUNCTION GET_UK_FOR_VALIDATION( X_progression_rule_cat IN VARCHAR2,
149 X_pra_sequence_number IN NUMBER,
150 X_number_of_failures IN NUMBER,
151 X_prg_rule_repeat_fail_type IN VARCHAR2,
152 X_rank IN NUMBER)
153 RETURN BOOLEAN;
154
155 end IGS_PR_RU_OU_PKG;