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 PER_PCE_SHD

Line 55: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type

51: --
52: -- {END Of Comments}
53: -- ----------------------------------------------------------------------------
54: PROCEDURE update_dml
55: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
56: ) IS
57: --
58: l_proc VARCHAR2(72) := g_package||'update_dml';
59: --

Line 92: per_pce_shd.constraint_error

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));
94: WHEN hr_api.parent_integrity_violated THEN
95: -- Parent integrity has been violated
96: --

Line 97: 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));
99: WHEN hr_api.unique_integrity_violated THEN
100: -- Unique integrity has been violated
101: --

Line 102: 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));
104: WHEN Others THEN
105: --
106: RAISE;

Line 142: (p_rec IN per_pce_shd.g_rec_type

138: --
139: -- {END Of Comments}
140: -- ----------------------------------------------------------------------------
141: PROCEDURE pre_update
142: (p_rec IN per_pce_shd.g_rec_type
143: ) IS
144: --
145: l_proc VARCHAR2(72) := g_package||'pre_update';
146: --

Line 187: ,p_rec IN per_pce_shd.g_rec_type

183: -- {END Of Comments}
184: -- ----------------------------------------------------------------------------
185: PROCEDURE post_update
186: (p_effective_date IN DATE
187: ,p_rec IN per_pce_shd.g_rec_type
188: ) IS
189: --
190: l_proc VARCHAR2(72) := g_package||'post_update';
191: --

Line 209: ,p_cagr_entitlement_item_id_o => per_pce_shd.g_old_rec.cagr_entitlement_item_id

205: ,p_formula_id => p_rec.formula_id
206: ,p_units_of_measure => p_rec.units_of_measure
207: ,p_message_level => p_rec.message_level
208: ,p_object_version_number => p_rec.object_version_number
209: ,p_cagr_entitlement_item_id_o => per_pce_shd.g_old_rec.cagr_entitlement_item_id
210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id
211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status

Line 210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id

206: ,p_units_of_measure => p_rec.units_of_measure
207: ,p_message_level => p_rec.message_level
208: ,p_object_version_number => p_rec.object_version_number
209: ,p_cagr_entitlement_item_id_o => per_pce_shd.g_old_rec.cagr_entitlement_item_id
210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id
211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria

Line 211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date

207: ,p_message_level => p_rec.message_level
208: ,p_object_version_number => p_rec.object_version_number
209: ,p_cagr_entitlement_item_id_o => per_pce_shd.g_old_rec.cagr_entitlement_item_id
210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id
211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id

Line 212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date

208: ,p_object_version_number => p_rec.object_version_number
209: ,p_cagr_entitlement_item_id_o => per_pce_shd.g_old_rec.cagr_entitlement_item_id
210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id
211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure

Line 213: ,p_status_o => per_pce_shd.g_old_rec.status

209: ,p_cagr_entitlement_item_id_o => per_pce_shd.g_old_rec.cagr_entitlement_item_id
210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id
211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure
217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level

Line 214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria

210: ,p_collective_agreement_id_o => per_pce_shd.g_old_rec.collective_agreement_id
211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure
217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level
218: ,p_object_version_number_o => per_pce_shd.g_old_rec.object_version_number

Line 215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id

211: ,p_start_date_o => per_pce_shd.g_old_rec.start_date
212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure
217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level
218: ,p_object_version_number_o => per_pce_shd.g_old_rec.object_version_number
219: );

Line 216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure

212: ,p_end_date_o => per_pce_shd.g_old_rec.end_date
213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure
217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level
218: ,p_object_version_number_o => per_pce_shd.g_old_rec.object_version_number
219: );
220: --

Line 217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level

213: ,p_status_o => per_pce_shd.g_old_rec.status
214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure
217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level
218: ,p_object_version_number_o => per_pce_shd.g_old_rec.object_version_number
219: );
220: --
221: exception

Line 218: ,p_object_version_number_o => per_pce_shd.g_old_rec.object_version_number

214: ,p_formula_criteria_o => per_pce_shd.g_old_rec.formula_criteria
215: ,p_formula_id_o => per_pce_shd.g_old_rec.formula_id
216: ,p_units_of_measure_o => per_pce_shd.g_old_rec.units_of_measure
217: ,p_message_level_o => per_pce_shd.g_old_rec.message_level
218: ,p_object_version_number_o => per_pce_shd.g_old_rec.object_version_number
219: );
220: --
221: exception
222: --

Line 278: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type

274: --
275: -- {END Of Comments}
276: -- ----------------------------------------------------------------------------
277: PROCEDURE convert_defs
278: (p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
279: ) IS
280: --
281: BEGIN
282: --

Line 290: per_pce_shd.g_old_rec.cagr_entitlement_item_id;

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
293: p_rec.collective_agreement_id :=
294: per_pce_shd.g_old_rec.collective_agreement_id;

Line 294: per_pce_shd.g_old_rec.collective_agreement_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
297: p_rec.start_date :=
298: per_pce_shd.g_old_rec.start_date;

Line 298: per_pce_shd.g_old_rec.start_date;

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
301: p_rec.end_date :=
302: per_pce_shd.g_old_rec.end_date;

Line 302: per_pce_shd.g_old_rec.end_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
305: p_rec.status :=
306: per_pce_shd.g_old_rec.status;

Line 306: per_pce_shd.g_old_rec.status;

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
309: p_rec.formula_criteria :=
310: per_pce_shd.g_old_rec.formula_criteria;

Line 310: per_pce_shd.g_old_rec.formula_criteria;

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
313: p_rec.formula_id :=
314: per_pce_shd.g_old_rec.formula_id;

Line 314: per_pce_shd.g_old_rec.formula_id;

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
317: p_rec.units_of_measure := per_pce_shd.g_old_rec.units_of_measure;
318: END If;

Line 317: p_rec.units_of_measure := per_pce_shd.g_old_rec.units_of_measure;

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
321: p_rec.message_level := per_pce_shd.g_old_rec.message_level;

Line 321: p_rec.message_level := per_pce_shd.g_old_rec.message_level;

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;
325: --

Line 331: ,p_rec IN OUT NOCOPY per_pce_shd.g_rec_type

327: -- |---------------------------------< upd >----------------------------------|
328: -- ----------------------------------------------------------------------------
329: PROCEDURE upd
330: (p_effective_date IN DATE
331: ,p_rec IN OUT NOCOPY per_pce_shd.g_rec_type
332: ) IS
333: --
334: l_proc VARCHAR2(72) := g_package||'upd';
335: --

Line 341: per_pce_shd.lck

337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- We must lock the row which we need to update.
340: --
341: per_pce_shd.lck
342: (p_rec.cagr_entitlement_id
343: ,p_rec.object_version_number
344: );
345: --

Line 392: l_rec per_pce_shd.g_rec_type;

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';
394: --
395: BEGIN
396: --

Line 403: per_pce_shd.convert_args

399: -- Call conversion function to turn arguments into the
400: -- l_rec structure.
401: --
402: l_rec :=
403: per_pce_shd.convert_args
404: (p_cagr_entitlement_id
405: ,p_cagr_entitlement_item_id
406: ,p_collective_agreement_id
407: ,NULL -- p_start_date