DBA Data[Home] [Help]

APPS.PQH_BVR_UPD dependencies on PQH_BVR_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pqh_bvr_shd.g_rec_type) is

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

Line 90: pqh_bvr_shd.constraint_error

86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: pqh_bvr_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: pqh_bvr_shd.constraint_error

Line 94: pqh_bvr_shd.constraint_error

90: pqh_bvr_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: pqh_bvr_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: pqh_bvr_shd.constraint_error

Line 98: pqh_bvr_shd.constraint_error

94: pqh_bvr_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: pqh_bvr_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: Raise;
102: End update_dml;

Line 136: Procedure pre_update(p_rec in pqh_bvr_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in pqh_bvr_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 179: p_effective_date in date,p_rec in pqh_bvr_shd.g_rec_type) is

175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(
179: p_effective_date in date,p_rec in pqh_bvr_shd.g_rec_type) is
180: --
181: l_proc varchar2(72) := g_package||'post_update';
182:
183:

Line 254: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id

250: ,p_budget_unit1_available =>p_rec.budget_unit1_available
251: ,p_budget_unit2_available =>p_rec.budget_unit2_available
252: ,p_budget_unit3_available =>p_rec.budget_unit3_available
253: ,p_effective_date =>p_effective_date
254: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag

Line 255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number

251: ,p_budget_unit2_available =>p_rec.budget_unit2_available
252: ,p_budget_unit3_available =>p_rec.budget_unit3_available
253: ,p_effective_date =>p_effective_date
254: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status

Line 256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from

252: ,p_budget_unit3_available =>p_rec.budget_unit3_available
253: ,p_effective_date =>p_effective_date
254: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd

Line 257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to

253: ,p_effective_date =>p_effective_date
254: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number

Line 258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag

254: ,p_budget_id_o =>pqh_bvr_shd.g_old_rec.budget_id
255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value

Line 259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status

255: ,p_version_number_o =>pqh_bvr_shd.g_old_rec.version_number
256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value

Line 260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd

256: ,p_date_from_o =>pqh_bvr_shd.g_old_rec.date_from
257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value

Line 261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number

257: ,p_date_to_o =>pqh_bvr_shd.g_old_rec.date_to
258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available

Line 262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value

258: ,p_transfered_to_gl_flag_o =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available

Line 263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value

259: ,p_gl_status_o =>pqh_bvr_shd.g_old_rec.gl_status
260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
267: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available

Line 264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value

260: ,p_xfer_to_other_apps_cd_o =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
267: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
268: );

Line 265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available

261: ,p_object_version_number_o =>pqh_bvr_shd.g_old_rec.object_version_number
262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
267: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
268: );
269: --

Line 266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available

262: ,p_budget_unit1_value_o =>pqh_bvr_shd.g_old_rec.budget_unit1_value
263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
267: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
268: );
269: --
270: exception

Line 267: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available

263: ,p_budget_unit2_value_o =>pqh_bvr_shd.g_old_rec.budget_unit2_value
264: ,p_budget_unit3_value_o =>pqh_bvr_shd.g_old_rec.budget_unit3_value
265: ,p_budget_unit1_available_o =>pqh_bvr_shd.g_old_rec.budget_unit1_available
266: ,p_budget_unit2_available_o =>pqh_bvr_shd.g_old_rec.budget_unit2_available
267: ,p_budget_unit3_available_o =>pqh_bvr_shd.g_old_rec.budget_unit3_available
268: );
269: --
270: exception
271: --

Line 329: Procedure convert_defs(p_rec in out nocopy pqh_bvr_shd.g_rec_type) is

325: -- Internal Row Handler Use Only.
326: --
327: -- {End Of Comments}
328: -- ----------------------------------------------------------------------------
329: Procedure convert_defs(p_rec in out nocopy pqh_bvr_shd.g_rec_type) is
330: --
331: l_proc varchar2(72) := g_package||'convert_defs';
332: --
333: Begin

Line 344: pqh_bvr_shd.g_old_rec.budget_id;

