1 package IGS_AD_PS_APLINSTUNT_PKG as
2 /* $Header: IGSAI20S.pls 120.0 2005/06/01 13:22:53 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_ORG_ID in NUMBER,
6 X_PERSON_ID in NUMBER,
7 X_ADMISSION_APPL_NUMBER in NUMBER,
8 X_NOMINATED_COURSE_CD in VARCHAR2,
9 X_ACAI_SEQUENCE_NUMBER in NUMBER,
10 X_UNIT_CD in VARCHAR2,
11 X_UV_VERSION_NUMBER in NUMBER,
12 X_CAL_TYPE in VARCHAR2,
13 X_CI_SEQUENCE_NUMBER in NUMBER,
14 X_LOCATION_CD in VARCHAR2,
15 X_UNIT_CLASS in VARCHAR2,
16 X_UNIT_MODE in VARCHAR2,
17 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
18 X_ASS_TRACKING_ID in NUMBER,
19 X_RULE_WAIVED_DT in DATE,
20 X_RULE_WAIVED_PERSON_ID in NUMBER,
21 X_SUP_UNIT_CD in VARCHAR2,
22 X_SUP_UV_VERSION_NUMBER in NUMBER,
23 X_MODE in VARCHAR2 default 'R',
24 X_ADM_PS_APPL_INST_UNIT_ID in out NOCOPY NUMBER
25 );
26 procedure LOCK_ROW (
27 X_ROWID in VARCHAR2,
28 X_PERSON_ID in NUMBER,
29 X_ADMISSION_APPL_NUMBER in NUMBER,
30 X_NOMINATED_COURSE_CD in VARCHAR2,
31 X_ACAI_SEQUENCE_NUMBER in NUMBER,
32 X_UNIT_CD in VARCHAR2,
33 X_UV_VERSION_NUMBER in NUMBER,
34 X_CAL_TYPE in VARCHAR2,
35 X_CI_SEQUENCE_NUMBER in NUMBER,
36 X_LOCATION_CD in VARCHAR2,
37 X_UNIT_CLASS in VARCHAR2,
38 X_UNIT_MODE in VARCHAR2,
39 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
40 X_ASS_TRACKING_ID in NUMBER,
41 X_RULE_WAIVED_DT in DATE,
42 X_RULE_WAIVED_PERSON_ID in NUMBER,
43 X_SUP_UNIT_CD in VARCHAR2,
44 X_SUP_UV_VERSION_NUMBER in NUMBER,
45 X_ADM_PS_APPL_INST_UNIT_ID in NUMBER DEFAULT NULL
46 );
47 procedure UPDATE_ROW (
48 X_ROWID in VARCHAR2,
49 X_PERSON_ID in NUMBER,
50 X_ADMISSION_APPL_NUMBER in NUMBER,
51 X_NOMINATED_COURSE_CD in VARCHAR2,
52 X_ACAI_SEQUENCE_NUMBER in NUMBER,
53 X_UNIT_CD in VARCHAR2,
54 X_UV_VERSION_NUMBER in NUMBER,
55 X_CAL_TYPE in VARCHAR2,
56 X_CI_SEQUENCE_NUMBER in NUMBER,
57 X_LOCATION_CD in VARCHAR2,
58 X_UNIT_CLASS in VARCHAR2,
59 X_UNIT_MODE in VARCHAR2,
60 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
61 X_ASS_TRACKING_ID in NUMBER,
62 X_RULE_WAIVED_DT in DATE,
63 X_RULE_WAIVED_PERSON_ID in NUMBER,
64 X_SUP_UNIT_CD in VARCHAR2,
65 X_SUP_UV_VERSION_NUMBER in NUMBER,
66 X_MODE in VARCHAR2 default 'R',
67 X_ADM_PS_APPL_INST_UNIT_ID in NUMBER DEFAULT NULL
68 );
69 procedure ADD_ROW (
70 X_ROWID in out NOCOPY VARCHAR2,
71 X_ORG_ID in NUMBER,
72 X_PERSON_ID in NUMBER,
73 X_ADMISSION_APPL_NUMBER in NUMBER,
74 X_NOMINATED_COURSE_CD in VARCHAR2,
75 X_ACAI_SEQUENCE_NUMBER in NUMBER,
76 X_UNIT_CD in VARCHAR2,
77 X_UV_VERSION_NUMBER in NUMBER,
78 X_CAL_TYPE in VARCHAR2,
79 X_CI_SEQUENCE_NUMBER in NUMBER,
80 X_LOCATION_CD in VARCHAR2,
81 X_UNIT_CLASS in VARCHAR2,
82 X_UNIT_MODE in VARCHAR2,
83 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
84 X_ASS_TRACKING_ID in NUMBER,
85 X_RULE_WAIVED_DT in DATE,
86 X_RULE_WAIVED_PERSON_ID in NUMBER,
87 X_SUP_UNIT_CD in VARCHAR2,
88 X_SUP_UV_VERSION_NUMBER in NUMBER,
89 X_MODE in VARCHAR2 default 'R',
90 X_ADM_PS_APPL_INST_UNIT_ID in out NOCOPY NUMBER
91 );
92 procedure DELETE_ROW (
93 X_ROWID in VARCHAR2,
94 x_mode IN VARCHAR2 DEFAULT 'R'
95 );
96
97 FUNCTION Get_PK_For_Validation (
98 x_adm_ps_appl_inst_unit_id IN NUMBER
99 )
100 RETURN BOOLEAN;
101
102 FUNCTION Get_UK_For_Validation (
103 x_person_id IN NUMBER,
104 x_admission_appl_number IN NUMBER,
105 x_nominated_course_cd IN VARCHAR2,
106 x_acai_sequence_number IN NUMBER,
107 x_unit_cd IN VARCHAR2,
108 x_uv_version_number IN NUMBER ,
109 x_cal_type IN VARCHAR2 ,
110 x_ci_sequence_number IN NUMBER ,
111 x_location_cd IN VARCHAR2 ,
112 x_unit_class IN VARCHAR2
113 )
114 RETURN BOOLEAN;
115
116 Procedure Check_constraints(
117 Column_Name IN VARCHAR2 DEFAULT NULL,
118 Column_Value IN VARCHAR2 DEFAULT NULL
119 );
120
121 PROCEDURE Before_DML (
122 p_action IN VARCHAR2,
123 x_rowid IN VARCHAR2 DEFAULT NULL,
124 x_org_id IN NUMBER DEFAULT NULL,
125 x_person_id IN NUMBER DEFAULT NULL,
126 x_admission_appl_number IN NUMBER DEFAULT NULL,
127 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
128 x_acai_sequence_number IN NUMBER DEFAULT NULL,
129 x_unit_cd IN VARCHAR2 DEFAULT NULL,
130 x_uv_version_number IN NUMBER DEFAULT NULL,
131 x_cal_type IN VARCHAR2 DEFAULT NULL,
132 x_ci_sequence_number IN NUMBER DEFAULT NULL,
133 x_location_cd IN VARCHAR2 DEFAULT NULL,
134 x_unit_class IN VARCHAR2 DEFAULT NULL,
135 x_unit_mode IN VARCHAR2 DEFAULT NULL,
136 x_adm_unit_outcome_status IN VARCHAR2 DEFAULT NULL,
137 x_ass_tracking_id IN NUMBER DEFAULT NULL,
138 x_rule_waived_dt IN DATE DEFAULT NULL,
139 x_rule_waived_person_id IN NUMBER DEFAULT NULL,
140 x_sup_unit_cd IN VARCHAR2 DEFAULT NULL,
141 x_sup_uv_version_number IN NUMBER DEFAULT NULL,
142 x_creation_date IN DATE DEFAULT NULL,
143 x_created_by IN NUMBER DEFAULT NULL,
144 x_last_update_date IN DATE DEFAULT NULL,
145 x_last_updated_by IN NUMBER DEFAULT NULL,
146 x_last_update_login IN NUMBER DEFAULT NULL,
147 x_adm_ps_appl_inst_unit_id in NUMBER DEFAULT NULL
148 );
149
150 PROCEDURE GET_FK_IGS_AD_PS_APPL_INST (
151 x_person_id IN NUMBER,
152 x_admission_appl_number IN NUMBER,
153 x_nominated_course_cd IN VARCHAR2,
154 x_sequence_number IN NUMBER
155 );
156
157 PROCEDURE GET_FK_IGS_AD_UNIT_OU_STAT (
158 x_adm_unit_outcome_status IN VARCHAR2
159 );
160
161 PROCEDURE GET_FK_IGS_AD_LOCATION (
162 x_location_cd IN VARCHAR2
163 );
164
165 PROCEDURE GET_FK_IGS_PE_PERSON (
166 x_person_id IN NUMBER
167 );
168
169 PROCEDURE GET_FK_IGS_PS_UNIT_VER (
170 x_unit_cd IN VARCHAR2,
171 x_version_number IN NUMBER
172 );
173
174 PROCEDURE GET_FK_IGS_TR_ITEM (
175 x_tracking_id IN VARCHAR2
176 );
177
178 PROCEDURE GET_FK_IGS_AS_UNIT_MODE (
179 x_unit_mode IN VARCHAR2
180 );
181
182 PROCEDURE GET_FK_IGS_PS_UNIT_OFR_OPT (
183 x_unit_cd IN VARCHAR2,
184 x_version_number IN NUMBER,
185 x_cal_type IN VARCHAR2,
186 x_ci_sequence_number IN NUMBER,
187 x_location_cd IN VARCHAR2,
188 x_unit_class IN VARCHAR2
189 );
190
191 PROCEDURE GET_FK_IGS_PS_UNIT_OFR_PAT (
192 x_unit_cd IN VARCHAR2,
193 x_version_number IN NUMBER,
194 x_cal_type IN VARCHAR2,
195 x_ci_sequence_number IN NUMBER
196 );
197 end IGS_AD_PS_APLINSTUNT_PKG;