DBA Data[Home] [Help]

APPS.HXC_TKS_INS dependencies on HXC_TKS_SHD

Line 83: (p_rec in out nocopy hxc_tks_shd.g_rec_type

79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure insert_dml
83: (p_rec in out nocopy hxc_tks_shd.g_rec_type
84: ) is
85: --
86: l_proc varchar2(72) ;
87: --

Line 120: hxc_tks_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: hxc_tks_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --

Line 125: hxc_tks_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: hxc_tks_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --

Line 130: hxc_tks_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: hxc_tks_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;

Line 175: (p_rec in out nocopy hxc_tks_shd.g_rec_type

171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_insert
175: (p_rec in out nocopy hxc_tks_shd.g_rec_type
176: ) is
177: --
178: Cursor C_Sel1 is select hxc_tk_timekeeper_submits_s.nextval from sys.dual;
179: --

Line 269: (p_rec in hxc_tks_shd.g_rec_type

265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure post_insert
269: (p_rec in hxc_tks_shd.g_rec_type
270: ) is
271: --
272: l_proc varchar2(72) ;
273: --

Line 309: (p_rec in out nocopy hxc_tks_shd.g_rec_type

305: -- ----------------------------------------------------------------------------
306: -- |---------------------------------< ins >----------------------------------|
307: -- ----------------------------------------------------------------------------
308: Procedure ins
309: (p_rec in out nocopy hxc_tks_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) ;
313: --

Line 358: l_rec hxc_tks_shd.g_rec_type;

354: (p_resource_id in number
355: ,p_submission_id in number
356: ) is
357: --
358: l_rec hxc_tks_shd.g_rec_type;
359: l_proc varchar2(72) ;
360: --
361: Begin
362: g_debug :=hr_utility.debug_enabled;

Line 372: hxc_tks_shd.convert_args

368: -- Call conversion function to turn arguments into the
369: -- p_rec structure.
370: --
371: l_rec :=
372: hxc_tks_shd.convert_args
373: (p_submission_id ,p_resource_id );
374: --
375: -- Having converted the arguments into the hxc_tks_rec
376: -- plsql record structure we call the corresponding record business process.