DBA Data[Home] [Help]

APPS.HXC_TKS_UPD dependencies on HXC_TKS_SHD

Line 56: (p_rec in out nocopy hxc_tks_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy hxc_tks_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) ;
60: --

Line 91: hxc_tks_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
91: hxc_tks_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --

Line 96: hxc_tks_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: hxc_tks_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --

Line 101: hxc_tks_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: hxc_tks_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;

Line 141: (p_rec in hxc_tks_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in hxc_tks_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) ;
145: --

Line 188: (p_rec in hxc_tks_shd.g_rec_type

184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_rec in hxc_tks_shd.g_rec_type
189: ) is
190: --
191: l_proc varchar2(72) ;
192: --

Line 207: => hxc_tks_shd.g_old_rec.resource_id

203: => p_rec.submission_id
204: ,p_resource_id
205: => p_rec.resource_id
206: ,p_resource_id_o
207: => hxc_tks_shd.g_old_rec.resource_id
208: );
209: --
210: exception
211: --

Line 270: (p_rec in out nocopy hxc_tks_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure convert_defs
270: (p_rec in out nocopy hxc_tks_shd.g_rec_type
271: ) is
272: --
273: Begin
274: --

Line 282: hxc_tks_shd.g_old_rec.resource_id;

278: -- is being used then we must set to the 'current' argument value.
279: --
280: If (p_rec.resource_id = hr_api.g_number) then
281: p_rec.resource_id :=
282: hxc_tks_shd.g_old_rec.resource_id;
283: End If;
284: --
285: End convert_defs;
286: --

Line 291: (p_rec in out nocopy hxc_tks_shd.g_rec_type

287: -- ----------------------------------------------------------------------------
288: -- |---------------------------------< upd >----------------------------------|
289: -- ----------------------------------------------------------------------------
290: Procedure upd
291: (p_rec in out nocopy hxc_tks_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72) ;
295: --

Line 305: hxc_tks_shd.lck

301: end if;
302: --
303: -- We must lock the row which we need to update.
304: --
305: hxc_tks_shd.lck
306: (p_rec.submission_id
307: );
308: --
309: -- 1. During an update system defaults are used to determine if

Line 349: l_rec hxc_tks_shd.g_rec_type;

345: (p_submission_id in number
346: ,p_resource_id in number default hr_api.g_number
347: ) is
348: --
349: l_rec hxc_tks_shd.g_rec_type;
350: l_proc varchar2(72) ;
351: --
352: Begin
353: g_debug :=hr_utility.debug_enabled;

Line 363: hxc_tks_shd.convert_args

359: -- Call conversion function to turn arguments into the
360: -- l_rec structure.
361: --
362: l_rec :=
363: hxc_tks_shd.convert_args
364: (p_submission_id
365: ,p_resource_id
366: );
367: --