340: -- is being used then we must set to the 'current' argument value.
341: --
342: If (p_rec.budget_id = hr_api.g_number) then
343: p_rec.budget_id :=
344: pqh_bvr_shd.g_old_rec.budget_id;
345: End If;
346: If (p_rec.version_number = hr_api.g_number) then
347: p_rec.version_number :=
348: pqh_bvr_shd.g_old_rec.version_number;

Line 348: pqh_bvr_shd.g_old_rec.version_number;

344: pqh_bvr_shd.g_old_rec.budget_id;
345: End If;
346: If (p_rec.version_number = hr_api.g_number) then
347: p_rec.version_number :=
348: pqh_bvr_shd.g_old_rec.version_number;
349: End If;
350: If (p_rec.date_from = hr_api.g_date) then
351: p_rec.date_from :=
352: pqh_bvr_shd.g_old_rec.date_from;

Line 352: pqh_bvr_shd.g_old_rec.date_from;

348: pqh_bvr_shd.g_old_rec.version_number;
349: End If;
350: If (p_rec.date_from = hr_api.g_date) then
351: p_rec.date_from :=
352: pqh_bvr_shd.g_old_rec.date_from;
353: End If;
354: If (p_rec.date_to = hr_api.g_date) then
355: p_rec.date_to :=
356: pqh_bvr_shd.g_old_rec.date_to;

Line 356: pqh_bvr_shd.g_old_rec.date_to;

352: pqh_bvr_shd.g_old_rec.date_from;
353: End If;
354: If (p_rec.date_to = hr_api.g_date) then
355: p_rec.date_to :=
356: pqh_bvr_shd.g_old_rec.date_to;
357: End If;
358: If (p_rec.transfered_to_gl_flag = hr_api.g_varchar2) then
359: p_rec.transfered_to_gl_flag :=
360: pqh_bvr_shd.g_old_rec.transfered_to_gl_flag;

Line 360: pqh_bvr_shd.g_old_rec.transfered_to_gl_flag;

356: pqh_bvr_shd.g_old_rec.date_to;
357: End If;
358: If (p_rec.transfered_to_gl_flag = hr_api.g_varchar2) then
359: p_rec.transfered_to_gl_flag :=
360: pqh_bvr_shd.g_old_rec.transfered_to_gl_flag;
361: End If;
362: If (p_rec.gl_status = hr_api.g_varchar2) then
363: p_rec.gl_status :=
364: pqh_bvr_shd.g_old_rec.gl_status;

Line 364: pqh_bvr_shd.g_old_rec.gl_status;

360: pqh_bvr_shd.g_old_rec.transfered_to_gl_flag;
361: End If;
362: If (p_rec.gl_status = hr_api.g_varchar2) then
363: p_rec.gl_status :=
364: pqh_bvr_shd.g_old_rec.gl_status;
365: End If;
366: If (p_rec.xfer_to_other_apps_cd = hr_api.g_varchar2) then
367: p_rec.xfer_to_other_apps_cd :=
368: pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd;

Line 368: pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd;

364: pqh_bvr_shd.g_old_rec.gl_status;
365: End If;
366: If (p_rec.xfer_to_other_apps_cd = hr_api.g_varchar2) then
367: p_rec.xfer_to_other_apps_cd :=
368: pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd;
369: End If;
370: If (p_rec.budget_unit1_value = hr_api.g_number) then
371: p_rec.budget_unit1_value :=
372: pqh_bvr_shd.g_old_rec.budget_unit1_value;

Line 372: pqh_bvr_shd.g_old_rec.budget_unit1_value;

368: pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd;
369: End If;
370: If (p_rec.budget_unit1_value = hr_api.g_number) then
371: p_rec.budget_unit1_value :=
372: pqh_bvr_shd.g_old_rec.budget_unit1_value;
373: End If;
374: If (p_rec.budget_unit2_value = hr_api.g_number) then
375: p_rec.budget_unit2_value :=
376: pqh_bvr_shd.g_old_rec.budget_unit2_value;

