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_CPN_BUS dependencies on STANDARD

Line 49: if per_cpn_shd.g_old_rec.competence_cluster = 'UNIT_STANDARD'

45: raise l_error;
46: end if;
47: hr_utility.set_location(l_proc, 7);
48:
49: if per_cpn_shd.g_old_rec.competence_cluster = 'UNIT_STANDARD'
50: and (p_rec.competence_cluster is NULL
51: or p_rec.competence_cluster <> 'UNIT_STANDARD') then
52: --
53: fnd_message.set_name('PER','HR_449146_QUA_FWK_CHG_CLUSTER');

Line 51: or p_rec.competence_cluster <> 'UNIT_STANDARD') then

47: hr_utility.set_location(l_proc, 7);
48:
49: if per_cpn_shd.g_old_rec.competence_cluster = 'UNIT_STANDARD'
50: and (p_rec.competence_cluster is NULL
51: or p_rec.competence_cluster <> 'UNIT_STANDARD') then
52: --
53: fnd_message.set_name('PER','HR_449146_QUA_FWK_CHG_CLUSTER');
54: fnd_message.raise_error;
55: end if;

Line 279: -- Apart from having the standard date validation check ie.date from <= date_to

275: end if;
276: --
277: -- only continue if called from UPDATE check
278: --
279: -- Apart from having the standard date validation check ie.date from <= date_to
280: -- and date_to >= date_from, need to make sure that the user cannot change a date
281: -- so as to invalidate the dates on the competence element.
282: -- Check dates againts competence elements (only in Update mode)
283: --

Line 1315: --------------------------------------------------------

1311: --
1312: end chk_competence_cluster;
1313: --
1314: -------------------------------------------------------------------------------
1315: --------------------------------------------------------
1316: -------------------------------------------------------------------------------
1317: --
1318: -- Description:
1319: -- This procedure checks that a unit_standard_id is unique

Line 1319: -- This procedure checks that a unit_standard_id is unique

1315: --------------------------------------------------------
1316: -------------------------------------------------------------------------------
1317: --
1318: -- Description:
1319: -- This procedure checks that a unit_standard_id is unique
1320: --
1321: -- Pre_conditions:
1322: -- None.
1323: --

Line 1326: -- p_unit_standard_id

1322: -- None.
1323: --
1324: -- In Arguments:
1325: -- p_competence_id
1326: -- p_unit_standard_id
1327: -- p_business_group_id
1328: -- p_object_version_number
1329: -- p_effective_date
1330: --

Line 1342: procedure chk_unit_standard_id

1338: -- Access Status
1339: -- Internal Table Handler Use Only.
1340: --
1341: --
1342: procedure chk_unit_standard_id
1343: (p_competence_id in per_competences.competence_id%TYPE
1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1345: ,p_business_group_id in per_competences.business_group_id%TYPE
1346: ,p_object_version_number in per_competences.object_version_number%TYPE

Line 1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE

1340: --
1341: --
1342: procedure chk_unit_standard_id
1343: (p_competence_id in per_competences.competence_id%TYPE
1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1345: ,p_business_group_id in per_competences.business_group_id%TYPE
1346: ,p_object_version_number in per_competences.object_version_number%TYPE
1347: ,p_effective_date in date
1348: )

Line 1354: cursor csr_local_unit_standard_id is

1350: --
1351: --
1352: -- declare cursor
1353: --
1354: cursor csr_local_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id
1357: and business_group_id = p_business_group_id
1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);

Line 1356: where unit_standard_id = p_unit_standard_id

1352: -- declare cursor
1353: --
1354: cursor csr_local_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id
1357: and business_group_id = p_business_group_id
1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1359: --
1360: cursor csr_global_unit_standard_id is

Line 1360: cursor csr_global_unit_standard_id is

1356: where unit_standard_id = p_unit_standard_id
1357: and business_group_id = p_business_group_id
1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1359: --
1360: cursor csr_global_unit_standard_id is
1361: select 1 from per_competences
1362: where unit_standard_id = p_unit_standard_id
1363: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1364:

Line 1362: where unit_standard_id = p_unit_standard_id

1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1359: --
1360: cursor csr_global_unit_standard_id is
1361: select 1 from per_competences
1362: where unit_standard_id = p_unit_standard_id
1363: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1364:
1365: l_proc varchar2(72) := g_package||'chk_unit_standard_id';
1366: l_api_updating boolean;

Line 1365: l_proc varchar2(72) := g_package||'chk_unit_standard_id';

