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.PER_PCE_UPD dependencies on HR_API

Line 89: WHEN hr_api.check_integrity_violated THEN

85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: EXCEPTION
89: WHEN hr_api.check_integrity_violated THEN
90: -- A check constraint has been violated
91: --
92: per_pce_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

89: WHEN hr_api.check_integrity_violated THEN
90: -- A check constraint has been violated
91: --
92: per_pce_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: WHEN hr_api.parent_integrity_violated THEN
95: -- Parent integrity has been violated
96: --
97: per_pce_shd.constraint_error

Line 94: WHEN hr_api.parent_integrity_violated THEN

90: -- A check constraint has been violated
91: --
92: per_pce_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: WHEN hr_api.parent_integrity_violated THEN
95: -- Parent integrity has been violated
96: --
97: per_pce_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

94: WHEN hr_api.parent_integrity_violated THEN
95: -- Parent integrity has been violated
96: --
97: per_pce_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: WHEN hr_api.unique_integrity_violated THEN
100: -- Unique integrity has been violated
101: --
102: per_pce_shd.constraint_error

Line 99: WHEN hr_api.unique_integrity_violated THEN

95: -- Parent integrity has been violated
96: --
97: per_pce_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: WHEN hr_api.unique_integrity_violated THEN
100: -- Unique integrity has been violated
101: --
102: per_pce_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

99: WHEN hr_api.unique_integrity_violated THEN
100: -- Unique integrity has been violated
101: --
102: per_pce_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: WHEN Others THEN
105: --
106: RAISE;
107: END update_dml;

Line 223: when hr_api.cannot_find_prog_unit then

219: );
220: --
221: exception
222: --
223: when hr_api.cannot_find_prog_unit then
224: --
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'PER_CAGR_ENTITLEMENTS'
227: ,p_hook_type => 'AU');

Line 225: hr_api.cannot_find_prog_unit_error

221: exception
222: --
223: when hr_api.cannot_find_prog_unit then
224: --
225: hr_api.cannot_find_prog_unit_error
226: (p_module_name => 'PER_CAGR_ENTITLEMENTS'
227: ,p_hook_type => 'AU');
228: --
229: end;

Line 288: If (p_rec.cagr_entitlement_item_id = hr_api.g_number) then

284: -- p_rec plsql record structure
285: -- to see if a system DEFAULT IS being used. If a system DEFAULT
286: -- IS being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.cagr_entitlement_item_id = hr_api.g_number) then
289: p_rec.cagr_entitlement_item_id :=
290: per_pce_shd.g_old_rec.cagr_entitlement_item_id;
291: END If;
292: If (p_rec.collective_agreement_id = hr_api.g_number) then

Line 292: If (p_rec.collective_agreement_id = hr_api.g_number) then

288: If (p_rec.cagr_entitlement_item_id = hr_api.g_number) then
289: p_rec.cagr_entitlement_item_id :=
290: per_pce_shd.g_old_rec.cagr_entitlement_item_id;
291: END If;
292: If (p_rec.collective_agreement_id = hr_api.g_number) then
293: p_rec.collective_agreement_id :=
294: per_pce_shd.g_old_rec.collective_agreement_id;
295: END If;
296: If (p_rec.start_date = hr_api.g_date) then

Line 296: If (p_rec.start_date = hr_api.g_date) then

292: If (p_rec.collective_agreement_id = hr_api.g_number) then
293: p_rec.collective_agreement_id :=
294: per_pce_shd.g_old_rec.collective_agreement_id;
295: END If;
296: If (p_rec.start_date = hr_api.g_date) then
297: p_rec.start_date :=
298: per_pce_shd.g_old_rec.start_date;
299: END If;
300: If (p_rec.end_date = hr_api.g_date) then

Line 300: If (p_rec.end_date = hr_api.g_date) then

296: If (p_rec.start_date = hr_api.g_date) then
297: p_rec.start_date :=
298: per_pce_shd.g_old_rec.start_date;
299: END If;
300: If (p_rec.end_date = hr_api.g_date) then
301: p_rec.end_date :=
302: per_pce_shd.g_old_rec.end_date;
303: END If;
304: If (p_rec.status = hr_api.g_VARCHAR2) then

Line 304: If (p_rec.status = hr_api.g_VARCHAR2) then

