DBA Data[Home] [Help]

APPS.HXC_TCC_INS dependencies on HXC_TCC_SHD

Line 56: (p_rec in out nocopy hxc_tcc_shd.g_rec_type

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

Line 70: hxc_tcc_shd.g_api_dml := true; -- Set the api dml status

66: hr_utility.set_location('Entering:'||l_proc, 5);
67: end if;
68: p_rec.object_version_number := 1; -- Initialise the object version
69: --
70: hxc_tcc_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_time_category_comps
73: --
74:

Line 109: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

105: ,sysdate
106: ,fnd_global.login_id
107: );
108: --
109: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
110: --
111: if g_debug then
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: end if;

Line 120: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

116: -- A check constraint has been violated
117: if g_debug then
118: hr_utility.trace(SUBSTR(SQLERRM,1,60));
119: end if;
120: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
121: hxc_tcc_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated

Line 121: hxc_tcc_shd.constraint_error

117: if g_debug then
118: hr_utility.trace(SUBSTR(SQLERRM,1,60));
119: end if;
120: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
121: hxc_tcc_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: if g_debug then

Line 128: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

124: -- Parent integrity has been violated
125: if g_debug then
126: hr_utility.trace(SUBSTR(SQLERRM,1,60));
127: end if;
128: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
129: hxc_tcc_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated

Line 129: hxc_tcc_shd.constraint_error

125: if g_debug then
126: hr_utility.trace(SUBSTR(SQLERRM,1,60));
127: end if;
128: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
129: hxc_tcc_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: if g_debug then

Line 136: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

132: -- Unique integrity has been violated
133: if g_debug then
134: hr_utility.trace(SUBSTR(SQLERRM,1,60));
135: end if;
136: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
137: hxc_tcc_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: if g_debug then

Line 137: hxc_tcc_shd.constraint_error

133: if g_debug then
134: hr_utility.trace(SUBSTR(SQLERRM,1,60));
135: end if;
136: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
137: hxc_tcc_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: if g_debug then
141: hr_utility.trace(SUBSTR(SQLERRM,1,60));

Line 144: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

140: if g_debug then
141: hr_utility.trace(SUBSTR(SQLERRM,1,60));
142: hr_utility.trace(SUBSTR(SQLERRM,61,120));
143: end if;
144: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
145: Raise;
146: End insert_dml;
147: --
148: -- ----------------------------------------------------------------------------

Line 186: (p_rec in out nocopy hxc_tcc_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure pre_insert
186: (p_rec in out nocopy hxc_tcc_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72);
190: --

Line 246: (p_rec in hxc_tcc_shd.g_rec_type

242: --
243: -- {End Of Comments}
244: -- ----------------------------------------------------------------------------
245: Procedure post_insert
246: (p_rec in hxc_tcc_shd.g_rec_type
247: ) is
248: --
249: l_proc varchar2(72);
250: --

Line 291: (p_rec in out nocopy hxc_tcc_shd.g_rec_type

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

Line 357: l_rec hxc_tcc_shd.g_rec_type;

353: ,p_time_category_comp_id out nocopy number
354: ,p_object_version_number out nocopy number
355: ) is
356: --
357: l_rec hxc_tcc_shd.g_rec_type;
358: l_proc varchar2(72);
359: --
360: Begin
361:

Line 373: hxc_tcc_shd.convert_args (

369: -- Call conversion function to turn arguments into the
370: -- p_rec structure.
371: --
372: l_rec :=
373: hxc_tcc_shd.convert_args (
374: null
375: ,p_time_category_id
376: ,p_ref_time_category_id
377: ,p_component_type_id