1361: select 1 from per_competences
1362: where unit_standard_id = p_unit_standard_id
1363: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1364:
1365: l_proc varchar2(72) := g_package||'chk_unit_standard_id';
1366: l_api_updating boolean;
1367: l_exists varchar2(1);
1368: --
1369: begin

Line 1374: -- b) The value for unit_standard_id has changed

1370: hr_utility.set_location('Entering:'|| l_proc, 10);
1371: --
1372: -- Only proceed with validation if :
1373: -- a) The current g_old_rec is current and
1374: -- b) The value for unit_standard_id has changed
1375: --
1376: l_api_updating := per_cpn_shd.api_updating
1377: (p_competence_id => p_competence_id
1378: ,p_object_version_number => p_object_version_number);

Line 1380: if (p_unit_standard_id is not NULL) then

1376: l_api_updating := per_cpn_shd.api_updating
1377: (p_competence_id => p_competence_id
1378: ,p_object_version_number => p_object_version_number);
1379: --
1380: if (p_unit_standard_id is not NULL) then
1381: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,
1382: hr_api.g_varchar2)
1383: <> nvl(p_unit_standard_id,hr_api.g_varchar2)
1384: ) or

Line 1381: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,

1377: (p_competence_id => p_competence_id
1378: ,p_object_version_number => p_object_version_number);
1379: --
1380: if (p_unit_standard_id is not NULL) then
1381: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,
1382: hr_api.g_varchar2)
1383: <> nvl(p_unit_standard_id,hr_api.g_varchar2)
1384: ) or
1385: (NOT l_api_updating)

Line 1383: <> nvl(p_unit_standard_id,hr_api.g_varchar2)

1379: --
1380: if (p_unit_standard_id is not NULL) then
1381: if ( (l_api_updating and nvl(per_cpn_shd.g_old_rec.unit_standard_id,
1382: hr_api.g_varchar2)
1383: <> nvl(p_unit_standard_id,hr_api.g_varchar2)
1384: ) or
1385: (NOT l_api_updating)
1386: ) then
1387: --

Line 1393: open csr_local_unit_standard_id;

1389: hr_utility.set_location(l_proc, 20);
1390: --
1391: -- Local competence
1392: --
1393: open csr_local_unit_standard_id;
1394: fetch csr_local_unit_standard_id into l_exists;
1395: if csr_local_unit_standard_id%FOUND then
1396: close csr_local_unit_standard_id;
1397: --

Line 1394: fetch csr_local_unit_standard_id into l_exists;

1390: --
1391: -- Local competence
1392: --
1393: open csr_local_unit_standard_id;
1394: fetch csr_local_unit_standard_id into l_exists;
1395: if csr_local_unit_standard_id%FOUND then
1396: close csr_local_unit_standard_id;
1397: --
1398: hr_utility.set_location(l_proc, 30);

Line 1395: if csr_local_unit_standard_id%FOUND then

1391: -- Local competence
1392: --
1393: open csr_local_unit_standard_id;
1394: fetch csr_local_unit_standard_id into l_exists;
1395: if csr_local_unit_standard_id%FOUND then
1396: close csr_local_unit_standard_id;
1397: --
1398: hr_utility.set_location(l_proc, 30);
1399: --

Line 1396: close csr_local_unit_standard_id;

1392: --
1393: open csr_local_unit_standard_id;
1394: fetch csr_local_unit_standard_id into l_exists;
1395: if csr_local_unit_standard_id%FOUND then
1396: close csr_local_unit_standard_id;
1397: --
1398: hr_utility.set_location(l_proc, 30);
1399: --
1400: hr_utility.set_message(800, 'HR_449089_UNIT_STD_ID_EXISTS');

Line 1404: close csr_local_unit_standard_id;

1400: hr_utility.set_message(800, 'HR_449089_UNIT_STD_ID_EXISTS');
1401: hr_utility.raise_error;
1402: --
1403: END IF;
1404: close csr_local_unit_standard_id;
1405: else
1406: hr_utility.set_location(l_proc, 40);
1407: --
1408: -- Global competence

Line 1410: open csr_global_unit_standard_id;

1406: hr_utility.set_location(l_proc, 40);
1407: --
1408: -- Global competence
1409: --
1410: open csr_global_unit_standard_id;
1411: fetch csr_global_unit_standard_id into l_exists;
1412: if csr_global_unit_standard_id%FOUND then
1413: close csr_global_unit_standard_id;
1414: --

Line 1411: fetch csr_global_unit_standard_id into l_exists;

