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_WFS_UPD dependencies on HR_API

Line 80: When hr_api.check_integrity_violated Then

76: --
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: --
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_wfs_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then

Line 83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_wfs_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_wfs_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 84: When hr_api.parent_integrity_violated Then

80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_wfs_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_wfs_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then

Line 87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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_wfs_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_wfs_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 88: When hr_api.unique_integrity_violated Then

84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_wfs_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_wfs_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then

Line 91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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_wfs_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: Raise;
94: End update_dml;
95: --

Line 207: when hr_api.cannot_find_prog_unit then

203: );
204: --
205: exception
206: --
207: when hr_api.cannot_find_prog_unit then
208: --
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'pqh_worksheet_fund_srcs'
211: ,p_hook_type => 'AU');

Line 209: hr_api.cannot_find_prog_unit_error

205: exception
206: --
207: when hr_api.cannot_find_prog_unit then
208: --
209: hr_api.cannot_find_prog_unit_error
210: (p_module_name => 'pqh_worksheet_fund_srcs'
211: ,p_hook_type => 'AU');
212: --
213: end;

Line 277: If (p_rec.worksheet_bdgt_elmnt_id = hr_api.g_number) then

273: -- p_rec plsql record structure
274: -- to see if a system default is being used. If a system default
275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.worksheet_bdgt_elmnt_id = hr_api.g_number) then
278: p_rec.worksheet_bdgt_elmnt_id :=
279: pqh_wfs_shd.g_old_rec.worksheet_bdgt_elmnt_id;
280: End If;
281: If (p_rec.distribution_percentage = hr_api.g_number) then

Line 281: If (p_rec.distribution_percentage = hr_api.g_number) then

277: If (p_rec.worksheet_bdgt_elmnt_id = hr_api.g_number) then
278: p_rec.worksheet_bdgt_elmnt_id :=
279: pqh_wfs_shd.g_old_rec.worksheet_bdgt_elmnt_id;
280: End If;
281: If (p_rec.distribution_percentage = hr_api.g_number) then
282: p_rec.distribution_percentage :=
283: pqh_wfs_shd.g_old_rec.distribution_percentage;
284: End If;
285: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then

Line 285: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then

281: If (p_rec.distribution_percentage = hr_api.g_number) then
282: p_rec.distribution_percentage :=
283: pqh_wfs_shd.g_old_rec.distribution_percentage;
284: End If;
285: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
286: p_rec.cost_allocation_keyflex_id :=
287: pqh_wfs_shd.g_old_rec.cost_allocation_keyflex_id;
288: End If;
289: If (p_rec.project_id = hr_api.g_number) then

Line 289: If (p_rec.project_id = hr_api.g_number) then

285: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
286: p_rec.cost_allocation_keyflex_id :=
287: pqh_wfs_shd.g_old_rec.cost_allocation_keyflex_id;
288: End If;
289: If (p_rec.project_id = hr_api.g_number) then
290: p_rec.project_id :=
291: pqh_wfs_shd.g_old_rec.project_id;
292: End If;
293: If (p_rec.award_id = hr_api.g_number) then

Line 293: If (p_rec.award_id = hr_api.g_number) then

289: If (p_rec.project_id = hr_api.g_number) then
290: p_rec.project_id :=
291: pqh_wfs_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_wfs_shd.g_old_rec.award_id;
296: End If;
297: If (p_rec.task_id = hr_api.g_number) then

Line 297: If (p_rec.task_id = hr_api.g_number) then

293: If (p_rec.award_id = hr_api.g_number) then
294: p_rec.award_id :=
295: pqh_wfs_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_wfs_shd.g_old_rec.task_id;
300: End If;
301: If (p_rec.expenditure_type = hr_api.g_varchar2) then

Line 301: If (p_rec.expenditure_type = hr_api.g_varchar2) then

297: If (p_rec.task_id = hr_api.g_number) then
298: p_rec.task_id :=
299: pqh_wfs_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_wfs_shd.g_old_rec.expenditure_type;
304: End If;
305: If (p_rec.organization_id = hr_api.g_number) then

Line 305: If (p_rec.organization_id = hr_api.g_number) then

301: If (p_rec.expenditure_type = hr_api.g_varchar2) then
302: p_rec.expenditure_type :=
303: pqh_wfs_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_wfs_shd.g_old_rec.organization_id;
308: End If;
309:

Line 364: p_worksheet_bdgt_elmnt_id in number default hr_api.g_number,

360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (
363: p_worksheet_fund_src_id in number,
364: p_worksheet_bdgt_elmnt_id in number default hr_api.g_number,
365: p_distribution_percentage in number default hr_api.g_number,
366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,

Line 365: p_distribution_percentage in number default hr_api.g_number,

361: Procedure upd
362: (
363: p_worksheet_fund_src_id in number,
364: p_worksheet_bdgt_elmnt_id in number default hr_api.g_number,
365: p_distribution_percentage in number default hr_api.g_number,
366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,

Line 366: p_cost_allocation_keyflex_id in number default hr_api.g_number,

362: (
363: p_worksheet_fund_src_id in number,
364: p_worksheet_bdgt_elmnt_id in number default hr_api.g_number,
365: p_distribution_percentage in number default hr_api.g_number,
366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,
370: p_expenditure_type in varchar2 default hr_api.g_varchar2,

Line 367: p_project_id in number default hr_api.g_number,

363: p_worksheet_fund_src_id in number,
364: p_worksheet_bdgt_elmnt_id in number default hr_api.g_number,
365: p_distribution_percentage in number default hr_api.g_number,
366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,
370: p_expenditure_type in varchar2 default hr_api.g_varchar2,
371: p_organization_id in number default hr_api.g_number,

Line 368: p_award_id in number default hr_api.g_number,

364: p_worksheet_bdgt_elmnt_id in number default hr_api.g_number,
365: p_distribution_percentage in number default hr_api.g_number,
366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,
370: p_expenditure_type in varchar2 default hr_api.g_varchar2,
371: p_organization_id in number default hr_api.g_number,
372: p_object_version_number in out nocopy number

Line 369: p_task_id in number default hr_api.g_number,

365: p_distribution_percentage in number default hr_api.g_number,
366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,
370: p_expenditure_type in varchar2 default hr_api.g_varchar2,
371: p_organization_id in number default hr_api.g_number,
372: p_object_version_number in out nocopy number
373: ) is

Line 370: p_expenditure_type in varchar2 default hr_api.g_varchar2,

366: p_cost_allocation_keyflex_id in number default hr_api.g_number,
367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,
370: p_expenditure_type in varchar2 default hr_api.g_varchar2,
371: p_organization_id in number default hr_api.g_number,
372: p_object_version_number in out nocopy number
373: ) is
374: --

Line 371: p_organization_id in number default hr_api.g_number,

367: p_project_id in number default hr_api.g_number,
368: p_award_id in number default hr_api.g_number,
369: p_task_id in number default hr_api.g_number,
370: p_expenditure_type in varchar2 default hr_api.g_varchar2,
371: p_organization_id in number default hr_api.g_number,
372: p_object_version_number in out nocopy number
373: ) is
374: --
375: l_rec pqh_wfs_shd.g_rec_type;