eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BGT_DEL dependencies on PQH_BGT_SHD

Line 45: Procedure delete_dml(p_rec in pqh_bgt_shd.g_rec_type) is

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

Line 64: pqh_bgt_shd.constraint_error

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

Line 102: Procedure pre_delete(p_rec in pqh_bgt_shd.g_rec_type) is

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_bgt_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: l_budgets_rec pqh_budgets%ROWTYPE;

Line 183: p_effective_date in date,p_rec in pqh_bgt_shd.g_rec_type) is

179: --
180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_delete(
183: p_effective_date in date,p_rec in pqh_bgt_shd.g_rec_type) is
184: --
185: l_proc varchar2(72) := g_package||'post_delete';
186: --
187: Begin

Line 198: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id

194: --
195: pqh_bgt_rkd.after_delete
196: (
197: p_budget_id =>p_rec.budget_id
198: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd

Line 199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id

195: pqh_bgt_rkd.after_delete
196: (
197: p_budget_id =>p_rec.budget_id
198: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name

Line 200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id

196: (
197: p_budget_id =>p_rec.budget_id
198: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name

Line 201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd

197: p_budget_id =>p_rec.budget_id
198: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date

Line 202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd

198: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date

Line 203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name

199: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name

Line 204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name

200: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag

Line 205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date

201: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag

Line 206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date

202: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag

Line 207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name

203: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status

Line 208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag

204: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number

Line 209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag

205: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id

Line 210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag

206: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id

Line 211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status

207: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id

Line 212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number

208: ,P_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id

Line 213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id

209: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate

Line 214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id

210: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate

Line 215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id

211: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate

Line 216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id

212: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag

Line 217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate

213: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag

Line 218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate

214: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code

Line 219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate

215: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
223: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id

Line 220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag

216: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
223: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
224: );

Line 221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag

217: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
223: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
224: );
225: --

Line 222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code

218: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
223: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
224: );
225: --
226: exception

Line 223: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id

219: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
220: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
221: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
222: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
223: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
224: );
225: --
226: exception
227: --

Line 248: p_rec in pqh_bgt_shd.g_rec_type

244: -- ----------------------------------------------------------------------------
245: Procedure del
246: (
247: p_effective_date in date,
248: p_rec in pqh_bgt_shd.g_rec_type
249: ) is
250: --
251: l_proc varchar2(72) := g_package||'del';
252: --

Line 258: pqh_bgt_shd.lck

254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: -- We must lock the row which we need to delete.
257: --
258: pqh_bgt_shd.lck
259: (
260: p_rec.budget_id,
261: p_rec.object_version_number
262: );

Line 293: l_rec pqh_bgt_shd.g_rec_type;

289: p_budget_id in number,
290: p_object_version_number in number
291: ) is
292: --
293: l_rec pqh_bgt_shd.g_rec_type;
294: l_proc varchar2(72) := g_package||'del';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);