Line 376: pqh_bvr_shd.g_old_rec.budget_unit2_value;

372: pqh_bvr_shd.g_old_rec.budget_unit1_value;
373: End If;
374: If (p_rec.budget_unit2_value = hr_api.g_number) then
375: p_rec.budget_unit2_value :=
376: pqh_bvr_shd.g_old_rec.budget_unit2_value;
377: End If;
378: If (p_rec.budget_unit3_value = hr_api.g_number) then
379: p_rec.budget_unit3_value :=
380: pqh_bvr_shd.g_old_rec.budget_unit3_value;

Line 380: pqh_bvr_shd.g_old_rec.budget_unit3_value;

376: pqh_bvr_shd.g_old_rec.budget_unit2_value;
377: End If;
378: If (p_rec.budget_unit3_value = hr_api.g_number) then
379: p_rec.budget_unit3_value :=
380: pqh_bvr_shd.g_old_rec.budget_unit3_value;
381: End If;
382: If (p_rec.budget_unit1_available = hr_api.g_number) then
383: p_rec.budget_unit1_available :=
384: pqh_bvr_shd.g_old_rec.budget_unit1_available;

Line 384: pqh_bvr_shd.g_old_rec.budget_unit1_available;

380: pqh_bvr_shd.g_old_rec.budget_unit3_value;
381: End If;
382: If (p_rec.budget_unit1_available = hr_api.g_number) then
383: p_rec.budget_unit1_available :=
384: pqh_bvr_shd.g_old_rec.budget_unit1_available;
385: End If;
386: If (p_rec.budget_unit2_available = hr_api.g_number) then
387: p_rec.budget_unit2_available :=
388: pqh_bvr_shd.g_old_rec.budget_unit2_available;

Line 388: pqh_bvr_shd.g_old_rec.budget_unit2_available;

384: pqh_bvr_shd.g_old_rec.budget_unit1_available;
385: End If;
386: If (p_rec.budget_unit2_available = hr_api.g_number) then
387: p_rec.budget_unit2_available :=
388: pqh_bvr_shd.g_old_rec.budget_unit2_available;
389: End If;
390: If (p_rec.budget_unit3_available = hr_api.g_number) then
391: p_rec.budget_unit3_available :=
392: pqh_bvr_shd.g_old_rec.budget_unit3_available;

Line 392: pqh_bvr_shd.g_old_rec.budget_unit3_available;

388: pqh_bvr_shd.g_old_rec.budget_unit2_available;
389: End If;
390: If (p_rec.budget_unit3_available = hr_api.g_number) then
391: p_rec.budget_unit3_available :=
392: pqh_bvr_shd.g_old_rec.budget_unit3_available;
393: End If;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: --

Line 405: p_rec in out nocopy pqh_bvr_shd.g_rec_type

401: -- ----------------------------------------------------------------------------
402: Procedure upd
403: (
404: p_effective_date in date,
405: p_rec in out nocopy pqh_bvr_shd.g_rec_type
406: ) is
407: --
408: l_proc varchar2(72) := g_package||'upd';
409: --

Line 415: pqh_bvr_shd.lck

411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: -- We must lock the row which we need to update.
414: --
415: pqh_bvr_shd.lck
416: (
417: p_rec.budget_version_id,
418: p_rec.object_version_number
419: );

Line 468: l_rec pqh_bvr_shd.g_rec_type;

464: p_budget_unit2_available in number default hr_api.g_number,
465: p_budget_unit3_available in number default hr_api.g_number
466: ) is
467: --
468: l_rec pqh_bvr_shd.g_rec_type;
469: l_proc varchar2(72) := g_package||'upd';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);

Line 478: pqh_bvr_shd.convert_args

474: -- Call conversion function to turn arguments into the
475: -- l_rec structure.
476: --
477: l_rec :=
478: pqh_bvr_shd.convert_args
479: (
480: p_budget_version_id,
481: p_budget_id,
482: p_version_number,