APPS.PER_PCE_BUS dependencies on PER_PCE_SHD

Line 185: ,p_rec IN per_pce_shd.g_rec_type

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

Line 197: IF NOT per_pce_shd.api_updating

193: --
194: -- Only proceed with the validation if a row exists for the current
195: -- record IN the HR Schema.
196: --
197: IF NOT per_pce_shd.api_updating
198: (p_cagr_entitlement_id => p_rec.cagr_entitlement_id
199: ,p_object_version_number => p_rec.object_version_number
200: ) THEN
201: --

Line 210: nvl(per_pce_shd.g_old_rec.collective_agreement_id,hr_api.g_number) THEN

206: --
207: END IF;
208: --
209: IF nvl(p_rec.collective_agreement_id, hr_api.g_number) <>
210: nvl(per_pce_shd.g_old_rec.collective_agreement_id,hr_api.g_number) THEN
211: --
212: l_argument := 'collective_agreement_id';
213: RAISE l_error;
214: --

Line 218: nvl(per_pce_shd.g_old_rec.cagr_entitlement_item_id,hr_api.g_number) THEN

214: --
215: END IF;
216: --
217: IF nvl(p_rec.cagr_entitlement_item_id, hr_api.g_number) <>
218: nvl(per_pce_shd.g_old_rec.cagr_entitlement_item_id,hr_api.g_number) THEN
219: --
220: l_argument := 'cagr_entitlement_item_id';
221: RAISE l_error;
222: --

Line 226: nvl(per_pce_shd.g_old_rec.formula_criteria,hr_api.g_varchar2) THEN

222: --
223: END IF;
224: --
225: IF nvl(p_rec.formula_criteria, hr_api.g_varchar2) <>
226: nvl(per_pce_shd.g_old_rec.formula_criteria,hr_api.g_varchar2) THEN
227: --
228: l_argument := 'formula_criteria';
229: RAISE l_error;
230: --

Line 234: nvl(per_pce_shd.g_old_rec.cagr_entitlement_item_id,hr_api.g_number) THEN

230: --
231: END IF;
232: --
233: IF nvl(p_rec.cagr_entitlement_item_id, hr_api.g_number) <>
234: nvl(per_pce_shd.g_old_rec.cagr_entitlement_item_id,hr_api.g_number) THEN
235: --
236: l_argument := 'cagr_entitlement_item_id';
237: RAISE l_error;
238: --

Line 318: (per_pce_shd.g_old_rec.status <> p_status))) THEN

314: -- b) The value for status has changed
315: --
316: IF ( (p_cagr_entitlement_id IS NULL) OR
317: ((p_cagr_entitlement_id IS NOT NULL) AND
318: (per_pce_shd.g_old_rec.status <> p_status))) THEN
319: --
320: hr_utility.set_location(l_proc,30);
321: --
322: -- Check that the status exists IN HR_LOOKUPS

Line 406: (per_pce_shd.g_old_rec.message_level <> p_message_level))) THEN

402: -- b) The value for message level has changed
403: --
404: IF ( (p_cagr_entitlement_id IS NULL) OR
405: ((p_cagr_entitlement_id IS NOT NULL) AND
406: (per_pce_shd.g_old_rec.message_level <> p_message_level))) THEN
407: --
408: hr_utility.set_location(l_proc,30);
409: --
410: -- Check that the unit_of_measure exists IN HR_LOOKUPS

Line 568: (per_pce_shd.g_old_rec.formula_id <> p_formula_id))) THEN

564: -- Only validate if we are inserting
565: --
566: IF ( (p_cagr_entitlement_id IS NULL) OR
567: ((p_cagr_entitlement_id IS NOT NULL) AND
568: (per_pce_shd.g_old_rec.formula_id <> p_formula_id))) THEN
569: --
570: hr_utility.set_location(l_proc,30);
571: --
572: -- Check that the formula_criteria exists IN HR_LOOKUPS

Line 848: (per_pce_shd.g_old_rec.formula_id <> p_formula_id))) THEN

844: -- b) The value for formula id has changed
845: --
846: IF ( (p_cagr_entitlement_id IS NULL) OR
847: ((p_cagr_entitlement_id IS NOT NULL) AND
848: (per_pce_shd.g_old_rec.formula_id <> p_formula_id))) THEN
849: --
850: hr_utility.set_location(l_proc,30);
851: --
852: -- Only check the ff_formula_f table if the

Line 1061: (per_pce_shd.g_old_rec.end_date <>

1057: --
1058: /*
1059: IF ( (p_cagr_entitlement_id IS NULL) OR
1060: ((p_cagr_entitlement_id IS NOT NULL) AND
1061: (per_pce_shd.g_old_rec.end_date <>
1062: NVL(p_end_date,hr_general.end_of_time)))) THEN*/
1063: --
1064: hr_utility.set_location(l_proc,20);
1065: --

Line 1210: ,p_rec IN per_pce_shd.g_rec_type

1206: -- |---------------------------< insert_validate >----------------------------|
1207: -- ----------------------------------------------------------------------------
1208: PROCEDURE insert_validate
1209: (p_effective_date IN DATE
1210: ,p_rec IN per_pce_shd.g_rec_type
1211: ) IS
1212: --
1213: l_proc VARCHAR2(72) := g_package||'insert_validate';
1214: l_business_group_id NUMBER;

Line 1223: per_pce_shd.retrieve_cagr_info

1219: --
1220: -- Call procedure that returns the business_group_id
1221: -- that will be used in the chk procedures
1222: --
1223: per_pce_shd.retrieve_cagr_info
1224: (p_collective_agreement_id => p_rec.collective_agreement_id
1225: ,p_business_group_id => l_business_group_id);
1226: --
1227: --

Line 1326: ,p_rec IN per_pce_shd.g_rec_type

1322: -- ----------------------------------------------------------------------------
1323: --
1324: PROCEDURE update_validate
1325: (p_effective_date IN DATE
1326: ,p_rec IN per_pce_shd.g_rec_type
1327: ) IS
1328: --
1329: l_proc VARCHAR2(72) := g_package||'update_validate';
1330: l_business_group_id NUMBER;

Line 1346: per_pce_shd.retrieve_cagr_info

1342: --
1343: -- Call procedure that returns the business_group_id
1344: -- that will be used in the chk procedures
1345: --
1346: per_pce_shd.retrieve_cagr_info
1347: (p_collective_agreement_id => p_rec.collective_agreement_id
1348: ,p_business_group_id => l_business_group_id);
1349: --
1350: hr_utility.set_location(l_proc,20);

Line 1407: (p_rec IN per_pce_shd.g_rec_type

1403: -- ----------------------------------------------------------------------------
1404: -- |---------------------------< delete_validate >----------------------------|
1405: -- ----------------------------------------------------------------------------
1406: PROCEDURE delete_validate
1407: (p_rec IN per_pce_shd.g_rec_type
1408: ) IS
1409: --
1410: l_proc VARCHAR2(72) := g_package||'delete_validate';
1411: --