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_UPD dependencies on PQH_BGT_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_bgt_shd.g_rec_type) is

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

Line 99: pqh_bgt_shd.constraint_error

95: --
96: Exception
97: When hr_api.check_integrity_violated Then
98: -- A check constraint has been violated
99: pqh_bgt_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pqh_bgt_shd.constraint_error

Line 103: pqh_bgt_shd.constraint_error

99: pqh_bgt_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: pqh_bgt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pqh_bgt_shd.constraint_error

Line 107: pqh_bgt_shd.constraint_error

103: pqh_bgt_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pqh_bgt_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: Raise;
111: End update_dml;

Line 145: Procedure pre_update(p_rec in pqh_bgt_shd.g_rec_type) is

141: -- Internal Row Handler Use Only.
142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update(p_rec in pqh_bgt_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --
149: l_budgets_rec pqh_budgets%ROWTYPE;

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

209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure post_update(
213: p_effective_date in date,p_rec in pqh_bgt_shd.g_rec_type) is
214: --
215: l_proc varchar2(72) := g_package||'post_update';
216: --
217: Begin

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

251: ,p_valid_grade_reqd_flag =>p_rec.valid_grade_reqd_flag
252: ,p_currency_code =>p_rec.currency_code
253: ,p_dflt_budget_set_id =>p_rec.dflt_budget_set_id
254: ,p_effective_date =>p_effective_date
255: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
256: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd

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

252: ,p_currency_code =>p_rec.currency_code
253: ,p_dflt_budget_set_id =>p_rec.dflt_budget_set_id
254: ,p_effective_date =>p_effective_date
255: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
256: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name

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

253: ,p_dflt_budget_set_id =>p_rec.dflt_budget_set_id
254: ,p_effective_date =>p_effective_date
255: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
256: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name

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

254: ,p_effective_date =>p_effective_date
255: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
256: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date

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

255: ,p_business_group_id_o =>pqh_bgt_shd.g_old_rec.business_group_id
256: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date

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

256: ,p_start_organization_id_o =>pqh_bgt_shd.g_old_rec.start_organization_id
257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name

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

257: ,p_org_structure_version_id_o =>pqh_bgt_shd.g_old_rec.org_structure_version_id
258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag

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

258: ,p_budgeted_entity_cd_o =>pqh_bgt_shd.g_old_rec.budgeted_entity_cd
259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag

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

259: ,p_budget_style_cd_o =>pqh_bgt_shd.g_old_rec.budget_style_cd
260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag

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

260: ,p_budget_name_o =>pqh_bgt_shd.g_old_rec.budget_name
261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status

Line 265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag

261: ,p_period_set_name_o =>pqh_bgt_shd.g_old_rec.period_set_name
262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number

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

262: ,p_budget_start_date_o =>pqh_bgt_shd.g_old_rec.budget_start_date
263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id

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

263: ,p_budget_end_date_o =>pqh_bgt_shd.g_old_rec.budget_end_date
264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id

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

264: ,p_gl_budget_name_o =>pqh_bgt_shd.g_old_rec.gl_budget_name
265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id

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

265: ,p_psb_budget_flag_o =>pqh_bgt_shd.g_old_rec.psb_budget_flag
266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id

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

266: ,p_transfer_to_gl_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_gl_flag
267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate

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

267: ,p_transfer_to_grants_flag_o =>pqh_bgt_shd.g_old_rec.transfer_to_grants_flag
268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate

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

268: ,p_status_o =>pqh_bgt_shd.g_old_rec.status
269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate

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

269: ,p_object_version_number_o =>pqh_bgt_shd.g_old_rec.object_version_number
270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag

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

270: ,p_budget_unit1_id_o =>pqh_bgt_shd.g_old_rec.budget_unit1_id
271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag

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

271: ,p_budget_unit2_id_o =>pqh_bgt_shd.g_old_rec.budget_unit2_id
272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
279: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code

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

272: ,p_budget_unit3_id_o =>pqh_bgt_shd.g_old_rec.budget_unit3_id
273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
279: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
280: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id

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

273: ,p_gl_set_of_books_id_o =>pqh_bgt_shd.g_old_rec.gl_set_of_books_id
274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
279: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
280: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
281: );

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

