APPS.PQH_DFS_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_dfs_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_dfs_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_dfs_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_dfs_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_dfs_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_dfs_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_dfs_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_dfs_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_dfs_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_dfs_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 229: when hr_api.cannot_find_prog_unit then

225: );
226: --
227: exception
228: --
229: when hr_api.cannot_find_prog_unit then
230: --
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'pqh_dflt_fund_srcs'
233: ,p_hook_type => 'AU');

Line 231: hr_api.cannot_find_prog_unit_error

227: exception
228: --
229: when hr_api.cannot_find_prog_unit then
230: --
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'pqh_dflt_fund_srcs'
233: ,p_hook_type => 'AU');
234: --
235: end;

Line 299: If (p_rec.dflt_budget_element_id = hr_api.g_number) then

295: -- p_rec plsql record structure
296: -- to see if a system default is being used. If a system default
297: -- is being used then we must set to the 'current' argument value.
298: --
299: If (p_rec.dflt_budget_element_id = hr_api.g_number) then
300: p_rec.dflt_budget_element_id :=
301: pqh_dfs_shd.g_old_rec.dflt_budget_element_id;
302: End If;
303: If (p_rec.dflt_dist_percentage = hr_api.g_number) then

Line 303: If (p_rec.dflt_dist_percentage = hr_api.g_number) then

299: If (p_rec.dflt_budget_element_id = hr_api.g_number) then
300: p_rec.dflt_budget_element_id :=
301: pqh_dfs_shd.g_old_rec.dflt_budget_element_id;
302: End If;
303: If (p_rec.dflt_dist_percentage = hr_api.g_number) then
304: p_rec.dflt_dist_percentage :=
305: pqh_dfs_shd.g_old_rec.dflt_dist_percentage;
306: End If;
307: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then

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

303: If (p_rec.dflt_dist_percentage = hr_api.g_number) then
304: p_rec.dflt_dist_percentage :=
305: pqh_dfs_shd.g_old_rec.dflt_dist_percentage;
306: End If;
307: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
308: p_rec.cost_allocation_keyflex_id :=
309: pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id;
310: End If;
311: If (p_rec.project_id = hr_api.g_number) then

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

307: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
308: p_rec.cost_allocation_keyflex_id :=
309: pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id;
310: End If;
311: If (p_rec.project_id = hr_api.g_number) then
312: p_rec.project_id :=
313: pqh_dfs_shd.g_old_rec.project_id;
314: End If;
315: If (p_rec.award_id = hr_api.g_number) then

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

311: If (p_rec.project_id = hr_api.g_number) then
312: p_rec.project_id :=
313: pqh_dfs_shd.g_old_rec.project_id;
314: End If;
315: If (p_rec.award_id = hr_api.g_number) then
316: p_rec.award_id :=
317: pqh_dfs_shd.g_old_rec.award_id;
318: End If;
319: If (p_rec.task_id = hr_api.g_number) then

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

315: If (p_rec.award_id = hr_api.g_number) then
316: p_rec.award_id :=
317: pqh_dfs_shd.g_old_rec.award_id;
318: End If;
319: If (p_rec.task_id = hr_api.g_number) then
320: p_rec.task_id :=
321: pqh_dfs_shd.g_old_rec.task_id;
322: End If;
323: If (p_rec.expenditure_type = hr_api.g_varchar2) then

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

319: If (p_rec.task_id = hr_api.g_number) then
320: p_rec.task_id :=
321: pqh_dfs_shd.g_old_rec.task_id;
322: End If;
323: If (p_rec.expenditure_type = hr_api.g_varchar2) then
324: p_rec.expenditure_type :=
325: pqh_dfs_shd.g_old_rec.expenditure_type;
326: End If;
327: If (p_rec.organization_id = hr_api.g_number) then

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

323: If (p_rec.expenditure_type = hr_api.g_varchar2) then
324: p_rec.expenditure_type :=
325: pqh_dfs_shd.g_old_rec.expenditure_type;
326: End If;
327: If (p_rec.organization_id = hr_api.g_number) then
328: p_rec.organization_id :=
329: pqh_dfs_shd.g_old_rec.organization_id;
330: End If;
331: --

Line 385: p_dflt_budget_element_id in number default hr_api.g_number,

381: -- ----------------------------------------------------------------------------
382: Procedure upd
383: (
384: p_dflt_fund_src_id in number,
385: p_dflt_budget_element_id in number default hr_api.g_number,
386: p_dflt_dist_percentage in number default hr_api.g_number,
387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,

Line 386: p_dflt_dist_percentage in number default hr_api.g_number,

382: Procedure upd
383: (
384: p_dflt_fund_src_id in number,
385: p_dflt_budget_element_id in number default hr_api.g_number,
386: p_dflt_dist_percentage in number default hr_api.g_number,
387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,

Line 387: p_project_id in number default hr_api.g_number,

383: (
384: p_dflt_fund_src_id in number,
385: p_dflt_budget_element_id in number default hr_api.g_number,
386: p_dflt_dist_percentage in number default hr_api.g_number,
387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,
391: p_organization_id in number default hr_api.g_number,

Line 388: p_award_id in number default hr_api.g_number,

384: p_dflt_fund_src_id in number,
385: p_dflt_budget_element_id in number default hr_api.g_number,
386: p_dflt_dist_percentage in number default hr_api.g_number,
387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,
391: p_organization_id in number default hr_api.g_number,
392: p_object_version_number in out nocopy number,

Line 389: p_task_id in number default hr_api.g_number,

385: p_dflt_budget_element_id in number default hr_api.g_number,
386: p_dflt_dist_percentage in number default hr_api.g_number,
387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,
391: p_organization_id in number default hr_api.g_number,
392: p_object_version_number in out nocopy number,
393: p_cost_allocation_keyflex_id in number default hr_api.g_number

Line 390: p_expenditure_type in varchar2 default hr_api.g_varchar2,

386: p_dflt_dist_percentage in number default hr_api.g_number,
387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,
391: p_organization_id in number default hr_api.g_number,
392: p_object_version_number in out nocopy number,
393: p_cost_allocation_keyflex_id in number default hr_api.g_number
394: ) is

Line 391: p_organization_id in number default hr_api.g_number,

387: p_project_id in number default hr_api.g_number,
388: p_award_id in number default hr_api.g_number,
389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,
391: p_organization_id in number default hr_api.g_number,
392: p_object_version_number in out nocopy number,
393: p_cost_allocation_keyflex_id in number default hr_api.g_number
394: ) is
395: --

Line 393: p_cost_allocation_keyflex_id in number default hr_api.g_number

389: p_task_id in number default hr_api.g_number,
390: p_expenditure_type in varchar2 default hr_api.g_varchar2,
391: p_organization_id in number default hr_api.g_number,
392: p_object_version_number in out nocopy number,
393: p_cost_allocation_keyflex_id in number default hr_api.g_number
394: ) is
395: --
396: l_rec pqh_dfs_shd.g_rec_type;
397: l_proc varchar2(72) := g_package||'upd';