1 package IGS_AD_PS_APINTUNTHS_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI22S.pls 115.6 2003/12/03 20:49:02 knag ship $ */
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_HIST_START_DT in DATE,
12 X_HIST_END_DT in DATE,
13 X_HIST_WHO in NUMBER,
14 X_UV_VERSION_NUMBER in NUMBER,
15 X_CAL_TYPE in VARCHAR2,
16 X_CI_SEQUENCE_NUMBER in NUMBER,
17 X_LOCATION_CD in VARCHAR2,
18 X_UNIT_CLASS in VARCHAR2,
19 X_UNIT_MODE in VARCHAR2,
20 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
21 X_ASS_TRACKING_ID in NUMBER,
22 X_RULE_WAIVED_DT in DATE,
23 X_RULE_WAIVED_PERSON_ID in NUMBER,
24 X_SUP_UNIT_CD in VARCHAR2,
25 X_SUP_UV_VERSION_NUMBER in NUMBER,
26 X_MODE in VARCHAR2 default 'R',
27 x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
28 x_adm_ps_appl_inst_unithist_id IN OUT NOCOPY NUMBER
29 );
30 procedure LOCK_ROW (
31 X_ROWID in VARCHAR2,
32 X_PERSON_ID in NUMBER,
33 X_ADMISSION_APPL_NUMBER in NUMBER,
34 X_NOMINATED_COURSE_CD in VARCHAR2,
35 X_ACAI_SEQUENCE_NUMBER in NUMBER,
36 X_UNIT_CD in VARCHAR2,
37 X_HIST_START_DT in DATE,
38 X_HIST_END_DT in DATE,
39 X_HIST_WHO in NUMBER,
40 X_UV_VERSION_NUMBER in NUMBER,
41 X_CAL_TYPE in VARCHAR2,
42 X_CI_SEQUENCE_NUMBER in NUMBER,
43 X_LOCATION_CD in VARCHAR2,
44 X_UNIT_CLASS in VARCHAR2,
45 X_UNIT_MODE in VARCHAR2,
46 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
47 X_ASS_TRACKING_ID in NUMBER,
48 X_RULE_WAIVED_DT in DATE,
49 X_RULE_WAIVED_PERSON_ID in NUMBER,
50 X_SUP_UNIT_CD in VARCHAR2,
51 X_SUP_UV_VERSION_NUMBER in NUMBER,
52 x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
53 x_adm_ps_appl_inst_unithist_id IN NUMBER DEFAULT NULL
54 );
55 procedure UPDATE_ROW (
56 X_ROWID in VARCHAR2,
57 X_PERSON_ID in NUMBER,
58 X_ADMISSION_APPL_NUMBER in NUMBER,
59 X_NOMINATED_COURSE_CD in VARCHAR2,
60 X_ACAI_SEQUENCE_NUMBER in NUMBER,
61 X_UNIT_CD in VARCHAR2,
62 X_HIST_START_DT in DATE,
63 X_HIST_END_DT in DATE,
64 X_HIST_WHO in NUMBER,
65 X_UV_VERSION_NUMBER in NUMBER,
66 X_CAL_TYPE in VARCHAR2,
67 X_CI_SEQUENCE_NUMBER in NUMBER,
68 X_LOCATION_CD in VARCHAR2,
69 X_UNIT_CLASS in VARCHAR2,
70 X_UNIT_MODE in VARCHAR2,
71 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
72 X_ASS_TRACKING_ID in NUMBER,
73 X_RULE_WAIVED_DT in DATE,
74 X_RULE_WAIVED_PERSON_ID in NUMBER,
75 X_SUP_UNIT_CD in VARCHAR2,
76 X_SUP_UV_VERSION_NUMBER in NUMBER,
77 X_MODE in VARCHAR2 default 'R',
78 x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
79 x_adm_ps_appl_inst_unithist_id IN NUMBER DEFAULT NULL
80 );
81 procedure ADD_ROW (
82 X_ROWID in out NOCOPY VARCHAR2,
83 X_ORG_ID in NUMBER,
84 X_PERSON_ID in NUMBER,
85 X_ADMISSION_APPL_NUMBER in NUMBER,
86 X_NOMINATED_COURSE_CD in VARCHAR2,
87 X_ACAI_SEQUENCE_NUMBER in NUMBER,
88 X_UNIT_CD in VARCHAR2,
89 X_HIST_START_DT in DATE,
90 X_HIST_END_DT in DATE,
91 X_HIST_WHO in NUMBER,
92 X_UV_VERSION_NUMBER in NUMBER,
93 X_CAL_TYPE in VARCHAR2,
94 X_CI_SEQUENCE_NUMBER in NUMBER,
95 X_LOCATION_CD in VARCHAR2,
96 X_UNIT_CLASS in VARCHAR2,
97 X_UNIT_MODE in VARCHAR2,
98 X_ADM_UNIT_OUTCOME_STATUS in VARCHAR2,
99 X_ASS_TRACKING_ID in NUMBER,
100 X_RULE_WAIVED_DT in DATE,
101 X_RULE_WAIVED_PERSON_ID in NUMBER,
102 X_SUP_UNIT_CD in VARCHAR2,
103 X_SUP_UV_VERSION_NUMBER in NUMBER,
104 X_MODE in VARCHAR2 default 'R',
105 x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
106 x_adm_ps_appl_inst_unithist_id IN OUT NOCOPY NUMBER
107 );
108 procedure DELETE_ROW (
109 X_ROWID in VARCHAR2
110 );
111
112 FUNCTION Get_PK_For_Validation (
113 x_adm_ps_appl_inst_unithist_id IN NUMBER
114 )
115 RETURN BOOLEAN;
116
117 FUNCTION Get_UK_For_Validation (
118 x_adm_ps_appl_inst_unit_id IN NUMBER,
119 x_hist_start_dt IN DATE
120 )
121 RETURN BOOLEAN;
122
123 PROCEDURE Check_constraints(
124 Column_Name IN VARCHAR2 DEFAULT NULL,
125 Column_Value IN VARCHAR2 DEFAULT NULL
126 );
127
128 PROCEDURE Before_DML (
129 p_action IN VARCHAR2,
130 x_rowid IN VARCHAR2 DEFAULT NULL,
131 x_org_id in NUMBER DEFAULT NULL,
132 x_person_id IN NUMBER DEFAULT NULL,
133 x_admission_appl_number IN NUMBER DEFAULT NULL,
134 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
135 x_acai_sequence_number IN NUMBER DEFAULT NULL,
136 x_unit_cd IN VARCHAR2 DEFAULT NULL,
137 x_hist_start_dt IN DATE DEFAULT NULL,
138 x_hist_end_dt IN DATE DEFAULT NULL,
139 x_hist_who IN NUMBER DEFAULT NULL,
140 x_uv_version_number IN NUMBER DEFAULT NULL,
141 x_cal_type IN VARCHAR2 DEFAULT NULL,
142 x_ci_sequence_number IN NUMBER DEFAULT NULL,
143 x_location_cd IN VARCHAR2 DEFAULT NULL,
144 x_unit_class IN VARCHAR2 DEFAULT NULL,
145 x_unit_mode IN VARCHAR2 DEFAULT NULL,
146 x_adm_unit_outcome_status IN VARCHAR2 DEFAULT NULL,
147 x_ass_tracking_id IN NUMBER DEFAULT NULL,
148 x_rule_waived_dt IN DATE DEFAULT NULL,
149 x_rule_waived_person_id IN NUMBER DEFAULT NULL,
150 x_sup_unit_cd IN VARCHAR2 DEFAULT NULL,
151 x_sup_uv_version_number IN NUMBER DEFAULT NULL,
152 x_creation_date IN DATE DEFAULT NULL,
153 x_created_by IN NUMBER DEFAULT NULL,
154 x_last_update_date IN DATE DEFAULT NULL,
155 x_last_updated_by IN NUMBER DEFAULT NULL,
156 x_last_update_login IN NUMBER DEFAULT NULL,
157 x_adm_ps_appl_inst_unit_id IN NUMBER DEFAULT NULL,
158 x_adm_ps_appl_inst_unithist_id IN NUMBER DEFAULT NULL
159 ) ;
160
161 end IGS_AD_PS_APINTUNTHS_PKG;