274: ,p_budget_unit1_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit1_aggregate
275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
279: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
280: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
281: );
282: --

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

275: ,p_budget_unit2_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit2_aggregate
276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
279: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
280: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
281: );
282: --
283: exception

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

276: ,p_budget_unit3_aggregate_o =>pqh_bgt_shd.g_old_rec.budget_unit3_aggregate
277: ,p_position_control_flag_o =>pqh_bgt_shd.g_old_rec.position_control_flag
278: ,p_valid_grade_reqd_flag_o =>pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag
279: ,p_currency_code_o =>pqh_bgt_shd.g_old_rec.currency_code
280: ,p_dflt_budget_set_id_o =>pqh_bgt_shd.g_old_rec.dflt_budget_set_id
281: );
282: --
283: exception
284: --

Line 342: Procedure convert_defs(p_rec in out nocopy pqh_bgt_shd.g_rec_type) is

338: -- Internal Row Handler Use Only.
339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure convert_defs(p_rec in out nocopy pqh_bgt_shd.g_rec_type) is
343: --
344: l_proc varchar2(72) := g_package||'convert_defs';
345: --
346: Begin

Line 357: pqh_bgt_shd.g_old_rec.business_group_id;

353: -- is being used then we must set to the 'current' argument value.
354: --
355: If (p_rec.business_group_id = hr_api.g_number) then
356: p_rec.business_group_id :=
357: pqh_bgt_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.start_organization_id = hr_api.g_number) then
360: p_rec.start_organization_id :=
361: pqh_bgt_shd.g_old_rec.start_organization_id;

Line 361: pqh_bgt_shd.g_old_rec.start_organization_id;

357: pqh_bgt_shd.g_old_rec.business_group_id;
358: End If;
359: If (p_rec.start_organization_id = hr_api.g_number) then
360: p_rec.start_organization_id :=
361: pqh_bgt_shd.g_old_rec.start_organization_id;
362: End If;
363: If (p_rec.org_structure_version_id = hr_api.g_number) then
364: p_rec.org_structure_version_id :=
365: pqh_bgt_shd.g_old_rec.org_structure_version_id;

Line 365: pqh_bgt_shd.g_old_rec.org_structure_version_id;

361: pqh_bgt_shd.g_old_rec.start_organization_id;
362: End If;
363: If (p_rec.org_structure_version_id = hr_api.g_number) then
364: p_rec.org_structure_version_id :=
365: pqh_bgt_shd.g_old_rec.org_structure_version_id;
366: End If;
367: If (p_rec.budgeted_entity_cd = hr_api.g_varchar2) then
368: p_rec.budgeted_entity_cd :=
369: pqh_bgt_shd.g_old_rec.budgeted_entity_cd;

Line 369: pqh_bgt_shd.g_old_rec.budgeted_entity_cd;

365: pqh_bgt_shd.g_old_rec.org_structure_version_id;
366: End If;
367: If (p_rec.budgeted_entity_cd = hr_api.g_varchar2) then
368: p_rec.budgeted_entity_cd :=
369: pqh_bgt_shd.g_old_rec.budgeted_entity_cd;
370: End If;
371: If (p_rec.budget_style_cd = hr_api.g_varchar2) then
372: p_rec.budget_style_cd :=
373: pqh_bgt_shd.g_old_rec.budget_style_cd;

Line 373: pqh_bgt_shd.g_old_rec.budget_style_cd;

369: pqh_bgt_shd.g_old_rec.budgeted_entity_cd;
370: End If;
371: If (p_rec.budget_style_cd = hr_api.g_varchar2) then
372: p_rec.budget_style_cd :=
373: pqh_bgt_shd.g_old_rec.budget_style_cd;
374: End If;
375: If (p_rec.budget_name = hr_api.g_varchar2) then
376: p_rec.budget_name :=
377: pqh_bgt_shd.g_old_rec.budget_name;

Line 377: pqh_bgt_shd.g_old_rec.budget_name;

