APPS.HR_CTX_DEL dependencies on HR_CTX_SHD

Line 52: (p_rec in hr_ctx_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_ctx_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: hr_ctx_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: hr_ctx_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in hr_ctx_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in hr_ctx_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in hr_ctx_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in hr_ctx_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => hr_ctx_shd.g_old_rec.view_name

164: hr_ctx_rkd.after_delete
165: (p_context_id
166: => p_rec.context_id
167: ,p_view_name_o
168: => hr_ctx_shd.g_old_rec.view_name
169: ,p_param_1_o
170: => hr_ctx_shd.g_old_rec.param_1
171: ,p_param_2_o
172: => hr_ctx_shd.g_old_rec.param_2

Line 170: => hr_ctx_shd.g_old_rec.param_1

166: => p_rec.context_id
167: ,p_view_name_o
168: => hr_ctx_shd.g_old_rec.view_name
169: ,p_param_1_o
170: => hr_ctx_shd.g_old_rec.param_1
171: ,p_param_2_o
172: => hr_ctx_shd.g_old_rec.param_2
173: ,p_param_3_o
174: => hr_ctx_shd.g_old_rec.param_3

Line 172: => hr_ctx_shd.g_old_rec.param_2

168: => hr_ctx_shd.g_old_rec.view_name
169: ,p_param_1_o
170: => hr_ctx_shd.g_old_rec.param_1
171: ,p_param_2_o
172: => hr_ctx_shd.g_old_rec.param_2
173: ,p_param_3_o
174: => hr_ctx_shd.g_old_rec.param_3
175: ,p_param_4_o
176: => hr_ctx_shd.g_old_rec.param_4

Line 174: => hr_ctx_shd.g_old_rec.param_3

170: => hr_ctx_shd.g_old_rec.param_1
171: ,p_param_2_o
172: => hr_ctx_shd.g_old_rec.param_2
173: ,p_param_3_o
174: => hr_ctx_shd.g_old_rec.param_3
175: ,p_param_4_o
176: => hr_ctx_shd.g_old_rec.param_4
177: ,p_param_5_o
178: => hr_ctx_shd.g_old_rec.param_5

Line 176: => hr_ctx_shd.g_old_rec.param_4

172: => hr_ctx_shd.g_old_rec.param_2
173: ,p_param_3_o
174: => hr_ctx_shd.g_old_rec.param_3
175: ,p_param_4_o
176: => hr_ctx_shd.g_old_rec.param_4
177: ,p_param_5_o
178: => hr_ctx_shd.g_old_rec.param_5
179: ,p_param_6_o
180: => hr_ctx_shd.g_old_rec.param_6

Line 178: => hr_ctx_shd.g_old_rec.param_5

174: => hr_ctx_shd.g_old_rec.param_3
175: ,p_param_4_o
176: => hr_ctx_shd.g_old_rec.param_4
177: ,p_param_5_o
178: => hr_ctx_shd.g_old_rec.param_5
179: ,p_param_6_o
180: => hr_ctx_shd.g_old_rec.param_6
181: ,p_param_7_o
182: => hr_ctx_shd.g_old_rec.param_7

Line 180: => hr_ctx_shd.g_old_rec.param_6

176: => hr_ctx_shd.g_old_rec.param_4
177: ,p_param_5_o
178: => hr_ctx_shd.g_old_rec.param_5
179: ,p_param_6_o
180: => hr_ctx_shd.g_old_rec.param_6
181: ,p_param_7_o
182: => hr_ctx_shd.g_old_rec.param_7
183: ,p_param_8_o
184: => hr_ctx_shd.g_old_rec.param_8

Line 182: => hr_ctx_shd.g_old_rec.param_7

178: => hr_ctx_shd.g_old_rec.param_5
179: ,p_param_6_o
180: => hr_ctx_shd.g_old_rec.param_6
181: ,p_param_7_o
182: => hr_ctx_shd.g_old_rec.param_7
183: ,p_param_8_o
184: => hr_ctx_shd.g_old_rec.param_8
185: ,p_param_9_o
186: => hr_ctx_shd.g_old_rec.param_9

Line 184: => hr_ctx_shd.g_old_rec.param_8

180: => hr_ctx_shd.g_old_rec.param_6
181: ,p_param_7_o
182: => hr_ctx_shd.g_old_rec.param_7
183: ,p_param_8_o
184: => hr_ctx_shd.g_old_rec.param_8
185: ,p_param_9_o
186: => hr_ctx_shd.g_old_rec.param_9
187: ,p_param_10_o
188: => hr_ctx_shd.g_old_rec.param_10

Line 186: => hr_ctx_shd.g_old_rec.param_9

182: => hr_ctx_shd.g_old_rec.param_7
183: ,p_param_8_o
184: => hr_ctx_shd.g_old_rec.param_8
185: ,p_param_9_o
186: => hr_ctx_shd.g_old_rec.param_9
187: ,p_param_10_o
188: => hr_ctx_shd.g_old_rec.param_10
189: ,p_param_11_o
190: => hr_ctx_shd.g_old_rec.param_11

Line 188: => hr_ctx_shd.g_old_rec.param_10

184: => hr_ctx_shd.g_old_rec.param_8
185: ,p_param_9_o
186: => hr_ctx_shd.g_old_rec.param_9
187: ,p_param_10_o
188: => hr_ctx_shd.g_old_rec.param_10
189: ,p_param_11_o
190: => hr_ctx_shd.g_old_rec.param_11
191: ,p_param_12_o
192: => hr_ctx_shd.g_old_rec.param_12

Line 190: => hr_ctx_shd.g_old_rec.param_11

186: => hr_ctx_shd.g_old_rec.param_9
187: ,p_param_10_o
188: => hr_ctx_shd.g_old_rec.param_10
189: ,p_param_11_o
190: => hr_ctx_shd.g_old_rec.param_11
191: ,p_param_12_o
192: => hr_ctx_shd.g_old_rec.param_12
193: ,p_param_13_o
194: => hr_ctx_shd.g_old_rec.param_13

Line 192: => hr_ctx_shd.g_old_rec.param_12

188: => hr_ctx_shd.g_old_rec.param_10
189: ,p_param_11_o
190: => hr_ctx_shd.g_old_rec.param_11
191: ,p_param_12_o
192: => hr_ctx_shd.g_old_rec.param_12
193: ,p_param_13_o
194: => hr_ctx_shd.g_old_rec.param_13
195: ,p_param_14_o
196: => hr_ctx_shd.g_old_rec.param_14

Line 194: => hr_ctx_shd.g_old_rec.param_13

190: => hr_ctx_shd.g_old_rec.param_11
191: ,p_param_12_o
192: => hr_ctx_shd.g_old_rec.param_12
193: ,p_param_13_o
194: => hr_ctx_shd.g_old_rec.param_13
195: ,p_param_14_o
196: => hr_ctx_shd.g_old_rec.param_14
197: ,p_param_15_o
198: => hr_ctx_shd.g_old_rec.param_15

Line 196: => hr_ctx_shd.g_old_rec.param_14

192: => hr_ctx_shd.g_old_rec.param_12
193: ,p_param_13_o
194: => hr_ctx_shd.g_old_rec.param_13
195: ,p_param_14_o
196: => hr_ctx_shd.g_old_rec.param_14
197: ,p_param_15_o
198: => hr_ctx_shd.g_old_rec.param_15
199: ,p_param_16_o
200: => hr_ctx_shd.g_old_rec.param_16

Line 198: => hr_ctx_shd.g_old_rec.param_15

194: => hr_ctx_shd.g_old_rec.param_13
195: ,p_param_14_o
196: => hr_ctx_shd.g_old_rec.param_14
197: ,p_param_15_o
198: => hr_ctx_shd.g_old_rec.param_15
199: ,p_param_16_o
200: => hr_ctx_shd.g_old_rec.param_16
201: ,p_param_17_o
202: => hr_ctx_shd.g_old_rec.param_17

Line 200: => hr_ctx_shd.g_old_rec.param_16

196: => hr_ctx_shd.g_old_rec.param_14
197: ,p_param_15_o
198: => hr_ctx_shd.g_old_rec.param_15
199: ,p_param_16_o
200: => hr_ctx_shd.g_old_rec.param_16
201: ,p_param_17_o
202: => hr_ctx_shd.g_old_rec.param_17
203: ,p_param_18_o
204: => hr_ctx_shd.g_old_rec.param_18

Line 202: => hr_ctx_shd.g_old_rec.param_17

198: => hr_ctx_shd.g_old_rec.param_15
199: ,p_param_16_o
200: => hr_ctx_shd.g_old_rec.param_16
201: ,p_param_17_o
202: => hr_ctx_shd.g_old_rec.param_17
203: ,p_param_18_o
204: => hr_ctx_shd.g_old_rec.param_18
205: ,p_param_19_o
206: => hr_ctx_shd.g_old_rec.param_19

Line 204: => hr_ctx_shd.g_old_rec.param_18

200: => hr_ctx_shd.g_old_rec.param_16
201: ,p_param_17_o
202: => hr_ctx_shd.g_old_rec.param_17
203: ,p_param_18_o
204: => hr_ctx_shd.g_old_rec.param_18
205: ,p_param_19_o
206: => hr_ctx_shd.g_old_rec.param_19
207: ,p_param_20_o
208: => hr_ctx_shd.g_old_rec.param_20

Line 206: => hr_ctx_shd.g_old_rec.param_19

202: => hr_ctx_shd.g_old_rec.param_17
203: ,p_param_18_o
204: => hr_ctx_shd.g_old_rec.param_18
205: ,p_param_19_o
206: => hr_ctx_shd.g_old_rec.param_19
207: ,p_param_20_o
208: => hr_ctx_shd.g_old_rec.param_20
209: ,p_param_21_o
210: => hr_ctx_shd.g_old_rec.param_21

Line 208: => hr_ctx_shd.g_old_rec.param_20

204: => hr_ctx_shd.g_old_rec.param_18
205: ,p_param_19_o
206: => hr_ctx_shd.g_old_rec.param_19
207: ,p_param_20_o
208: => hr_ctx_shd.g_old_rec.param_20
209: ,p_param_21_o
210: => hr_ctx_shd.g_old_rec.param_21
211: ,p_param_22_o
212: => hr_ctx_shd.g_old_rec.param_22

Line 210: => hr_ctx_shd.g_old_rec.param_21

206: => hr_ctx_shd.g_old_rec.param_19
207: ,p_param_20_o
208: => hr_ctx_shd.g_old_rec.param_20
209: ,p_param_21_o
210: => hr_ctx_shd.g_old_rec.param_21
211: ,p_param_22_o
212: => hr_ctx_shd.g_old_rec.param_22
213: ,p_param_23_o
214: => hr_ctx_shd.g_old_rec.param_23

Line 212: => hr_ctx_shd.g_old_rec.param_22

208: => hr_ctx_shd.g_old_rec.param_20
209: ,p_param_21_o
210: => hr_ctx_shd.g_old_rec.param_21
211: ,p_param_22_o
212: => hr_ctx_shd.g_old_rec.param_22
213: ,p_param_23_o
214: => hr_ctx_shd.g_old_rec.param_23
215: ,p_param_24_o
216: => hr_ctx_shd.g_old_rec.param_24

Line 214: => hr_ctx_shd.g_old_rec.param_23

210: => hr_ctx_shd.g_old_rec.param_21
211: ,p_param_22_o
212: => hr_ctx_shd.g_old_rec.param_22
213: ,p_param_23_o
214: => hr_ctx_shd.g_old_rec.param_23
215: ,p_param_24_o
216: => hr_ctx_shd.g_old_rec.param_24
217: ,p_param_25_o
218: => hr_ctx_shd.g_old_rec.param_25

Line 216: => hr_ctx_shd.g_old_rec.param_24

212: => hr_ctx_shd.g_old_rec.param_22
213: ,p_param_23_o
214: => hr_ctx_shd.g_old_rec.param_23
215: ,p_param_24_o
216: => hr_ctx_shd.g_old_rec.param_24
217: ,p_param_25_o
218: => hr_ctx_shd.g_old_rec.param_25
219: ,p_param_26_o
220: => hr_ctx_shd.g_old_rec.param_26

Line 218: => hr_ctx_shd.g_old_rec.param_25

214: => hr_ctx_shd.g_old_rec.param_23
215: ,p_param_24_o
216: => hr_ctx_shd.g_old_rec.param_24
217: ,p_param_25_o
218: => hr_ctx_shd.g_old_rec.param_25
219: ,p_param_26_o
220: => hr_ctx_shd.g_old_rec.param_26
221: ,p_param_27_o
222: => hr_ctx_shd.g_old_rec.param_27

Line 220: => hr_ctx_shd.g_old_rec.param_26

216: => hr_ctx_shd.g_old_rec.param_24
217: ,p_param_25_o
218: => hr_ctx_shd.g_old_rec.param_25
219: ,p_param_26_o
220: => hr_ctx_shd.g_old_rec.param_26
221: ,p_param_27_o
222: => hr_ctx_shd.g_old_rec.param_27
223: ,p_param_28_o
224: => hr_ctx_shd.g_old_rec.param_28

Line 222: => hr_ctx_shd.g_old_rec.param_27

218: => hr_ctx_shd.g_old_rec.param_25
219: ,p_param_26_o
220: => hr_ctx_shd.g_old_rec.param_26
221: ,p_param_27_o
222: => hr_ctx_shd.g_old_rec.param_27
223: ,p_param_28_o
224: => hr_ctx_shd.g_old_rec.param_28
225: ,p_param_29_o
226: => hr_ctx_shd.g_old_rec.param_29

Line 224: => hr_ctx_shd.g_old_rec.param_28

220: => hr_ctx_shd.g_old_rec.param_26
221: ,p_param_27_o
222: => hr_ctx_shd.g_old_rec.param_27
223: ,p_param_28_o
224: => hr_ctx_shd.g_old_rec.param_28
225: ,p_param_29_o
226: => hr_ctx_shd.g_old_rec.param_29
227: ,p_param_30_o
228: => hr_ctx_shd.g_old_rec.param_30

Line 226: => hr_ctx_shd.g_old_rec.param_29

222: => hr_ctx_shd.g_old_rec.param_27
223: ,p_param_28_o
224: => hr_ctx_shd.g_old_rec.param_28
225: ,p_param_29_o
226: => hr_ctx_shd.g_old_rec.param_29
227: ,p_param_30_o
228: => hr_ctx_shd.g_old_rec.param_30
229: ,p_object_version_number_o
230: => hr_ctx_shd.g_old_rec.object_version_number

Line 228: => hr_ctx_shd.g_old_rec.param_30

224: => hr_ctx_shd.g_old_rec.param_28
225: ,p_param_29_o
226: => hr_ctx_shd.g_old_rec.param_29
227: ,p_param_30_o
228: => hr_ctx_shd.g_old_rec.param_30
229: ,p_object_version_number_o
230: => hr_ctx_shd.g_old_rec.object_version_number
231: );
232: --

Line 230: => hr_ctx_shd.g_old_rec.object_version_number

226: => hr_ctx_shd.g_old_rec.param_29
227: ,p_param_30_o
228: => hr_ctx_shd.g_old_rec.param_30
229: ,p_object_version_number_o
230: => hr_ctx_shd.g_old_rec.object_version_number
231: );
232: --
233: exception
234: --

Line 250: (p_rec in hr_ctx_shd.g_rec_type

246: -- ----------------------------------------------------------------------------
247: -- |---------------------------------< del >----------------------------------|
248: -- ----------------------------------------------------------------------------
249: Procedure del
250: (p_rec in hr_ctx_shd.g_rec_type
251: ) is
252: --
253: l_proc varchar2(72) := g_package||'del';
254: --

Line 260: hr_ctx_shd.lck

256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- We must lock the row which we need to delete.
259: --
260: hr_ctx_shd.lck
261: (p_rec.context_id
262: ,p_rec.object_version_number
263: );
264: --

Line 297: l_rec hr_ctx_shd.g_rec_type;

293: (p_context_id in number
294: ,p_object_version_number in number
295: ) is
296: --
297: l_rec hr_ctx_shd.g_rec_type;
298: l_proc varchar2(72) := g_package||'del';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);