1407: --
1408: -- Global competence
1409: --
1410: open csr_global_unit_standard_id;
1411: fetch csr_global_unit_standard_id into l_exists;
1412: if csr_global_unit_standard_id%FOUND then
1413: close csr_global_unit_standard_id;
1414: --
1415: hr_utility.set_location(l_proc, 50);

Line 1412: if csr_global_unit_standard_id%FOUND then

1408: -- Global competence
1409: --
1410: open csr_global_unit_standard_id;
1411: fetch csr_global_unit_standard_id into l_exists;
1412: if csr_global_unit_standard_id%FOUND then
1413: close csr_global_unit_standard_id;
1414: --
1415: hr_utility.set_location(l_proc, 50);
1416: --

Line 1413: close csr_global_unit_standard_id;

1409: --
1410: open csr_global_unit_standard_id;
1411: fetch csr_global_unit_standard_id into l_exists;
1412: if csr_global_unit_standard_id%FOUND then
1413: close csr_global_unit_standard_id;
1414: --
1415: hr_utility.set_location(l_proc, 50);
1416: --
1417: hr_utility.set_message(800, 'HR_449089_UNIT_STD_ID_EXISTS');

Line 1421: close csr_global_unit_standard_id;

1417: hr_utility.set_message(800, 'HR_449089_UNIT_STD_ID_EXISTS');
1418: hr_utility.raise_error;
1419: --
1420: END IF;
1421: close csr_global_unit_standard_id;
1422: end if;
1423: end if;
1424: end if;
1425: --

Line 1428: end chk_unit_standard_id;

1424: end if;
1425: --
1426: hr_utility.set_location('Leaving: '|| l_proc, 60);
1427: --
1428: end chk_unit_standard_id;
1429: --
1430: -------------------------------------------------------------------------------
1431: ----------------------------< chk_credit_type >--------------------------------
1432: -------------------------------------------------------------------------------

Line 2381: -- Rule check unit_standard_id

2377: );
2378: hr_utility.set_location(l_proc, 50);
2379:
2380: --
2381: -- Rule check unit_standard_id
2382: --
2383: per_cpn_bus.chk_unit_standard_id
2384: (p_competence_id => p_rec.competence_id
2385: ,p_unit_standard_id => p_rec.unit_standard_id

Line 2383: per_cpn_bus.chk_unit_standard_id

2379:
2380: --
2381: -- Rule check unit_standard_id
2382: --
2383: per_cpn_bus.chk_unit_standard_id
2384: (p_competence_id => p_rec.competence_id
2385: ,p_unit_standard_id => p_rec.unit_standard_id
2386: ,p_business_group_id => p_rec.business_group_id
2387: ,p_object_version_number => p_rec.object_version_number

Line 2385: ,p_unit_standard_id => p_rec.unit_standard_id

2381: -- Rule check unit_standard_id
2382: --
2383: per_cpn_bus.chk_unit_standard_id
2384: (p_competence_id => p_rec.competence_id
2385: ,p_unit_standard_id => p_rec.unit_standard_id
2386: ,p_business_group_id => p_rec.business_group_id
2387: ,p_object_version_number => p_rec.object_version_number
2388: ,p_effective_date => p_effective_date
2389: );

Line 2615: -- Rule check unit_standard_id

2611: );
2612: hr_utility.set_location(l_proc, 70);
2613:
2614: --
2615: -- Rule check unit_standard_id
2616: --
2617: per_cpn_bus.chk_unit_standard_id
2618: (p_competence_id => p_rec.competence_id
2619: ,p_unit_standard_id => p_rec.unit_standard_id

Line 2617: per_cpn_bus.chk_unit_standard_id

2613:
2614: --
2615: -- Rule check unit_standard_id
2616: --
2617: per_cpn_bus.chk_unit_standard_id
2618: (p_competence_id => p_rec.competence_id
2619: ,p_unit_standard_id => p_rec.unit_standard_id
2620: ,p_business_group_id => p_rec.business_group_id
2621: ,p_object_version_number => p_rec.object_version_number

Line 2619: ,p_unit_standard_id => p_rec.unit_standard_id

2615: -- Rule check unit_standard_id
2616: --
2617: per_cpn_bus.chk_unit_standard_id
2618: (p_competence_id => p_rec.competence_id
2619: ,p_unit_standard_id => p_rec.unit_standard_id
2620: ,p_business_group_id => p_rec.business_group_id
2621: ,p_object_version_number => p_rec.object_version_number
2622: ,p_effective_date => p_effective_date
2623: );