373: pqh_bgt_shd.g_old_rec.budget_style_cd;
374: End If;
375: If (p_rec.budget_name = hr_api.g_varchar2) then
376: p_rec.budget_name :=
377: pqh_bgt_shd.g_old_rec.budget_name;
378: End If;
379: If (p_rec.period_set_name = hr_api.g_varchar2) then
380: p_rec.period_set_name :=
381: pqh_bgt_shd.g_old_rec.period_set_name;

Line 381: pqh_bgt_shd.g_old_rec.period_set_name;

377: pqh_bgt_shd.g_old_rec.budget_name;
378: End If;
379: If (p_rec.period_set_name = hr_api.g_varchar2) then
380: p_rec.period_set_name :=
381: pqh_bgt_shd.g_old_rec.period_set_name;
382: End If;
383: If (p_rec.budget_start_date = hr_api.g_date) then
384: p_rec.budget_start_date :=
385: pqh_bgt_shd.g_old_rec.budget_start_date;

Line 385: pqh_bgt_shd.g_old_rec.budget_start_date;

381: pqh_bgt_shd.g_old_rec.period_set_name;
382: End If;
383: If (p_rec.budget_start_date = hr_api.g_date) then
384: p_rec.budget_start_date :=
385: pqh_bgt_shd.g_old_rec.budget_start_date;
386: End If;
387: If (p_rec.budget_end_date = hr_api.g_date) then
388: p_rec.budget_end_date :=
389: pqh_bgt_shd.g_old_rec.budget_end_date;

Line 389: pqh_bgt_shd.g_old_rec.budget_end_date;

385: pqh_bgt_shd.g_old_rec.budget_start_date;
386: End If;
387: If (p_rec.budget_end_date = hr_api.g_date) then
388: p_rec.budget_end_date :=
389: pqh_bgt_shd.g_old_rec.budget_end_date;
390: End If;
391: If (p_rec.gl_budget_name = hr_api.g_varchar2) then
392: p_rec.gl_budget_name :=
393: pqh_bgt_shd.g_old_rec.gl_budget_name;

Line 393: pqh_bgt_shd.g_old_rec.gl_budget_name;

389: pqh_bgt_shd.g_old_rec.budget_end_date;
390: End If;
391: If (p_rec.gl_budget_name = hr_api.g_varchar2) then
392: p_rec.gl_budget_name :=
393: pqh_bgt_shd.g_old_rec.gl_budget_name;
394: End If;
395: If (p_rec.psb_budget_flag = hr_api.g_varchar2) then
396: p_rec.psb_budget_flag :=
397: pqh_bgt_shd.g_old_rec.psb_budget_flag;

Line 397: pqh_bgt_shd.g_old_rec.psb_budget_flag;

393: pqh_bgt_shd.g_old_rec.gl_budget_name;
394: End If;
395: If (p_rec.psb_budget_flag = hr_api.g_varchar2) then
396: p_rec.psb_budget_flag :=
397: pqh_bgt_shd.g_old_rec.psb_budget_flag;
398: End If;
399: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
400: p_rec.transfer_to_gl_flag :=
401: pqh_bgt_shd.g_old_rec.transfer_to_gl_flag;

Line 401: pqh_bgt_shd.g_old_rec.transfer_to_gl_flag;

397: pqh_bgt_shd.g_old_rec.psb_budget_flag;
398: End If;
399: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
400: p_rec.transfer_to_gl_flag :=
401: pqh_bgt_shd.g_old_rec.transfer_to_gl_flag;
402: End If;
403: If (p_rec.transfer_to_grants_flag = hr_api.g_varchar2) then
404: p_rec.transfer_to_grants_flag :=
405: pqh_bgt_shd.g_old_rec.transfer_to_grants_flag;

Line 405: pqh_bgt_shd.g_old_rec.transfer_to_grants_flag;

401: pqh_bgt_shd.g_old_rec.transfer_to_gl_flag;
402: End If;
403: If (p_rec.transfer_to_grants_flag = hr_api.g_varchar2) then
404: p_rec.transfer_to_grants_flag :=
405: pqh_bgt_shd.g_old_rec.transfer_to_grants_flag;
406: End If;
407: If (p_rec.status = hr_api.g_varchar2) then
408: p_rec.status :=
409: pqh_bgt_shd.g_old_rec.status;

