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_PML_BUS dependencies on PER_OBJECTIVES

Line 120: ,p_descflex_name => 'PER_OBJECTIVES_LIBRARY'

116: -- b) During insert.
117: --
118: hr_dflex_utility.ins_or_upd_descflex_attribs
119: (p_appl_short_name => 'PER'
120: ,p_descflex_name => 'PER_OBJECTIVES_LIBRARY'
121: ,p_attribute_category => p_rec.attribute_category
122: ,p_attribute1_name => 'ATTRIBUTE1'
123: ,p_attribute1_value => p_rec.attribute1
124: ,p_attribute2_name => 'ATTRIBUTE2'

Line 278: from per_objectives_library pml

274: -- Declare the cursor
275:
276: cursor chk_objective_name(c_p_valid_from date, c_p_valid_to date) is
277: select 'Y', nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY')),nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
278: from per_objectives_library pml
279: where pml.objective_id <> nvl(p_objective_id, hr_api.g_number)
280: and upper(trim(pml.objective_name)) = upper(trim(p_objective_name))
281: and
282: (

Line 445: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.VALID_FROM'

441:
442: exception
443: when app_exception.application_exception then
444: if hr_multi_message.exception_add
445: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.VALID_FROM'
446: ,p_associated_column2 => 'PER_OBJECTIVES_LIBRARY.VALID_TO'
447: ) then
448: hr_utility.set_location(' Leaving:'||l_proc, 980);
449: raise;

Line 446: ,p_associated_column2 => 'PER_OBJECTIVES_LIBRARY.VALID_TO'

442: exception
443: when app_exception.application_exception then
444: if hr_multi_message.exception_add
445: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.VALID_FROM'
446: ,p_associated_column2 => 'PER_OBJECTIVES_LIBRARY.VALID_TO'
447: ) then
448: hr_utility.set_location(' Leaving:'||l_proc, 980);
449: raise;
450: end if;

Line 534: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.GROUP_CODE'

530:
531: exception
532: when app_exception.application_exception then
533: if hr_multi_message.exception_add
534: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.GROUP_CODE'
535: ) then
536: hr_utility.set_location(' Leaving:'||l_proc, 980);
537: raise;
538: end if;

Line 622: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.PRIORITY_CODE'

618:
619: exception
620: when app_exception.application_exception then
621: if hr_multi_message.exception_add
622: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.PRIORITY_CODE'
623: ) then
624: hr_utility.set_location(' Leaving:'||l_proc, 980);
625: raise;
626: end if;

Line 715: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'

711:
712: exception
713: when app_exception.application_exception then
714: if hr_multi_message.exception_add
715: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
716: ) then
717: hr_utility.set_location(' Leaving:'||l_proc, 980);
718: raise;
719: end if;

Line 797: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'

793: --
794: -- Warn if the objective is not marked for appraisal.
795: --
796: if hr_multi_message.no_exclusive_error
797: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
798: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
799: ) then
800: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
801: end if;

Line 798: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'

794: -- Warn if the objective is not marked for appraisal.
795: --
796: if hr_multi_message.no_exclusive_error
797: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
798: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
799: ) then
800: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
801: end if;
802:

Line 825: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.WEIGHTING_PERCENT'

821:
822: exception
823: when app_exception.application_exception then
824: if hr_multi_message.exception_add
825: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.WEIGHTING_PERCENT'
826: ) then
827: hr_utility.set_location(' Leaving:'||l_proc, 980);
828: raise;
829: end if;

Line 918: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

914:
915: exception
916: when app_exception.application_exception then
917: if hr_multi_message.exception_add
918: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
919: ) then
920: hr_utility.set_location(' Leaving:'||l_proc, 980);
921: raise;
922: end if;

Line 991: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

987:
988: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
989:
990: if hr_multi_message.no_exclusive_error
991: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
992: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
993: ) then
994:
995: if p_measurement_style_code <> 'N_M'

Line 992: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

988: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
989:
990: if hr_multi_message.no_exclusive_error
991: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
992: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
993: ) then
994:
995: if p_measurement_style_code <> 'N_M'
996: then

Line 1013: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_NAME'

1009:
1010: exception
1011: when app_exception.application_exception then
1012: if hr_multi_message.exception_add
1013: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_NAME'
1014: ) then
1015: hr_utility.set_location(' Leaving:'||l_proc, 980);
1016: raise;
1017: end if;

Line 1086: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

1082:
1083: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1084:
1085: if hr_multi_message.no_exclusive_error
1086: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1087: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1088: ) then
1089:
1090: if p_measurement_style_code = 'QUANT_M'

Line 1087: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

1083: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1084:
1085: if hr_multi_message.no_exclusive_error
1086: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1087: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1088: ) then
1089:
1090: if p_measurement_style_code = 'QUANT_M'
1091: then

