APPS.HXC_APC_INS dependencies on HXC_APC_SHD

Line 55: (p_rec in out nocopy hxc_apc_shd.g_rec_type

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

Line 67: hxc_apc_shd.g_api_dml := true; -- Set the api dml status

63: hr_utility.set_location('Entering:'||l_proc, 5);
64: end if;
65: p_rec.object_version_number := 1; -- Initialise the object version
66: --
67: hxc_apc_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Insert the row into: hxc_approval_period_comps
70: --
71: insert into hxc_approval_period_comps

Line 96: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

92: ,sysdate
93: ,fnd_global.login_id
94: );
95: --
96: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
97: --
98: if g_debug then
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: end if;

Line 104: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 105: hxc_apc_shd.constraint_error

101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
105: hxc_apc_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.parent_integrity_violated Then
108: -- Parent integrity has been violated
109: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 110: hxc_apc_shd.constraint_error

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

Line 114: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 115: hxc_apc_shd.constraint_error

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

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

114: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
115: hxc_apc_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When Others Then
118: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
119: Raise;
120: End insert_dml;
121: --
122: -- ----------------------------------------------------------------------------

Line 160: (p_rec in out nocopy hxc_apc_shd.g_rec_type

156: --
157: -- {End Of Comments}
158: -- ----------------------------------------------------------------------------
159: Procedure pre_insert
160: (p_rec in out nocopy hxc_apc_shd.g_rec_type
161: ) is
162: --
163: l_proc varchar2(72);
164: --

Line 219: ,p_rec in hxc_apc_shd.g_rec_type

215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure post_insert
218: (p_effective_date in date
219: ,p_rec in hxc_apc_shd.g_rec_type
220: ) is
221: --
222: l_proc varchar2(72);
223: --

Line 267: ,p_rec in out nocopy hxc_apc_shd.g_rec_type

263: -- |---------------------------------< ins >----------------------------------|
264: -- ----------------------------------------------------------------------------
265: Procedure ins
266: (p_effective_date in date
267: ,p_rec in out nocopy hxc_apc_shd.g_rec_type
268: ) is
269: --
270: l_proc varchar2(72);
271: --

Line 318: l_rec hxc_apc_shd.g_rec_type;

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

Line 332: hxc_apc_shd.convert_args

328: -- Call conversion function to turn arguments into the
329: -- p_rec structure.
330: --
331: l_rec :=
332: hxc_apc_shd.convert_args
333: (null
334: ,p_time_recipient_id
335: ,p_recurring_period_id
336: ,p_approval_period_set_id