Line 409: pqh_bgt_shd.g_old_rec.status;

405: pqh_bgt_shd.g_old_rec.transfer_to_grants_flag;
406: End If;
407: If (p_rec.status = hr_api.g_varchar2) then
408: p_rec.status :=
409: pqh_bgt_shd.g_old_rec.status;
410: End If;
411: If (p_rec.budget_unit1_id = hr_api.g_number) then
412: p_rec.budget_unit1_id :=
413: pqh_bgt_shd.g_old_rec.budget_unit1_id;

Line 413: pqh_bgt_shd.g_old_rec.budget_unit1_id;

409: pqh_bgt_shd.g_old_rec.status;
410: End If;
411: If (p_rec.budget_unit1_id = hr_api.g_number) then
412: p_rec.budget_unit1_id :=
413: pqh_bgt_shd.g_old_rec.budget_unit1_id;
414: End If;
415: If (p_rec.budget_unit2_id = hr_api.g_number) then
416: p_rec.budget_unit2_id :=
417: pqh_bgt_shd.g_old_rec.budget_unit2_id;

Line 417: pqh_bgt_shd.g_old_rec.budget_unit2_id;

413: pqh_bgt_shd.g_old_rec.budget_unit1_id;
414: End If;
415: If (p_rec.budget_unit2_id = hr_api.g_number) then
416: p_rec.budget_unit2_id :=
417: pqh_bgt_shd.g_old_rec.budget_unit2_id;
418: End If;
419: If (p_rec.budget_unit3_id = hr_api.g_number) then
420: p_rec.budget_unit3_id :=
421: pqh_bgt_shd.g_old_rec.budget_unit3_id;

Line 421: pqh_bgt_shd.g_old_rec.budget_unit3_id;

417: pqh_bgt_shd.g_old_rec.budget_unit2_id;
418: End If;
419: If (p_rec.budget_unit3_id = hr_api.g_number) then
420: p_rec.budget_unit3_id :=
421: pqh_bgt_shd.g_old_rec.budget_unit3_id;
422: End If;
423: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
424: p_rec.gl_set_of_books_id :=
425: pqh_bgt_shd.g_old_rec.gl_set_of_books_id;

Line 425: pqh_bgt_shd.g_old_rec.gl_set_of_books_id;

421: pqh_bgt_shd.g_old_rec.budget_unit3_id;
422: End If;
423: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
424: p_rec.gl_set_of_books_id :=
425: pqh_bgt_shd.g_old_rec.gl_set_of_books_id;
426: End If;
427: If (p_rec.budget_unit1_aggregate = hr_api.g_varchar2) then
428: p_rec.budget_unit1_aggregate :=
429: pqh_bgt_shd.g_old_rec.budget_unit1_aggregate;

Line 429: pqh_bgt_shd.g_old_rec.budget_unit1_aggregate;

425: pqh_bgt_shd.g_old_rec.gl_set_of_books_id;
426: End If;
427: If (p_rec.budget_unit1_aggregate = hr_api.g_varchar2) then
428: p_rec.budget_unit1_aggregate :=
429: pqh_bgt_shd.g_old_rec.budget_unit1_aggregate;
430: End If;
431: If (p_rec.budget_unit2_aggregate = hr_api.g_varchar2) then
432: p_rec.budget_unit2_aggregate :=
433: pqh_bgt_shd.g_old_rec.budget_unit2_aggregate;

Line 433: pqh_bgt_shd.g_old_rec.budget_unit2_aggregate;

429: pqh_bgt_shd.g_old_rec.budget_unit1_aggregate;
430: End If;
431: If (p_rec.budget_unit2_aggregate = hr_api.g_varchar2) then
432: p_rec.budget_unit2_aggregate :=
433: pqh_bgt_shd.g_old_rec.budget_unit2_aggregate;
434: End If;
435: If (p_rec.budget_unit3_aggregate = hr_api.g_varchar2) then
436: p_rec.budget_unit3_aggregate :=
437: pqh_bgt_shd.g_old_rec.budget_unit3_aggregate;

