DBA Data[Home] [Help]

APPS.HXC_APS_DEL dependencies on HXC_APS_SHD

Line 53: (p_rec in hxc_aps_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in hxc_aps_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72);
57: --

Line 64: hxc_aps_shd.g_api_dml := true; -- Set the api dml status

60: l_proc:= g_package||'delete_dml';
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: hxc_aps_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- First of all delete any child rows
67: --
68: delete from hxc_approval_period_comps

Line 76: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

72: --
73: delete from hxc_approval_period_sets
74: where approval_period_set_id = p_rec.approval_period_set_id;
75: --
76: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
77: --
78: if g_debug then
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: end if;

Line 85: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

81: --
82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_aps_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

Line 86: hxc_aps_shd.constraint_error

82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_aps_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;

Line 89: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

85: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_aps_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;
91: End delete_dml;
92: --
93: -- ----------------------------------------------------------------------------

Line 125: Procedure pre_delete(p_rec in hxc_aps_shd.g_rec_type) is

121: -- Internal Row Handler Use Only.
122: --
123: -- {End Of Comments}
124: -- ----------------------------------------------------------------------------
125: Procedure pre_delete(p_rec in hxc_aps_shd.g_rec_type) is
126: --
127: l_proc varchar2(72);
128: --
129: Begin

Line 170: Procedure post_delete(p_rec in hxc_aps_shd.g_rec_type) is

166: -- Internal Row Handler Use Only.
167: --
168: -- {End Of Comments}
169: -- -----------------------------------------------------------------------------
170: Procedure post_delete(p_rec in hxc_aps_shd.g_rec_type) is
171: --
172: l_proc varchar2(72);
173: --
174: Begin

Line 185: => hxc_aps_shd.g_old_rec.name

181: hxc_aps_rkd.after_delete
182: (p_approval_period_set_id
183: => p_rec.approval_period_set_id
184: ,p_name_o
185: => hxc_aps_shd.g_old_rec.name
186: ,p_object_version_number_o
187: => hxc_aps_shd.g_old_rec.object_version_number
188: );
189: --

Line 187: => hxc_aps_shd.g_old_rec.object_version_number

183: => p_rec.approval_period_set_id
184: ,p_name_o
185: => hxc_aps_shd.g_old_rec.name
186: ,p_object_version_number_o
187: => hxc_aps_shd.g_old_rec.object_version_number
188: );
189: --
190: exception
191: --

Line 209: (p_rec in hxc_aps_shd.g_rec_type

205: -- ----------------------------------------------------------------------------
206: -- |---------------------------------< del >----------------------------------|
207: -- ----------------------------------------------------------------------------
208: Procedure del
209: (p_rec in hxc_aps_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72);
213: --

Line 223: hxc_aps_shd.lck

219: end if;
220: --
221: -- We must lock the row which we need to delete.
222: --
223: hxc_aps_shd.lck
224: (p_rec.approval_period_set_id
225: ,p_rec.object_version_number
226: );
227: --

Line 254: l_rec hxc_aps_shd.g_rec_type;

250: (p_approval_period_set_id in number
251: ,p_object_version_number in number
252: ) is
253: --
254: l_rec hxc_aps_shd.g_rec_type;
255: l_proc varchar2(72);
256: --
257: Begin
258: g_debug:=hr_utility.debug_enabled;