Line 1108: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.TARGET_VALUE'

1104:
1105: exception
1106: when app_exception.application_exception then
1107: if hr_multi_message.exception_add
1108: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.TARGET_VALUE'
1109: ) then
1110: hr_utility.set_location(' Leaving:'||l_proc, 980);
1111: raise;
1112: end if;

Line 1180: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

1176:
1177: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1178:
1179: if hr_multi_message.no_exclusive_error
1180: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1181: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1182: ) then
1183:
1184: if p_measurement_style_code = 'QUANT_M'

Line 1181: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

1177: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1178:
1179: if hr_multi_message.no_exclusive_error
1180: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1181: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1182: ) then
1183:
1184: if p_measurement_style_code = 'QUANT_M'
1185: then

Line 1219: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.UOM_CODE'

1215:
1216: exception
1217: when app_exception.application_exception then
1218: if hr_multi_message.exception_add
1219: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.UOM_CODE'
1220: ) then
1221: hr_utility.set_location(' Leaving:'||l_proc, 980);
1222: raise;
1223: end if;

Line 1291: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

1287:
1288: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1289:
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1292: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1293: ) then
1294:
1295: if p_measurement_style_code = 'QUANT_M'

Line 1292: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'

1288: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1289:
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1292: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1293: ) then
1294:
1295: if p_measurement_style_code = 'QUANT_M'
1296: then

Line 1330: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_TYPE_CODE'

1326:
1327: exception
1328: when app_exception.application_exception then
1329: if hr_multi_message.exception_add
1330: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_TYPE_CODE'
1331: ) then
1332: hr_utility.set_location(' Leaving:'||l_proc, 980);
1333: raise;
1334: end if;

Line 1423: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.ELIGIBILITY_TYPE_CODE'

1419:
1420: exception
1421: when app_exception.application_exception then
1422: if hr_multi_message.exception_add
1423: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.ELIGIBILITY_TYPE_CODE'
1424: ) then
1425: hr_utility.set_location(' Leaving:'||l_proc, 980);
1426: raise;
1427: end if;

Line 1461: (p_objective_id in per_objectives_library.objective_id%TYPE

1457: -- Internal Development use only.
1458: --
1459: -- ---------------------------------------------------------------------
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is

Line 1462: ,p_valid_from in per_objectives_library.valid_from%TYPE

1458: --
1459: -- ---------------------------------------------------------------------
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1466: --

Line 1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE

1459: -- ---------------------------------------------------------------------
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1466: --
1467: l_proc varchar2(72) := g_package||'chk_next_review_date';

Line 1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE

1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1466: --
1467: l_proc varchar2(72) := g_package||'chk_next_review_date';
1468: --

Line 1483: (p_associated_column1 => 'PER_OBJECTIVES.NEXT_REVIEW_DATE'

1479: --
1480: exception
1481: when app_exception.application_exception then
1482: if hr_multi_message.exception_add
1483: (p_associated_column1 => 'PER_OBJECTIVES.NEXT_REVIEW_DATE'
1484: ) then
1485: raise;
1486: end if;
1487: end chk_next_review_date;

Line 1518: (p_objective_id in per_objectives_library.objective_id%TYPE

1514: -- Internal Development use only.
1515: --
1516: -- ---------------------------------------------------------------------
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is

Line 1519: ,p_valid_from in per_objectives_library.valid_from%TYPE

1515: --
1516: -- ---------------------------------------------------------------------
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1523: --

Line 1520: ,p_target_date in per_objectives_library.target_date%TYPE

1516: -- ---------------------------------------------------------------------
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1523: --
1524: l_proc varchar2(72) := g_package||'chk_target_date';

Line 1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE

1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1523: --
1524: l_proc varchar2(72) := g_package||'chk_target_date';
1525: --

Line 1540: (p_associated_column1 => 'PER_OBJECTIVES.target_date'

1536: --
1537: exception
1538: when app_exception.application_exception then
1539: if hr_multi_message.exception_add
1540: (p_associated_column1 => 'PER_OBJECTIVES.target_date'
1541: ) then
1542: raise;
1543: end if;
1544: end chk_target_date;

Line 1593: from per_objectives

1589: --
1590: Cursor csr_child_for_objlib_exists
1591: is
1592: select 'Y'
1593: from per_objectives
1594: where copied_from_library_id = p_objective_id;
1595: --
1596: begin
1597: --

Line 1620: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.OBJECTIVE_ID'

1616:
1617: exception
1618: when app_exception.application_exception then
1619: if hr_multi_message.exception_add
1620: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.OBJECTIVE_ID'
1621: ) then
1622: hr_utility.set_location(' Leaving:'||l_proc, 980);
1623: raise;
1624: end if;