APPS.HXC_HTC_INS dependencies on HXC_HTC_SHD

Line 56: (p_rec in out nocopy hxc_htc_shd.g_rec_type

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

Line 70: hxc_htc_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_htc_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_time_categories
73: --
74: insert into hxc_time_categories

Line 100: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

96: ,sysdate
97: ,fnd_global.login_id
98: );
99: --
100: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: if g_debug then
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: end if;

Line 108: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

104: end if;
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_htc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated

Line 109: hxc_htc_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_htc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

Line 113: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

109: hxc_htc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_htc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated

Line 114: hxc_htc_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_htc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

Line 118: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

114: hxc_htc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
119: hxc_htc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

Line 119: hxc_htc_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
119: hxc_htc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;

Line 122: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

118: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
119: hxc_htc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;
124: End insert_dml;
125: --
126: -- ----------------------------------------------------------------------------

Line 164: (p_rec in out nocopy hxc_htc_shd.g_rec_type

160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_insert
164: (p_rec in out nocopy hxc_htc_shd.g_rec_type
165: ) is
166: --
167: l_proc varchar2(72);
168: --

Line 224: (p_rec in hxc_htc_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure post_insert
224: (p_rec in hxc_htc_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72);
228: --

Line 269: (p_rec in out nocopy hxc_htc_shd.g_rec_type

265: -- ----------------------------------------------------------------------------
266: -- |---------------------------------< ins >----------------------------------|
267: -- ----------------------------------------------------------------------------
268: Procedure ins
269: (p_rec in out nocopy hxc_htc_shd.g_rec_type
270: ) is
271: --
272: l_proc varchar2(72);
273: --

Line 319: l_rec hxc_htc_shd.g_rec_type;

315: ,p_time_category_id out nocopy number
316: ,p_object_version_number out nocopy number
317: ) is
318: --
319: l_rec hxc_htc_shd.g_rec_type;
320: l_proc varchar2(72);
321: --
322: Begin
323: g_debug := hr_utility.debug_enabled;

Line 335: hxc_htc_shd.convert_args

331: -- p_rec structure.
332: --
333:
334: l_rec :=
335: hxc_htc_shd.convert_args
336: (null
337: ,p_time_category_name
338: ,p_operator
339: ,p_description