DBA Data[Home] [Help]

APPS.PSP_PEE_BUS dependencies on PSP_PEE_SHD

Line 189: (p_rec in psp_pee_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in psp_pee_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(psp_pee_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.external_effort_line_id is not null) and (
198: nvl(psp_pee_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(psp_pee_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(psp_pee_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(psp_pee_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.external_effort_line_id is not null) and (
198: nvl(psp_pee_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(psp_pee_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(psp_pee_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(psp_pee_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(psp_pee_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

198: nvl(psp_pee_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(psp_pee_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(psp_pee_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(psp_pee_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(psp_pee_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(psp_pee_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

200: nvl(psp_pee_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(psp_pee_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(psp_pee_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(psp_pee_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(psp_pee_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(psp_pee_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

202: nvl(psp_pee_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(psp_pee_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(psp_pee_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(psp_pee_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(psp_pee_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(psp_pee_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

204: nvl(psp_pee_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(psp_pee_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(psp_pee_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(psp_pee_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(psp_pee_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(psp_pee_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

206: nvl(psp_pee_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(psp_pee_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(psp_pee_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(psp_pee_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(psp_pee_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(psp_pee_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

208: nvl(psp_pee_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(psp_pee_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(psp_pee_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(psp_pee_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(psp_pee_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(psp_pee_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

210: nvl(psp_pee_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(psp_pee_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(psp_pee_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(psp_pee_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(psp_pee_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(psp_pee_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

212: nvl(psp_pee_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(psp_pee_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(psp_pee_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(psp_pee_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(psp_pee_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(psp_pee_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

214: nvl(psp_pee_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(psp_pee_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(psp_pee_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(psp_pee_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(psp_pee_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(psp_pee_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

216: nvl(psp_pee_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(psp_pee_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(psp_pee_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(psp_pee_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(psp_pee_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(psp_pee_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

218: nvl(psp_pee_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(psp_pee_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(psp_pee_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(psp_pee_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(psp_pee_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(psp_pee_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

220: nvl(psp_pee_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(psp_pee_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(psp_pee_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(psp_pee_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(psp_pee_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(psp_pee_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

222: nvl(psp_pee_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(psp_pee_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(psp_pee_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(psp_pee_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) ))
230: or (p_rec.external_effort_line_id is null) then

Line 228: nvl(psp_pee_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

224: nvl(psp_pee_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(psp_pee_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(psp_pee_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) ))
230: or (p_rec.external_effort_line_id is null) then
231: --
232: -- Only execute the validation if absolutely necessary:

Line 305: (p_rec in psp_pee_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure chk_non_updateable_args
305: (p_rec in psp_pee_shd.g_rec_type
306: ) IS
307: --
308: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
309: --

Line 315: IF NOT psp_pee_shd.api_updating

311: --
312: -- Only proceed with the validation if a row exists for the current
313: -- record in the HR Schema.
314: --
315: IF NOT psp_pee_shd.api_updating
316: (p_external_effort_line_id => p_rec.external_effort_line_id
317: ,p_object_version_number => p_rec.object_version_number
318: ) THEN
319: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 616: (p_rec IN psp_pee_shd.g_rec_type

612: -- ----------------------------------------------------------------------------
613: -- |---------------------------< chk_ptaoe_gl_combination >----------------------------|
614: -- ----------------------------------------------------------------------------
615: PROCEDURE chk_ptaoe_gl_combination
616: (p_rec IN psp_pee_shd.g_rec_type
617: ) IS
618: BEGIN
619: IF p_rec.project_id IS NULL AND p_rec.gl_code_combination_id IS NULL THEN
620: hr_utility.set_message(8403, 'PSP_POETA_GL');

Line 964: (p_rec IN psp_pee_shd.g_rec_type

960: -- ----------------------------------------------------------------------------
961: -- |---------------------------< chk_record_validity >----------------------------|
962: -- ----------------------------------------------------------------------------
963: PROCEDURE chk_record_validity
964: (p_rec IN psp_pee_shd.g_rec_type
965: ) IS
966: --
967: /*
968: CURSOR person_effort_report_csr(p_person_id IN NUMBER, p_distribution_date IN DATE) IS

Line 1282: (p_rec in psp_pee_shd.g_rec_type

1278: -- ----------------------------------------------------------------------------
1279: -- |---------------------------< insert_validate >----------------------------|
1280: -- ----------------------------------------------------------------------------
1281: Procedure insert_validate
1282: (p_rec in psp_pee_shd.g_rec_type
1283: ) is
1284: --
1285: l_proc varchar2(72) := g_package||'insert_validate';
1286: --

Line 1296: ,p_associated_column1 => psp_pee_shd.g_tab_nam

1292:
1293:
1294: hr_api.validate_bus_grp_id
1295: (p_business_group_id => p_rec.business_group_id
1296: ,p_associated_column1 => psp_pee_shd.g_tab_nam
1297: || '.BUSINESS_GROUP_ID');
1298: --
1299: -- After validating the set of important attributes,
1300: -- if Multiple Message detection is enabled and at least

Line 1373: (p_rec in psp_pee_shd.g_rec_type

1369: -- ----------------------------------------------------------------------------
1370: -- |---------------------------< update_validate >----------------------------|
1371: -- ----------------------------------------------------------------------------
1372: Procedure update_validate
1373: (p_rec in psp_pee_shd.g_rec_type
1374: ) is
1375: --
1376: l_proc varchar2(72) := g_package||'update_validate';
1377: --

Line 1385: ,p_associated_column1 => psp_pee_shd.g_tab_nam

1381: -- Call all supporting business operations
1382: --
1383: hr_api.validate_bus_grp_id
1384: (p_business_group_id => p_rec.business_group_id
1385: ,p_associated_column1 => psp_pee_shd.g_tab_nam
1386: || '.BUSINESS_GROUP_ID');
1387:
1388: --
1389: -- After validating the set of important attributes,

Line 1468: (p_rec in psp_pee_shd.g_rec_type

1464: -- ----------------------------------------------------------------------------
1465: -- |---------------------------< delete_validate >----------------------------|
1466: -- ----------------------------------------------------------------------------
1467: Procedure delete_validate
1468: (p_rec in psp_pee_shd.g_rec_type
1469: ) is
1470: --
1471: l_proc varchar2(72) := g_package||'delete_validate';
1472: --