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_BFS_UPD dependencies on PQH_BFS_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_bfs_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_bfs_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 82: pqh_bfs_shd.constraint_error

78: --
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_bfs_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_bfs_shd.constraint_error

Line 86: pqh_bfs_shd.constraint_error

82: pqh_bfs_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_bfs_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then
89: -- Unique integrity has been violated
90: pqh_bfs_shd.constraint_error

Line 90: pqh_bfs_shd.constraint_error

86: pqh_bfs_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then
89: -- Unique integrity has been violated
90: pqh_bfs_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: Raise;
94: End update_dml;

Line 128: Procedure pre_update(p_rec in pqh_bfs_shd.g_rec_type) is

124: -- Internal Row Handler Use Only.
125: --
126: -- {End Of Comments}
127: -- ----------------------------------------------------------------------------
128: Procedure pre_update(p_rec in pqh_bfs_shd.g_rec_type) is
129: --
130: l_proc varchar2(72) := g_package||'pre_update';
131: --
132: Begin

Line 170: Procedure post_update(p_rec in pqh_bfs_shd.g_rec_type) is

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

Line 194: ,p_budget_element_id_o =>pqh_bfs_shd.g_old_rec.budget_element_id

190: ,p_expenditure_type =>p_rec.expenditure_type
191: ,p_organization_id =>p_rec.organization_id
192: ,p_distribution_percentage =>p_rec.distribution_percentage
193: ,p_object_version_number =>p_rec.object_version_number
194: ,p_budget_element_id_o =>pqh_bfs_shd.g_old_rec.budget_element_id
195: ,p_cost_allocation_keyflex_id_o =>pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id
196: ,p_project_id_o =>pqh_wfs_shd.g_old_rec.project_id
197: ,p_award_id_o =>pqh_wfs_shd.g_old_rec.award_id
198: ,p_task_id_o =>pqh_wfs_shd.g_old_rec.task_id

Line 195: ,p_cost_allocation_keyflex_id_o =>pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id

191: ,p_organization_id =>p_rec.organization_id
192: ,p_distribution_percentage =>p_rec.distribution_percentage
193: ,p_object_version_number =>p_rec.object_version_number
194: ,p_budget_element_id_o =>pqh_bfs_shd.g_old_rec.budget_element_id
195: ,p_cost_allocation_keyflex_id_o =>pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id
196: ,p_project_id_o =>pqh_wfs_shd.g_old_rec.project_id
197: ,p_award_id_o =>pqh_wfs_shd.g_old_rec.award_id
198: ,p_task_id_o =>pqh_wfs_shd.g_old_rec.task_id
199: ,p_expenditure_type_o =>pqh_wfs_shd.g_old_rec.expenditure_type

Line 201: ,p_distribution_percentage_o =>pqh_bfs_shd.g_old_rec.distribution_percentage

197: ,p_award_id_o =>pqh_wfs_shd.g_old_rec.award_id
198: ,p_task_id_o =>pqh_wfs_shd.g_old_rec.task_id
199: ,p_expenditure_type_o =>pqh_wfs_shd.g_old_rec.expenditure_type
200: ,p_organization_id_o =>pqh_wfs_shd.g_old_rec.organization_id
201: ,p_distribution_percentage_o =>pqh_bfs_shd.g_old_rec.distribution_percentage
202: ,p_object_version_number_o =>pqh_bfs_shd.g_old_rec.object_version_number
203: );
204: --
205: exception

Line 202: ,p_object_version_number_o =>pqh_bfs_shd.g_old_rec.object_version_number

198: ,p_task_id_o =>pqh_wfs_shd.g_old_rec.task_id
199: ,p_expenditure_type_o =>pqh_wfs_shd.g_old_rec.expenditure_type
200: ,p_organization_id_o =>pqh_wfs_shd.g_old_rec.organization_id
201: ,p_distribution_percentage_o =>pqh_bfs_shd.g_old_rec.distribution_percentage
202: ,p_object_version_number_o =>pqh_bfs_shd.g_old_rec.object_version_number
203: );
204: --
205: exception
206: --

Line 264: Procedure convert_defs(p_rec in out nocopy pqh_bfs_shd.g_rec_type) is

260: -- Internal Row Handler Use Only.
261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure convert_defs(p_rec in out nocopy pqh_bfs_shd.g_rec_type) is
265: --
266: l_proc varchar2(72) := g_package||'convert_defs';
267: --
268: Begin

Line 279: pqh_bfs_shd.g_old_rec.budget_element_id;

