1 package IGS_AS_SU_SETATMPT_H_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSDI28S.pls 115.6 2002/11/28 23:18:03 nsidana ship $ */
3
4 --
5
6 --
7 procedure INSERT_ROW (
8 X_ROWID in out NOCOPY VARCHAR2,
9 X_ORG_ID in NUMBER,
10 X_PERSON_ID in NUMBER,
11 X_COURSE_CD in VARCHAR2,
12 X_UNIT_SET_CD in VARCHAR2,
13 X_SEQUENCE_NUMBER in NUMBER,
14 X_HIST_START_DT in DATE,
15 X_HIST_END_DT in DATE,
16 X_HIST_WHO in NUMBER,
17 X_US_VERSION_NUMBER in NUMBER,
18 X_SELECTION_DT in DATE,
19 X_STUDENT_CONFIRMED_IND in VARCHAR2,
20 X_END_DT in DATE,
21 X_PARENT_UNIT_SET_CD in VARCHAR2,
22 X_PARENT_SEQUENCE_NUMBER in NUMBER,
23 X_PRIMARY_SET_IND in VARCHAR2,
24 X_VOLUNTARY_END_IND in VARCHAR2,
25 X_AUTHORISED_PERSON_ID in NUMBER,
26 X_AUTHORISED_ON in DATE,
27 X_OVERRIDE_TITLE in VARCHAR2,
28 X_RQRMNTS_COMPLETE_IND in VARCHAR2,
29 X_RQRMNTS_COMPLETE_DT in DATE,
30 X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
31 X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
32 X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL,
33 X_MODE in VARCHAR2 default 'R'
34 );
35 procedure LOCK_ROW (
36 X_ROWID in VARCHAR2,
37 X_PERSON_ID in NUMBER,
38 X_COURSE_CD in VARCHAR2,
39 X_UNIT_SET_CD in VARCHAR2,
40 X_SEQUENCE_NUMBER in NUMBER,
41 X_HIST_START_DT in DATE,
42 X_HIST_END_DT in DATE,
43 X_HIST_WHO in NUMBER,
44 X_US_VERSION_NUMBER in NUMBER,
45 X_SELECTION_DT in DATE,
46 X_STUDENT_CONFIRMED_IND in VARCHAR2,
47 X_END_DT in DATE,
48 X_PARENT_UNIT_SET_CD in VARCHAR2,
49 X_PARENT_SEQUENCE_NUMBER in NUMBER,
50 X_PRIMARY_SET_IND in VARCHAR2,
51 X_VOLUNTARY_END_IND in VARCHAR2,
52 X_AUTHORISED_PERSON_ID in NUMBER,
53 X_AUTHORISED_ON in DATE,
54 X_OVERRIDE_TITLE in VARCHAR2,
55 X_RQRMNTS_COMPLETE_IND in VARCHAR2,
56 X_RQRMNTS_COMPLETE_DT in DATE,
57 X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
58 X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
59 X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL
60 );
61 procedure UPDATE_ROW (
62 X_ROWID in VARCHAR2,
63 X_PERSON_ID in NUMBER,
64 X_COURSE_CD in VARCHAR2,
65 X_UNIT_SET_CD in VARCHAR2,
66 X_SEQUENCE_NUMBER in NUMBER,
67 X_HIST_START_DT in DATE,
68 X_HIST_END_DT in DATE,
69 X_HIST_WHO in NUMBER,
70 X_US_VERSION_NUMBER in NUMBER,
71 X_SELECTION_DT in DATE,
72 X_STUDENT_CONFIRMED_IND in VARCHAR2,
73 X_END_DT in DATE,
74 X_PARENT_UNIT_SET_CD in VARCHAR2,
75 X_PARENT_SEQUENCE_NUMBER in NUMBER,
76 X_PRIMARY_SET_IND in VARCHAR2,
77 X_VOLUNTARY_END_IND in VARCHAR2,
78 X_AUTHORISED_PERSON_ID in NUMBER,
79 X_AUTHORISED_ON in DATE,
80 X_OVERRIDE_TITLE in VARCHAR2,
81 X_RQRMNTS_COMPLETE_IND in VARCHAR2,
82 X_RQRMNTS_COMPLETE_DT in DATE,
83 X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
84 X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
85 X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL,
86 X_MODE in VARCHAR2 default 'R'
87 );
88 procedure ADD_ROW (
89 X_ROWID in out NOCOPY VARCHAR2,
90 X_ORG_ID in NUMBER,
91 X_PERSON_ID in NUMBER,
92 X_COURSE_CD in VARCHAR2,
93 X_UNIT_SET_CD in VARCHAR2,
94 X_SEQUENCE_NUMBER in NUMBER,
95 X_HIST_START_DT in DATE,
96 X_HIST_END_DT in DATE,
97 X_HIST_WHO in NUMBER,
98 X_US_VERSION_NUMBER in NUMBER,
99 X_SELECTION_DT in DATE,
100 X_STUDENT_CONFIRMED_IND in VARCHAR2,
101 X_END_DT in DATE,
102 X_PARENT_UNIT_SET_CD in VARCHAR2,
103 X_PARENT_SEQUENCE_NUMBER in NUMBER,
104 X_PRIMARY_SET_IND in VARCHAR2,
105 X_VOLUNTARY_END_IND in VARCHAR2,
106 X_AUTHORISED_PERSON_ID in NUMBER,
107 X_AUTHORISED_ON in DATE,
108 X_OVERRIDE_TITLE in VARCHAR2,
109 X_RQRMNTS_COMPLETE_IND in VARCHAR2,
110 X_RQRMNTS_COMPLETE_DT in DATE,
111 X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
112 X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
113 X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL,
114 X_MODE in VARCHAR2 default 'R'
115 );
116 procedure DELETE_ROW (
117 X_ROWID in VARCHAR2
118 );
119 FUNCTION Get_PK_For_Validation (
120 x_person_id IN NUMBER,
121 x_course_cd IN VARCHAR2,
122 x_unit_set_cd IN VARCHAR2,
123 x_sequence_number IN NUMBER,
124 x_hist_start_dt IN DATE
125 )RETURN BOOLEAN;
126
127 PROCEDURE Check_Constraints (
128 Column_Name IN VARCHAR2 DEFAULT NULL,
129 Column_Value IN VARCHAR2 DEFAULT NULL
130 );
131
132 PROCEDURE Before_DML (
133 p_action IN VARCHAR2,
134 x_rowid IN VARCHAR2 DEFAULT NULL,
135 x_org_id IN NUMBER DEFAULT NULL,
136 x_person_id IN NUMBER DEFAULT NULL,
137 x_course_cd IN VARCHAR2 DEFAULT NULL,
138 x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
139 x_sequence_number IN NUMBER DEFAULT NULL,
140 x_hist_start_dt IN DATE DEFAULT NULL,
141 x_hist_end_dt IN DATE DEFAULT NULL,
142 x_hist_who IN NUMBER DEFAULT NULL,
143 x_us_version_number IN NUMBER DEFAULT NULL,
144 x_selection_dt IN DATE DEFAULT NULL,
145 x_student_confirmed_ind IN VARCHAR2 DEFAULT NULL,
146 x_end_dt IN DATE DEFAULT NULL,
147 x_parent_unit_set_cd IN VARCHAR2 DEFAULT NULL,
148 x_parent_sequence_number IN NUMBER DEFAULT NULL,
149 x_primary_set_ind IN VARCHAR2 DEFAULT NULL,
150 x_voluntary_end_ind IN VARCHAR2 DEFAULT NULL,
151 x_authorised_person_id IN NUMBER DEFAULT NULL,
152 x_authorised_on IN DATE DEFAULT NULL,
153 x_override_title IN VARCHAR2 DEFAULT NULL,
154 x_rqrmnts_complete_ind IN VARCHAR2 DEFAULT NULL,
155 x_rqrmnts_complete_dt IN DATE DEFAULT NULL,
156 x_s_completed_source_type IN VARCHAR2 DEFAULT NULL,
157 X_CATALOG_CAL_TYPE in VARCHAR2 DEFAULT NULL,
158 X_CATALOG_SEQ_NUM in NUMBER DEFAULT NULL,
159 x_creation_date IN DATE DEFAULT NULL,
160 x_created_by IN NUMBER DEFAULT NULL,
161 x_last_update_date IN DATE DEFAULT NULL,
162 x_last_updated_by IN NUMBER DEFAULT NULL,
163 x_last_update_login IN NUMBER DEFAULT NULL
164 ) ;
165
166
167
168 end IGS_AS_SU_SETATMPT_H_PKG;