APPS.HR_TIS_UPD dependencies on HR_TIS_SHD

Line 55: (p_rec in out nocopy hr_tis_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_tis_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 106: hr_tis_shd.constraint_error

102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: --
106: hr_tis_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --

Line 111: hr_tis_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: --
111: hr_tis_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --

Line 116: hr_tis_shd.constraint_error

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: --
116: hr_tis_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: --
120: Raise;

Line 156: (p_rec in hr_tis_shd.g_rec_type

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure pre_update
156: (p_rec in hr_tis_shd.g_rec_type
157: ) is
158: --
159: l_proc varchar2(72) := g_package||'pre_update';
160: --

Line 200: (p_rec in hr_tis_shd.g_rec_type

196: --
197: -- {End Of Comments}
198: -- ----------------------------------------------------------------------------
199: Procedure post_update
200: (p_rec in hr_tis_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'post_update';
204: --

Line 234: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id

230: ,p_param_value9 => p_rec.param_value9
231: ,p_param_name10 => p_rec.param_name10
232: ,p_param_value10 => p_rec.param_value10
233: ,p_object_version_number => p_rec.object_version_number
234: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2

Line 235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id

231: ,p_param_name10 => p_rec.param_name10
232: ,p_param_value10 => p_rec.param_value10
233: ,p_object_version_number => p_rec.object_version_number
234: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2

Line 236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1

232: ,p_param_value10 => p_rec.param_value10
233: ,p_object_version_number => p_rec.object_version_number
234: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3

Line 237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1

233: ,p_object_version_number => p_rec.object_version_number
234: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3

Line 238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2

234: ,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4

Line 239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2

235: ,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4

Line 240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3

236: ,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5

Line 241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3

237: ,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5

Line 242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4

238: ,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6

Line 243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4

239: ,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6

Line 244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5

240: ,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7

Line 245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5

241: ,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7

Line 246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6

242: ,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8

Line 247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6

243: ,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8

Line 248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7

244: ,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9

Line 249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7

245: ,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9

Line 250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8

246: ,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10

Line 251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8

247: ,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10

Line 252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9

248: ,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
256: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number

Line 253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9

249: ,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
256: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
257: );

Line 254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10

250: ,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
256: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
257: );
258: --

Line 255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10

251: ,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
256: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
257: );
258: --
259: exception

Line 256: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number

252: ,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
253: ,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
254: ,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
255: ,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
256: ,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
257: );
258: --
259: exception
260: --