Line 437: pqh_bgt_shd.g_old_rec.budget_unit3_aggregate;

433: pqh_bgt_shd.g_old_rec.budget_unit2_aggregate;
434: End If;
435: If (p_rec.budget_unit3_aggregate = hr_api.g_varchar2) then
436: p_rec.budget_unit3_aggregate :=
437: pqh_bgt_shd.g_old_rec.budget_unit3_aggregate;
438: End If;
439: If (p_rec.position_control_flag = hr_api.g_varchar2) then
440: p_rec.position_control_flag :=
441: pqh_bgt_shd.g_old_rec.position_control_flag;

Line 441: pqh_bgt_shd.g_old_rec.position_control_flag;

437: pqh_bgt_shd.g_old_rec.budget_unit3_aggregate;
438: End If;
439: If (p_rec.position_control_flag = hr_api.g_varchar2) then
440: p_rec.position_control_flag :=
441: pqh_bgt_shd.g_old_rec.position_control_flag;
442: End If;
443: If (p_rec.valid_grade_reqd_flag = hr_api.g_varchar2) then
444: p_rec.valid_grade_reqd_flag :=
445: pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag;

Line 445: pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag;

441: pqh_bgt_shd.g_old_rec.position_control_flag;
442: End If;
443: If (p_rec.valid_grade_reqd_flag = hr_api.g_varchar2) then
444: p_rec.valid_grade_reqd_flag :=
445: pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag;
446: End If;
447: If (p_rec.currency_code = hr_api.g_varchar2) then
448: p_rec.currency_code :=
449: pqh_bgt_shd.g_old_rec.currency_code;

Line 449: pqh_bgt_shd.g_old_rec.currency_code;

445: pqh_bgt_shd.g_old_rec.valid_grade_reqd_flag;
446: End If;
447: If (p_rec.currency_code = hr_api.g_varchar2) then
448: p_rec.currency_code :=
449: pqh_bgt_shd.g_old_rec.currency_code;
450: End If;
451: If (p_rec.dflt_budget_set_id = hr_api.g_number) then
452: p_rec.dflt_budget_set_id :=
453: pqh_bgt_shd.g_old_rec.dflt_budget_set_id;

Line 453: pqh_bgt_shd.g_old_rec.dflt_budget_set_id;

449: pqh_bgt_shd.g_old_rec.currency_code;
450: End If;
451: If (p_rec.dflt_budget_set_id = hr_api.g_number) then
452: p_rec.dflt_budget_set_id :=
453: pqh_bgt_shd.g_old_rec.dflt_budget_set_id;
454: End If;
455:
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 467: p_rec in out nocopy pqh_bgt_shd.g_rec_type

463: -- ----------------------------------------------------------------------------
464: Procedure upd
465: (
466: p_effective_date in date,
467: p_rec in out nocopy pqh_bgt_shd.g_rec_type
468: ) is
469: --
470: l_proc varchar2(72) := g_package||'upd';
471: --

Line 477: pqh_bgt_shd.lck

473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- We must lock the row which we need to update.
476: --
477: pqh_bgt_shd.lck
478: (
479: p_rec.budget_id,
480: p_rec.object_version_number
481: );

Line 542: l_rec pqh_bgt_shd.g_rec_type;

538: p_currency_code in varchar2 default hr_api.g_varchar2,
539: p_dflt_budget_set_id in number default hr_api.g_number
540: ) is
541: --
542: l_rec pqh_bgt_shd.g_rec_type;
543: l_proc varchar2(72) := g_package||'upd';
544: --
545: Begin
546: hr_utility.set_location('Entering:'||l_proc, 5);

Line 552: pqh_bgt_shd.convert_args

548: -- Call conversion function to turn arguments into the
549: -- l_rec structure.
550: --
551: l_rec :=
552: pqh_bgt_shd.convert_args
553: (
554: p_budget_id,
555: p_business_group_id,
556: p_start_organization_id,