300: If (p_rec.end_date = hr_api.g_date) then
301: p_rec.end_date :=
302: per_pce_shd.g_old_rec.end_date;
303: END If;
304: If (p_rec.status = hr_api.g_VARCHAR2) then
305: p_rec.status :=
306: per_pce_shd.g_old_rec.status;
307: END If;
308: If (p_rec.formula_criteria = hr_api.g_VARCHAR2) then

Line 308: If (p_rec.formula_criteria = hr_api.g_VARCHAR2) then

304: If (p_rec.status = hr_api.g_VARCHAR2) then
305: p_rec.status :=
306: per_pce_shd.g_old_rec.status;
307: END If;
308: If (p_rec.formula_criteria = hr_api.g_VARCHAR2) then
309: p_rec.formula_criteria :=
310: per_pce_shd.g_old_rec.formula_criteria;
311: END If;
312: If (p_rec.formula_id = hr_api.g_number) then

Line 312: If (p_rec.formula_id = hr_api.g_number) then

308: If (p_rec.formula_criteria = hr_api.g_VARCHAR2) then
309: p_rec.formula_criteria :=
310: per_pce_shd.g_old_rec.formula_criteria;
311: END If;
312: If (p_rec.formula_id = hr_api.g_number) then
313: p_rec.formula_id :=
314: per_pce_shd.g_old_rec.formula_id;
315: END If;
316: If (p_rec.units_of_measure = hr_api.g_VARCHAR2) then

Line 316: If (p_rec.units_of_measure = hr_api.g_VARCHAR2) then

312: If (p_rec.formula_id = hr_api.g_number) then
313: p_rec.formula_id :=
314: per_pce_shd.g_old_rec.formula_id;
315: END If;
316: If (p_rec.units_of_measure = hr_api.g_VARCHAR2) then
317: p_rec.units_of_measure := per_pce_shd.g_old_rec.units_of_measure;
318: END If;
319: --
320: IF (p_rec.message_level = hr_api.g_VARCHAR2) then

Line 320: IF (p_rec.message_level = hr_api.g_VARCHAR2) then

316: If (p_rec.units_of_measure = hr_api.g_VARCHAR2) then
317: p_rec.units_of_measure := per_pce_shd.g_old_rec.units_of_measure;
318: END If;
319: --
320: IF (p_rec.message_level = hr_api.g_VARCHAR2) then
321: p_rec.message_level := per_pce_shd.g_old_rec.message_level;
322: END IF;
323: --
324: END convert_defs;

Line 382: ,p_cagr_entitlement_item_id IN NUMBER DEFAULT hr_api.g_number

378: PROCEDURE upd
379: (p_effective_date IN DATE
380: ,p_cagr_entitlement_id IN NUMBER
381: ,p_object_version_number IN OUT NOCOPY NUMBER
382: ,p_cagr_entitlement_item_id IN NUMBER DEFAULT hr_api.g_number
383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number

379: (p_effective_date IN DATE
380: ,p_cagr_entitlement_id IN NUMBER
381: ,p_object_version_number IN OUT NOCOPY NUMBER
382: ,p_cagr_entitlement_item_id IN NUMBER DEFAULT hr_api.g_number
383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number

Line 384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

380: ,p_cagr_entitlement_id IN NUMBER
381: ,p_object_version_number IN OUT NOCOPY NUMBER
382: ,p_cagr_entitlement_item_id IN NUMBER DEFAULT hr_api.g_number
383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number
388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 385: ,p_end_date IN DATE DEFAULT hr_api.g_date

381: ,p_object_version_number IN OUT NOCOPY NUMBER
382: ,p_cagr_entitlement_item_id IN NUMBER DEFAULT hr_api.g_number
383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number
388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
389: ,p_message_level IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

Line 386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

382: ,p_cagr_entitlement_item_id IN NUMBER DEFAULT hr_api.g_number
383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number
388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
389: ,p_message_level IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
390: ) IS

Line 387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number

383: ,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number
388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
389: ,p_message_level IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
390: ) IS
391: --

Line 388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

384: ,p_status IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number
388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
389: ,p_message_level IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
390: ) IS
391: --
392: l_rec per_pce_shd.g_rec_type;

Line 389: ,p_message_level IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2

385: ,p_end_date IN DATE DEFAULT hr_api.g_date
386: ,p_formula_criteria IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
387: ,p_formula_id IN NUMBER DEFAULT hr_api.g_number
388: ,p_units_of_measure IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
389: ,p_message_level IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
390: ) IS
391: --
392: l_rec per_pce_shd.g_rec_type;
393: l_proc VARCHAR2(72) := g_package||'upd';