DBA Data[Home] [Help]

APPS.PQH_BGM_DEL dependencies on PQH_BGM_SHD

Line 48: Procedure delete_dml(p_rec in pqh_bgm_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure delete_dml(p_rec in pqh_bgm_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin

Line 67: pqh_bgm_shd.constraint_error

63: --
64: Exception
65: When hr_api.child_integrity_violated then
66: -- Child integrity has been violated
67: pqh_bgm_shd.constraint_error
68: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
69: When Others Then
70: Raise;
71: End delete_dml;

Line 105: Procedure pre_delete(p_rec in pqh_bgm_shd.g_rec_type) is

101: -- Internal Row Handler Use Only.
102: --
103: -- {End Of Comments}
104: -- ----------------------------------------------------------------------------
105: Procedure pre_delete(p_rec in pqh_bgm_shd.g_rec_type) is
106: --
107: l_proc varchar2(72) := g_package||'pre_delete';
108: --
109: Begin

Line 147: Procedure post_delete(p_rec in pqh_bgm_shd.g_rec_type) is

143: -- Internal table Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure post_delete(p_rec in pqh_bgm_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'post_delete';
150: --
151: Begin

Line 162: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id

158: --
159: pqh_bgm_rkd.after_delete
160: (
161: p_budget_gl_flex_map_id =>p_rec.budget_gl_flex_map_id
162: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
163: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
164: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
165: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
166: );

Line 163: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment

159: pqh_bgm_rkd.after_delete
160: (
161: p_budget_gl_flex_map_id =>p_rec.budget_gl_flex_map_id
162: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
163: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
164: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
165: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
166: );
167: --

Line 164: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment

160: (
161: p_budget_gl_flex_map_id =>p_rec.budget_gl_flex_map_id
162: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
163: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
164: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
165: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
166: );
167: --
168: exception

Line 165: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number

161: p_budget_gl_flex_map_id =>p_rec.budget_gl_flex_map_id
162: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
163: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
164: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
165: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
166: );
167: --
168: exception
169: --

Line 189: p_rec in pqh_bgm_shd.g_rec_type

185: -- |---------------------------------< del >----------------------------------|
186: -- ----------------------------------------------------------------------------
187: Procedure del
188: (
189: p_rec in pqh_bgm_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'del';
193: --

Line 199: pqh_bgm_shd.lck

195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: -- We must lock the row which we need to delete.
198: --
199: pqh_bgm_shd.lck
200: (
201: p_rec.budget_gl_flex_map_id,
202: p_rec.object_version_number
203: );

Line 231: l_rec pqh_bgm_shd.g_rec_type;

227: p_budget_gl_flex_map_id in number,
228: p_object_version_number in number
229: ) is
230: --
231: l_rec pqh_bgm_shd.g_rec_type;
232: l_proc varchar2(72) := g_package||'del';
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);