PACKAGE: APPS.IGS_AS_EXMVNU_SESAVL_PKG

Source

1 package IGS_AS_EXMVNU_SESAVL_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSDI14S.pls 115.4 2002/11/28 23:13:57 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_ID in NUMBER,
6   X_VENUE_CD in VARCHAR2,
7   X_EXAM_CAL_TYPE in VARCHAR2,
8   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
9   X_DT_ALIAS in VARCHAR2,
10   X_DAI_SEQUENCE_NUMBER in NUMBER,
11   X_START_TIME in DATE,
12   X_END_TIME in DATE,
13   X_ESE_ID in NUMBER,
14   X_COMMENTS in VARCHAR2,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ROWID in VARCHAR2,
19   X_VENUE_CD in VARCHAR2,
20   X_EXAM_CAL_TYPE in VARCHAR2,
21   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
22   X_DT_ALIAS in VARCHAR2,
23   X_DAI_SEQUENCE_NUMBER in NUMBER,
24   X_START_TIME in DATE,
25   X_END_TIME in DATE,
26   X_ESE_ID in NUMBER,
27   X_COMMENTS in VARCHAR2
28 );
29 procedure UPDATE_ROW (
30   X_ROWID in VARCHAR2,
31   X_VENUE_CD in VARCHAR2,
32   X_EXAM_CAL_TYPE in VARCHAR2,
33   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
34   X_DT_ALIAS in VARCHAR2,
35   X_DAI_SEQUENCE_NUMBER in NUMBER,
36   X_START_TIME in DATE,
37   X_END_TIME in DATE,
38   X_ESE_ID in NUMBER,
39   X_COMMENTS in VARCHAR2,
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure ADD_ROW (
43   X_ROWID in out NOCOPY VARCHAR2,
44   X_ORG_ID in NUMBER,
45   X_VENUE_CD in VARCHAR2,
46   X_EXAM_CAL_TYPE in VARCHAR2,
47   X_EXAM_CI_SEQUENCE_NUMBER in NUMBER,
48   X_DT_ALIAS in VARCHAR2,
49   X_DAI_SEQUENCE_NUMBER in NUMBER,
50   X_START_TIME in DATE,
51   X_END_TIME in DATE,
52   X_ESE_ID in NUMBER,
53   X_COMMENTS in VARCHAR2,
54   X_MODE in VARCHAR2 default 'R'
55   );
56 procedure DELETE_ROW (
57   X_ROWID in VARCHAR2
58 );
59 
60   FUNCTION Get_PK_For_Validation (
61     x_venue_cd IN VARCHAR2,
62     x_exam_cal_type IN VARCHAR2,
63     x_exam_ci_sequence_number IN NUMBER,
64     x_dt_alias IN VARCHAR2,
65     x_dai_sequence_number IN NUMBER,
66     x_start_time IN DATE,
67     x_end_time IN DATE
68     )RETURN BOOLEAN;
69 
70   PROCEDURE GET_UFK_IGS_AS_EXAM_SESSION (
71     x_ese_id IN NUMBER
72     );
73 
74   PROCEDURE GET_FK_IGS_AS_EXAM_SESSION (
75     x_exam_cal_type IN VARCHAR2,
76     x_exam_ci_sequence_number IN NUMBER,
77     x_dt_alias IN VARCHAR2,
78     x_dai_sequence_number IN NUMBER,
79     x_start_time IN DATE,
80     x_end_time IN DATE
81     );
82 
83   PROCEDURE GET_FK_IGS_GR_VENUE (
84     x_venue_cd IN VARCHAR2
85     );
86 
87 
88 
89 
90 
91 
92 
93 
94 
95 	PROCEDURE Check_Constraints (
96 
97 
98 
99 
100 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
101 
102 
103 
104 
105 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
106 
107 
108 
109 
110 	);
111 
112 
113 
114 
115 
116 
117 
118 
119 
120 PROCEDURE Before_DML (
121 
122 
123 
124 
125     p_action IN VARCHAR2,
126 
127 
128 
129 
130     x_rowid IN  VARCHAR2 DEFAULT NULL,
131     x_org_id IN NUMBER DEFAULT NULL,
132 
133 
134 
135     x_venue_cd IN VARCHAR2 DEFAULT NULL,
136 
137 
138 
139 
140     x_exam_cal_type IN VARCHAR2 DEFAULT NULL,
141 
142 
143 
144 
145     x_exam_ci_sequence_number IN NUMBER DEFAULT NULL,
146 
147 
148 
149 
150     x_dt_alias IN VARCHAR2 DEFAULT NULL,
151 
152 
153 
154 
155     x_dai_sequence_number IN NUMBER DEFAULT NULL,
156 
157 
158 
159 
160     x_start_time IN DATE DEFAULT NULL,
161 
162 
163 
164 
165     x_end_time IN DATE DEFAULT NULL,
166 
167 
168 
169 
170     x_ese_id IN NUMBER DEFAULT NULL,
171 
172 
173 
174 
175     x_comments IN VARCHAR2 DEFAULT NULL,
176 
177 
178 
179 
180     x_creation_date IN DATE DEFAULT NULL,
181 
182 
183 
184 
185     x_created_by IN NUMBER DEFAULT NULL,
186 
187 
188 
189 
190     x_last_update_date IN DATE DEFAULT NULL,
191 
192 
193 
194 
195     x_last_updated_by IN NUMBER DEFAULT NULL,
196 
197 
198 
199 
200     x_last_update_login IN NUMBER DEFAULT NULL
201 
202 
203 
204 
205   ) ;
206 
207 
208 
209 
210 
211 
212 
213 
214 
215 
216 
217 
218 
219 
220 end IGS_AS_EXMVNU_SESAVL_PKG;