275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.budget_element_id = hr_api.g_number) then
278: p_rec.budget_element_id :=
279: pqh_bfs_shd.g_old_rec.budget_element_id;
280: End If;
281: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
282: p_rec.cost_allocation_keyflex_id :=
283: pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id;

Line 283: pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id;

279: pqh_bfs_shd.g_old_rec.budget_element_id;
280: End If;
281: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
282: p_rec.cost_allocation_keyflex_id :=
283: pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id;
284: End If;
285: If (p_rec.distribution_percentage = hr_api.g_number) then
286: p_rec.distribution_percentage :=
287: pqh_bfs_shd.g_old_rec.distribution_percentage;

Line 287: pqh_bfs_shd.g_old_rec.distribution_percentage;

283: pqh_bfs_shd.g_old_rec.cost_allocation_keyflex_id;
284: End If;
285: If (p_rec.distribution_percentage = hr_api.g_number) then
286: p_rec.distribution_percentage :=
287: pqh_bfs_shd.g_old_rec.distribution_percentage;
288: End If;
289: If (p_rec.project_id = hr_api.g_number) then
290: p_rec.project_id :=
291: pqh_bfs_shd.g_old_rec.project_id;

Line 291: pqh_bfs_shd.g_old_rec.project_id;

287: pqh_bfs_shd.g_old_rec.distribution_percentage;
288: End If;
289: If (p_rec.project_id = hr_api.g_number) then
290: p_rec.project_id :=
291: pqh_bfs_shd.g_old_rec.project_id;
292: End If;
293: If (p_rec.award_id = hr_api.g_number) then
294: p_rec.award_id :=
295: pqh_bfs_shd.g_old_rec.award_id;

Line 295: pqh_bfs_shd.g_old_rec.award_id;

291: pqh_bfs_shd.g_old_rec.project_id;
292: End If;
293: If (p_rec.award_id = hr_api.g_number) then
294: p_rec.award_id :=
295: pqh_bfs_shd.g_old_rec.award_id;
296: End If;
297: If (p_rec.task_id = hr_api.g_number) then
298: p_rec.task_id :=
299: pqh_bfs_shd.g_old_rec.task_id;

Line 299: pqh_bfs_shd.g_old_rec.task_id;

295: pqh_bfs_shd.g_old_rec.award_id;
296: End If;
297: If (p_rec.task_id = hr_api.g_number) then
298: p_rec.task_id :=
299: pqh_bfs_shd.g_old_rec.task_id;
300: End If;
301: If (p_rec.expenditure_type = hr_api.g_varchar2) then
302: p_rec.expenditure_type :=
303: pqh_bfs_shd.g_old_rec.expenditure_type;

Line 303: pqh_bfs_shd.g_old_rec.expenditure_type;

299: pqh_bfs_shd.g_old_rec.task_id;
300: End If;
301: If (p_rec.expenditure_type = hr_api.g_varchar2) then
302: p_rec.expenditure_type :=
303: pqh_bfs_shd.g_old_rec.expenditure_type;
304: End If;
305: If (p_rec.organization_id = hr_api.g_number) then
306: p_rec.organization_id :=
307: pqh_bfs_shd.g_old_rec.organization_id;

Line 307: pqh_bfs_shd.g_old_rec.organization_id;

303: pqh_bfs_shd.g_old_rec.expenditure_type;
304: End If;
305: If (p_rec.organization_id = hr_api.g_number) then
306: p_rec.organization_id :=
307: pqh_bfs_shd.g_old_rec.organization_id;
308: End If;
309:
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 320: p_rec in out nocopy pqh_bfs_shd.g_rec_type

316: -- |---------------------------------< upd >----------------------------------|
317: -- ----------------------------------------------------------------------------
318: Procedure upd
319: (
320: p_rec in out nocopy pqh_bfs_shd.g_rec_type
321: ) is
322: --
323: l_proc varchar2(72) := g_package||'upd';
324: --

Line 330: pqh_bfs_shd.lck

326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: -- We must lock the row which we need to update.
329: --
330: pqh_bfs_shd.lck
331: (
332: p_rec.budget_fund_src_id,
333: p_rec.object_version_number
334: );

Line 375: l_rec pqh_bfs_shd.g_rec_type;

371: p_distribution_percentage in number default hr_api.g_number,
372: p_object_version_number in out nocopy number
373: ) is
374: --
375: l_rec pqh_bfs_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'upd';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: pqh_bfs_shd.convert_args

381: -- Call conversion function to turn arguments into the
382: -- l_rec structure.
383: --
384: l_rec :=
385: pqh_bfs_shd.convert_args
386: (
387: p_budget_fund_src_id,
388: p_budget_element_id,
389: p_cost_allocation_keyflex_id,