Line 316: (p_rec in out nocopy hr_tis_shd.g_rec_type

312: --
313: -- {End Of Comments}
314: -- ----------------------------------------------------------------------------
315: Procedure convert_defs
316: (p_rec in out nocopy hr_tis_shd.g_rec_type
317: ) is
318: --
319: Begin
320: --

Line 328: hr_tis_shd.g_old_rec.topic_id;

324: -- is being used then we must set to the 'current' argument value.
325: --
326: If (p_rec.topic_id = hr_api.g_number) then
327: p_rec.topic_id :=
328: hr_tis_shd.g_old_rec.topic_id;
329: End If;
330: If (p_rec.integration_id = hr_api.g_number) then
331: p_rec.integration_id :=
332: hr_tis_shd.g_old_rec.integration_id;

Line 332: hr_tis_shd.g_old_rec.integration_id;

328: hr_tis_shd.g_old_rec.topic_id;
329: End If;
330: If (p_rec.integration_id = hr_api.g_number) then
331: p_rec.integration_id :=
332: hr_tis_shd.g_old_rec.integration_id;
333: End If;
334: If (p_rec.param_name1 = hr_api.g_varchar2) then
335: p_rec.param_name1 := hr_tis_shd.g_old_rec.param_name1;
336: End If;

Line 335: p_rec.param_name1 := hr_tis_shd.g_old_rec.param_name1;

331: p_rec.integration_id :=
332: hr_tis_shd.g_old_rec.integration_id;
333: End If;
334: If (p_rec.param_name1 = hr_api.g_varchar2) then
335: p_rec.param_name1 := hr_tis_shd.g_old_rec.param_name1;
336: End If;
337: If (p_rec.param_value1 = hr_api.g_varchar2) then
338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;
339: End If;

Line 338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;

334: If (p_rec.param_name1 = hr_api.g_varchar2) then
335: p_rec.param_name1 := hr_tis_shd.g_old_rec.param_name1;
336: End If;
337: If (p_rec.param_value1 = hr_api.g_varchar2) then
338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;
339: End If;
340: If (p_rec.param_name2 = hr_api.g_varchar2) then
341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;
342: End If;

Line 341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;

337: If (p_rec.param_value1 = hr_api.g_varchar2) then
338: p_rec.param_value1 := hr_tis_shd.g_old_rec.param_value1;
339: End If;
340: If (p_rec.param_name2 = hr_api.g_varchar2) then
341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;
342: End If;
343: If (p_rec.param_value2 = hr_api.g_varchar2) then
344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;
345: End If;

Line 344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;

340: If (p_rec.param_name2 = hr_api.g_varchar2) then
341: p_rec.param_name2 := hr_tis_shd.g_old_rec.param_name2;
342: End If;
343: If (p_rec.param_value2 = hr_api.g_varchar2) then
344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;
345: End If;
346: If (p_rec.param_name3 = hr_api.g_varchar2) then
347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;
348: End If;

Line 347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;

343: If (p_rec.param_value2 = hr_api.g_varchar2) then
344: p_rec.param_value2 := hr_tis_shd.g_old_rec.param_value2;
345: End If;
346: If (p_rec.param_name3 = hr_api.g_varchar2) then
347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;
348: End If;
349: If (p_rec.param_value3 = hr_api.g_varchar2) then
350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;
351: End If;

Line 350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;

346: If (p_rec.param_name3 = hr_api.g_varchar2) then
347: p_rec.param_name3 := hr_tis_shd.g_old_rec.param_name3;
348: End If;
349: If (p_rec.param_value3 = hr_api.g_varchar2) then
350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;
351: End If;
352: If (p_rec.param_name4 = hr_api.g_varchar2) then
353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;
354: End If;

Line 353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;

349: If (p_rec.param_value3 = hr_api.g_varchar2) then
350: p_rec.param_value3 := hr_tis_shd.g_old_rec.param_value3;
351: End If;
352: If (p_rec.param_name4 = hr_api.g_varchar2) then
353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;
354: End If;
355: If (p_rec.param_value4 = hr_api.g_varchar2) then
356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;
357: End If;

Line 356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;

352: If (p_rec.param_name4 = hr_api.g_varchar2) then
353: p_rec.param_name4 := hr_tis_shd.g_old_rec.param_name4;
354: End If;
355: If (p_rec.param_value4 = hr_api.g_varchar2) then
356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;
357: End If;
358: If (p_rec.param_name5 = hr_api.g_varchar2) then
359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;
360: End If;

Line 359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;

355: If (p_rec.param_value4 = hr_api.g_varchar2) then
356: p_rec.param_value4 := hr_tis_shd.g_old_rec.param_value4;
357: End If;
358: If (p_rec.param_name5 = hr_api.g_varchar2) then
359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;
360: End If;
361: If (p_rec.param_value5 = hr_api.g_varchar2) then
362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;
363: End If;

Line 362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;

358: If (p_rec.param_name5 = hr_api.g_varchar2) then
359: p_rec.param_name5 := hr_tis_shd.g_old_rec.param_name5;
360: End If;
361: If (p_rec.param_value5 = hr_api.g_varchar2) then
362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;
363: End If;
364: If (p_rec.param_name6 = hr_api.g_varchar2) then
365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;
366: End If;

Line 365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;

361: If (p_rec.param_value5 = hr_api.g_varchar2) then
362: p_rec.param_value5 := hr_tis_shd.g_old_rec.param_value5;
363: End If;
364: If (p_rec.param_name6 = hr_api.g_varchar2) then
365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;
366: End If;
367: If (p_rec.param_value6 = hr_api.g_varchar2) then
368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;
369: End If;

Line 368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;

364: If (p_rec.param_name6 = hr_api.g_varchar2) then
365: p_rec.param_name6 := hr_tis_shd.g_old_rec.param_name6;
366: End If;
367: If (p_rec.param_value6 = hr_api.g_varchar2) then
368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;
369: End If;
370: If (p_rec.param_name7 = hr_api.g_varchar2) then
371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;
372: End If;

Line 371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;

367: If (p_rec.param_value6 = hr_api.g_varchar2) then
368: p_rec.param_value6 := hr_tis_shd.g_old_rec.param_value6;
369: End If;
370: If (p_rec.param_name7 = hr_api.g_varchar2) then
371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;
372: End If;
373: If (p_rec.param_value7 = hr_api.g_varchar2) then
374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;
375: End If;

Line 374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;

370: If (p_rec.param_name7 = hr_api.g_varchar2) then
371: p_rec.param_name7 := hr_tis_shd.g_old_rec.param_name7;
372: End If;
373: If (p_rec.param_value7 = hr_api.g_varchar2) then
374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;
375: End If;
376: If (p_rec.param_name8 = hr_api.g_varchar2) then
377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;
378: End If;

Line 377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;

373: If (p_rec.param_value7 = hr_api.g_varchar2) then
374: p_rec.param_value7 := hr_tis_shd.g_old_rec.param_value7;
375: End If;
376: If (p_rec.param_name8 = hr_api.g_varchar2) then
377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;
378: End If;
379: If (p_rec.param_value8 = hr_api.g_varchar2) then
380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;
381: End If;

Line 380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;

376: If (p_rec.param_name8 = hr_api.g_varchar2) then
377: p_rec.param_name8 := hr_tis_shd.g_old_rec.param_name8;
378: End If;
379: If (p_rec.param_value8 = hr_api.g_varchar2) then
380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;
381: End If;
382: If (p_rec.param_name9 = hr_api.g_varchar2) then
383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;
384: End If;

Line 383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;

379: If (p_rec.param_value8 = hr_api.g_varchar2) then
380: p_rec.param_value8 := hr_tis_shd.g_old_rec.param_value8;
381: End If;
382: If (p_rec.param_name9 = hr_api.g_varchar2) then
383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;
384: End If;
385: If (p_rec.param_value9 = hr_api.g_varchar2) then
386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;
387: End If;

Line 386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;

382: If (p_rec.param_name9 = hr_api.g_varchar2) then
383: p_rec.param_name9 := hr_tis_shd.g_old_rec.param_name9;
384: End If;
385: If (p_rec.param_value9 = hr_api.g_varchar2) then
386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;
387: End If;
388: If (p_rec.param_name10 = hr_api.g_varchar2) then
389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;
390: End If;

Line 389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;

385: If (p_rec.param_value9 = hr_api.g_varchar2) then
386: p_rec.param_value9 := hr_tis_shd.g_old_rec.param_value9;
387: End If;
388: If (p_rec.param_name10 = hr_api.g_varchar2) then
389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;
390: End If;
391: If (p_rec.param_value10 = hr_api.g_varchar2) then
392: p_rec.param_value10 := hr_tis_shd.g_old_rec.param_value10;
393: End If;

Line 392: p_rec.param_value10 := hr_tis_shd.g_old_rec.param_value10;

388: If (p_rec.param_name10 = hr_api.g_varchar2) then
389: p_rec.param_name10 := hr_tis_shd.g_old_rec.param_name10;
390: End If;
391: If (p_rec.param_value10 = hr_api.g_varchar2) then
392: p_rec.param_value10 := hr_tis_shd.g_old_rec.param_value10;
393: End If;
394: --
395: End convert_defs;
396: --

Line 401: (p_rec in out nocopy hr_tis_shd.g_rec_type

397: -- ----------------------------------------------------------------------------
398: -- |---------------------------------< upd >----------------------------------|
399: -- ----------------------------------------------------------------------------
400: Procedure upd
401: (p_rec in out nocopy hr_tis_shd.g_rec_type
402: ) is
403: --
404: l_proc varchar2(72) := g_package||'upd';
405: --

Line 411: hr_tis_shd.lck

407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- We must lock the row which we need to update.
410: --
411: hr_tis_shd.lck
412: (p_rec.topic_integrations_id
413: ,p_rec.object_version_number
414: );
415: --

Line 478: l_rec hr_tis_shd.g_rec_type;

474: ,p_param_value10 in varchar2 default hr_api.g_varchar2
475: ,p_object_version_number in out nocopy number
476: ) is
477: --
478: l_rec hr_tis_shd.g_rec_type;
479: l_proc varchar2(72) := g_package||'upd';
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);

Line 488: hr_tis_shd.convert_args

484: -- Call conversion function to turn arguments into the
485: -- l_rec structure.
486: --
487: l_rec :=
488: hr_tis_shd.convert_args
489: (p_topic_integrations_id
490: ,p_topic_id
491: ,p_integration_id
492: ,p_param_name1