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

Line 94: (p_appraisal_id in per_objectives.appraisal_id%TYPE

90: -- Internal Table Handler Use Only.
91: --
92: --
93: procedure chk_appraisal
94: (p_appraisal_id in per_objectives.appraisal_id%TYPE
95: ,p_business_group_id in per_objectives.business_group_id%TYPE
96: )
97: is
98: --

Line 95: ,p_business_group_id in per_objectives.business_group_id%TYPE

91: --
92: --
93: procedure chk_appraisal
94: (p_appraisal_id in per_objectives.appraisal_id%TYPE
95: ,p_business_group_id in per_objectives.business_group_id%TYPE
96: )
97: is
98: --
99: l_exists varchar2(1);

Line 101: l_business_group_id per_objectives.business_group_id%TYPE;

97: is
98: --
99: l_exists varchar2(1);
100: l_proc varchar2(72) := g_package||'chk_appraisal';
101: l_business_group_id per_objectives.business_group_id%TYPE;
102: --
103: --
104: -- Cursor to check if appraisal exists
105: --

Line 152: (p_associated_column1 => 'PER_OBJECTIVES.APPRAISAL_ID'

148: --
149: exception
150: when app_exception.application_exception then
151: if hr_multi_message.exception_add
152: (p_associated_column1 => 'PER_OBJECTIVES.APPRAISAL_ID'
153: ) then
154: raise;
155: end if;
156:

Line 220: (p_associated_column1 => 'PER_OBJECTIVES.APPRAISAL_ID'

216: --
217: exception
218: when app_exception.application_exception then
219: if hr_multi_message.exception_add
220: (p_associated_column1 => 'PER_OBJECTIVES.APPRAISAL_ID'
221: ) then
222: raise;
223: end if;
224:

Line 268: (p_owning_person_id in per_objectives.owning_person_id%TYPE

264: -- Internal Table Handler Use Only.
265: --
266: --
267: procedure chk_owned_by_person
268: (p_owning_person_id in per_objectives.owning_person_id%TYPE
269: ,p_business_group_id in per_objectives.business_group_id%TYPE
270: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
271: ,p_effective_date in date
272: )

Line 269: ,p_business_group_id in per_objectives.business_group_id%TYPE

265: --
266: --
267: procedure chk_owned_by_person
268: (p_owning_person_id in per_objectives.owning_person_id%TYPE
269: ,p_business_group_id in per_objectives.business_group_id%TYPE
270: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
271: ,p_effective_date in date
272: )
273: is

Line 270: ,p_appraisal_id in per_objectives.appraisal_id%TYPE

266: --
267: procedure chk_owned_by_person
268: (p_owning_person_id in per_objectives.owning_person_id%TYPE
269: ,p_business_group_id in per_objectives.business_group_id%TYPE
270: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
271: ,p_effective_date in date
272: )
273: is
274: --

Line 276: l_business_group_id per_objectives.business_group_id%TYPE;

272: )
273: is
274: --
275: l_exists varchar2(1);
276: l_business_group_id per_objectives.business_group_id%TYPE;
277: l_proc varchar2(72) := g_package||'chk_owned_by_person';
278: --
279: --
280: -- Cursor to check if the person_exists

Line 392: (p_associated_column1 => 'PER_OBJECTIVES.OWNING_PERSON_ID'

388: --
389: exception
390: when app_exception.application_exception then
391: if hr_multi_message.exception_add
392: (p_associated_column1 => 'PER_OBJECTIVES.OWNING_PERSON_ID'
393: ) then
394: raise;
395: end if;
396:

Line 428: (p_objective_id in per_objectives.objective_id%TYPE

424: -- Internal Development use only.
425: --
426: -- ---------------------------------------------------------------------
427: procedure chk_next_review_date
428: (p_objective_id in per_objectives.objective_id%TYPE
429: ,p_start_date in per_objectives.start_date%TYPE
430: ,p_next_review_date in per_objectives.next_review_date%TYPE
431: ,p_object_version_number in per_objectives.object_version_number%TYPE
432: ) is

Line 429: ,p_start_date in per_objectives.start_date%TYPE

425: --
426: -- ---------------------------------------------------------------------
427: procedure chk_next_review_date
428: (p_objective_id in per_objectives.objective_id%TYPE
429: ,p_start_date in per_objectives.start_date%TYPE
430: ,p_next_review_date in per_objectives.next_review_date%TYPE
431: ,p_object_version_number in per_objectives.object_version_number%TYPE
432: ) is
433: --

Line 430: ,p_next_review_date in per_objectives.next_review_date%TYPE

426: -- ---------------------------------------------------------------------
427: procedure chk_next_review_date
428: (p_objective_id in per_objectives.objective_id%TYPE
429: ,p_start_date in per_objectives.start_date%TYPE
430: ,p_next_review_date in per_objectives.next_review_date%TYPE
431: ,p_object_version_number in per_objectives.object_version_number%TYPE
432: ) is
433: --
434: l_proc varchar2(72) := g_package||'chk_next_review_date';

Line 431: ,p_object_version_number in per_objectives.object_version_number%TYPE

427: procedure chk_next_review_date
428: (p_objective_id in per_objectives.objective_id%TYPE
429: ,p_start_date in per_objectives.start_date%TYPE
430: ,p_next_review_date in per_objectives.next_review_date%TYPE
431: ,p_object_version_number in per_objectives.object_version_number%TYPE
432: ) is
433: --
434: l_proc varchar2(72) := g_package||'chk_next_review_date';
435: --

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

446: --
447: exception
448: when app_exception.application_exception then
449: if hr_multi_message.exception_add
450: (p_associated_column1 => 'PER_OBJECTIVES.NEXT_REVIEW_DATE'
451: ) then
452: raise;
453: end if;
454: end chk_next_review_date;

Line 485: (p_objective_id in per_objectives.objective_id%TYPE

481: -- Internal Development use only.
482: --
483: -- ---------------------------------------------------------------------
484: procedure chk_target_date
485: (p_objective_id in per_objectives.objective_id%TYPE
486: ,p_start_date in per_objectives.start_date%TYPE
487: ,p_target_date in per_objectives.target_date%TYPE
488: ,p_object_version_number in per_objectives.object_version_number%TYPE
489: ) is

Line 486: ,p_start_date in per_objectives.start_date%TYPE

482: --
483: -- ---------------------------------------------------------------------
484: procedure chk_target_date
485: (p_objective_id in per_objectives.objective_id%TYPE
486: ,p_start_date in per_objectives.start_date%TYPE
487: ,p_target_date in per_objectives.target_date%TYPE
488: ,p_object_version_number in per_objectives.object_version_number%TYPE
489: ) is
490: --

Line 487: ,p_target_date in per_objectives.target_date%TYPE

483: -- ---------------------------------------------------------------------
484: procedure chk_target_date
485: (p_objective_id in per_objectives.objective_id%TYPE
486: ,p_start_date in per_objectives.start_date%TYPE
487: ,p_target_date in per_objectives.target_date%TYPE
488: ,p_object_version_number in per_objectives.object_version_number%TYPE
489: ) is
490: --
491: l_proc varchar2(72) := g_package||'chk_target_date';

Line 488: ,p_object_version_number in per_objectives.object_version_number%TYPE

484: procedure chk_target_date
485: (p_objective_id in per_objectives.objective_id%TYPE
486: ,p_start_date in per_objectives.start_date%TYPE
487: ,p_target_date in per_objectives.target_date%TYPE
488: ,p_object_version_number in per_objectives.object_version_number%TYPE
489: ) is
490: --
491: l_proc varchar2(72) := g_package||'chk_target_date';
492: --

Line 507: (p_associated_column1 => 'PER_OBJECTIVES.TARGET_DATE'

503: --
504: exception
505: when app_exception.application_exception then
506: if hr_multi_message.exception_add
507: (p_associated_column1 => 'PER_OBJECTIVES.TARGET_DATE'
508: ) then
509: raise;
510: end if;
511:

Line 546: (p_objective_id in per_objectives.objective_id%TYPE

542: -- Internal Development use only.
543: --
544: -- ---------------------------------------------------------------------
545: procedure chk_achiev_date
546: (p_objective_id in per_objectives.objective_id%TYPE
547: ,p_start_date in per_objectives.start_date%TYPE
548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE

Line 547: ,p_start_date in per_objectives.start_date%TYPE

543: --
544: -- ---------------------------------------------------------------------
545: procedure chk_achiev_date
546: (p_objective_id in per_objectives.objective_id%TYPE
547: ,p_start_date in per_objectives.start_date%TYPE
548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
551: ,p_object_version_number in per_objectives.object_version_number%TYPE

Line 548: ,p_achievement_date in per_objectives.achievement_date%TYPE

544: -- ---------------------------------------------------------------------
545: procedure chk_achiev_date
546: (p_objective_id in per_objectives.objective_id%TYPE
547: ,p_start_date in per_objectives.start_date%TYPE
548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
551: ,p_object_version_number in per_objectives.object_version_number%TYPE
552: ,p_scorecard_id IN per_objectives.scorecard_id%TYPE -- new parameter added for for fixing bug#5947176...

Line 549: ,p_complete_percent in per_objectives.complete_percent%TYPE

545: procedure chk_achiev_date
546: (p_objective_id in per_objectives.objective_id%TYPE
547: ,p_start_date in per_objectives.start_date%TYPE
548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
551: ,p_object_version_number in per_objectives.object_version_number%TYPE
552: ,p_scorecard_id IN per_objectives.scorecard_id%TYPE -- new parameter added for for fixing bug#5947176...
553: ) is

Line 550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE

546: (p_objective_id in per_objectives.objective_id%TYPE
547: ,p_start_date in per_objectives.start_date%TYPE
548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
551: ,p_object_version_number in per_objectives.object_version_number%TYPE
552: ,p_scorecard_id IN per_objectives.scorecard_id%TYPE -- new parameter added for for fixing bug#5947176...
553: ) is
554: --

Line 551: ,p_object_version_number in per_objectives.object_version_number%TYPE

547: ,p_start_date in per_objectives.start_date%TYPE
548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
551: ,p_object_version_number in per_objectives.object_version_number%TYPE
552: ,p_scorecard_id IN per_objectives.scorecard_id%TYPE -- new parameter added for for fixing bug#5947176...
553: ) is
554: --
555: l_proc varchar2(72) := g_package||'chk_achiev_date';

Line 552: ,p_scorecard_id IN per_objectives.scorecard_id%TYPE -- new parameter added for for fixing bug#5947176...

548: ,p_achievement_date in per_objectives.achievement_date%TYPE
549: ,p_complete_percent in per_objectives.complete_percent%TYPE
550: ,p_appraisal_id in per_objectives.appraisal_id%TYPE
551: ,p_object_version_number in per_objectives.object_version_number%TYPE
552: ,p_scorecard_id IN per_objectives.scorecard_id%TYPE -- new parameter added for for fixing bug#5947176...
553: ) is
554: --
555: l_proc varchar2(72) := g_package||'chk_achiev_date';
556: l_is_new_appraisal varchar2(1);

Line 618: (p_associated_column1 => 'PER_OBJECTIVES.ACHIEVEMENT_DATE'

614: --
615: exception
616: when app_exception.application_exception then
617: if hr_multi_message.exception_add
618: (p_associated_column1 => 'PER_OBJECTIVES.ACHIEVEMENT_DATE'
619: ) then
620: raise;
621: end if;
622:

Line 654: (p_objective_id in per_objectives.objective_id%TYPE

650: -- Access Status
651: -- Internal Table Handler Use Only.
652: --
653: procedure chk_objective_delete
654: (p_objective_id in per_objectives.objective_id%TYPE
655: ,p_object_version_number in per_objectives.object_version_number%TYPE
656: )
657: is
658: --

Line 655: ,p_object_version_number in per_objectives.object_version_number%TYPE

651: -- Internal Table Handler Use Only.
652: --
653: procedure chk_objective_delete
654: (p_objective_id in per_objectives.objective_id%TYPE
655: ,p_object_version_number in per_objectives.object_version_number%TYPE
656: )
657: is
658: --
659: l_exists varchar2(1);

Line 676: from per_objectives

672: --
673: cursor csr_is_obj_aligned
674: is
675: select 'Y'
676: from per_objectives
677: where aligned_with_objective_id = p_objective_id;
678: --
679: --
680: begin

Line 717: (p_associated_column1 => 'PER_OBJECTIVES.OBJECTIVE_ID'

713: hr_utility.set_location('Leaving: '|| l_proc, 10);
714: exception
715: when app_exception.application_exception then
716: if hr_multi_message.exception_add
717: (p_associated_column1 => 'PER_OBJECTIVES.OBJECTIVE_ID'
718: ) then
719: raise;
720: end if;
721:

Line 803: (p_associated_column1 => 'PER_OBJECTIVES.GROUP_CODE'

799:
800: exception
801: when app_exception.application_exception then
802: if hr_multi_message.exception_add
803: (p_associated_column1 => 'PER_OBJECTIVES.GROUP_CODE'
804: ) then
805: hr_utility.set_location(' Leaving:'||l_proc, 980);
806: raise;
807: end if;

Line 891: (p_associated_column1 => 'PER_OBJECTIVES.PRIORITY_CODE'

887:
888: exception
889: when app_exception.application_exception then
890: if hr_multi_message.exception_add
891: (p_associated_column1 => 'PER_OBJECTIVES.PRIORITY_CODE'
892: ) then
893: hr_utility.set_location(' Leaving:'||l_proc, 980);
894: raise;
895: end if;

Line 987: (p_associated_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'

983:
984: exception
985: when app_exception.application_exception then
986: if hr_multi_message.exception_add
987: (p_associated_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'
988: ) then
989: hr_utility.set_location(' Leaving:'||l_proc, 980);
990: raise;
991: end if;

Line 1074: (p_associated_column1 => 'PER_OBJECTIVES.COMPLETE_PERCENT'

1070:
1071: exception
1072: when app_exception.application_exception then
1073: if hr_multi_message.exception_add
1074: (p_associated_column1 => 'PER_OBJECTIVES.COMPLETE_PERCENT'
1075: ) then
1076: hr_utility.set_location(' Leaving:'||l_proc, 980);
1077: raise;
1078: end if;

Line 1158: (p_check_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'

1154: --
1155: -- Warn if the objective is not marked for appraisal.
1156: --
1157: if hr_multi_message.no_exclusive_error
1158: (p_check_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'
1159: ,p_associated_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'
1160: ) then
1161: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
1162: end if;

Line 1159: ,p_associated_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'

1155: -- Warn if the objective is not marked for appraisal.
1156: --
1157: if hr_multi_message.no_exclusive_error
1158: (p_check_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'
1159: ,p_associated_column1 => 'PER_OBJECTIVES.APPRAISE_FLAG'
1160: ) then
1161: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
1162: end if;
1163:

Line 1191: (p_associated_column1 => 'PER_OBJECTIVES.WEIGHTING_PERCENT'

1187:
1188: exception
1189: when app_exception.application_exception then
1190: if hr_multi_message.exception_add
1191: (p_associated_column1 => 'PER_OBJECTIVES.WEIGHTING_PERCENT'
1192: ) then
1193: hr_utility.set_location(' Leaving:'||l_proc, 980);
1194: raise;
1195: end if;

Line 1288: (p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1284:
1285: exception
1286: when app_exception.application_exception then
1287: if hr_multi_message.exception_add
1288: (p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1289: ) then
1290: hr_utility.set_location(' Leaving:'||l_proc, 980);
1291: raise;
1292: end if;

Line 1361: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1357:
1358: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1359:
1360: if hr_multi_message.no_exclusive_error
1361: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1362: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1363: ) then
1364:
1365: if p_measurement_style_code <> 'N_M'

Line 1362: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1358: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1359:
1360: if hr_multi_message.no_exclusive_error
1361: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1362: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1363: ) then
1364:
1365: if p_measurement_style_code <> 'N_M'
1366: then

Line 1383: (p_associated_column1 => 'PER_OBJECTIVES.MEASURE_NAME'

1379:
1380: exception
1381: when app_exception.application_exception then
1382: if hr_multi_message.exception_add
1383: (p_associated_column1 => 'PER_OBJECTIVES.MEASURE_NAME'
1384: ) then
1385: hr_utility.set_location(' Leaving:'||l_proc, 980);
1386: raise;
1387: end if;

Line 1456: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1452:
1453: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1454:
1455: if hr_multi_message.no_exclusive_error
1456: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1457: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1458: ) then
1459:
1460: if p_measurement_style_code = 'QUANT_M'

Line 1457: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1453: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1454:
1455: if hr_multi_message.no_exclusive_error
1456: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1457: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1458: ) then
1459:
1460: if p_measurement_style_code = 'QUANT_M'
1461: then

Line 1478: (p_associated_column1 => 'PER_OBJECTIVES.TARGET_VALUE'

1474:
1475: exception
1476: when app_exception.application_exception then
1477: if hr_multi_message.exception_add
1478: (p_associated_column1 => 'PER_OBJECTIVES.TARGET_VALUE'
1479: ) then
1480: hr_utility.set_location(' Leaving:'||l_proc, 980);
1481: raise;
1482: end if;

Line 1550: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1546:
1547: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1548:
1549: if hr_multi_message.no_exclusive_error
1550: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1551: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1552: ) then
1553:
1554: if p_measurement_style_code = 'QUANT_M'

Line 1551: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1547: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1548:
1549: if hr_multi_message.no_exclusive_error
1550: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1551: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1552: ) then
1553:
1554: if p_measurement_style_code = 'QUANT_M'
1555: then

Line 1589: (p_associated_column1 => 'PER_OBJECTIVES.UOM_CODE'

1585:
1586: exception
1587: when app_exception.application_exception then
1588: if hr_multi_message.exception_add
1589: (p_associated_column1 => 'PER_OBJECTIVES.UOM_CODE'
1590: ) then
1591: hr_utility.set_location(' Leaving:'||l_proc, 980);
1592: raise;
1593: end if;

Line 1661: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1657:
1658: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1659:
1660: if hr_multi_message.no_exclusive_error
1661: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1662: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1663: ) then
1664:
1665: if p_measurement_style_code = 'QUANT_M'

Line 1662: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'

1658: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1659:
1660: if hr_multi_message.no_exclusive_error
1661: (p_check_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1662: ,p_associated_column1 => 'PER_OBJECTIVES.MEASUREMENT_STYLE_CODE'
1663: ) then
1664:
1665: if p_measurement_style_code = 'QUANT_M'
1666: then

Line 1700: (p_associated_column1 => 'PER_OBJECTIVES.MEASURE_TYPE_CODE'

1696:
1697: exception
1698: when app_exception.application_exception then
1699: if hr_multi_message.exception_add
1700: (p_associated_column1 => 'PER_OBJECTIVES.MEASURE_TYPE_CODE'
1701: ) then
1702: hr_utility.set_location(' Leaving:'||l_proc, 980);
1703: raise;
1704: end if;

Line 1790: (p_associated_column1 => 'PER_OBJECTIVES.SCORECARD_ID')

1786: EXCEPTION
1787:
1788: WHEN app_exception.application_exception THEN
1789: IF hr_multi_message.exception_add
1790: (p_associated_column1 => 'PER_OBJECTIVES.SCORECARD_ID')
1791: THEN
1792: hr_utility.set_location(' Leaving:'|| l_proc, 980);
1793: RAISE;
1794: END IF;

Line 1844: from per_objectives_library

1840: --
1841: Cursor csr_objlib_exists
1842: is
1843: select 'Y'
1844: from per_objectives_library
1845: where objective_id = p_copied_from_lib_id;
1846: --
1847: begin
1848: --

Line 1885: (p_associated_column1 => 'PER_OBJECTIVES.COPIED_FROM_LIBRARY_ID'

1881: --
1882: exception
1883: when app_exception.application_exception then
1884: if hr_multi_message.exception_add
1885: (p_associated_column1 => 'PER_OBJECTIVES.COPIED_FROM_LIBRARY_ID'
1886: ) then
1887: raise;
1888: end if;
1889:

Line 1934: from per_objectives

1930: --
1931: Cursor csr_obj_exists
1932: is
1933: select 'Y'
1934: from per_objectives
1935: where objective_id = p_copied_from_obj_id;
1936: --
1937: begin
1938: --

Line 1975: (p_associated_column1 => 'PER_OBJECTIVES.COPIED_FROM_OBJECTIVE_ID'

1971: --
1972: exception
1973: when app_exception.application_exception then
1974: if hr_multi_message.exception_add
1975: (p_associated_column1 => 'PER_OBJECTIVES.COPIED_FROM_OBJECTIVE_ID'
1976: ) then
1977: raise;
1978: end if;
1979:

Line 2030: per_objectives pobj

2026: IS
2027: SELECT
2028: ppsc.plan_id,ppsc.scorecard_id,ppsc.person_id
2029: FROM
2030: per_objectives pobj
2031: ,per_personal_scorecards ppsc
2032: -- ,per_perf_mgmt_plans ppln
2033: WHERE
2034: pobj.objective_id = p_aligned_with_obj_id

Line 2044: per_objectives pobj

2040: NVL(ppsc.plan_id,ap.plan_id) PLAN_ID,
2041: NVL(ppsc.scorecard_id,ppsc2.scorecard_id) SCORECARD_ID,
2042: NVL(ppsc.person_id,ap.appraisee_person_id) SOURCE_PERSON_ID
2043: FROM
2044: per_objectives pobj
2045: ,per_personal_scorecards ppsc
2046: ,per_personal_scorecards ppsc2
2047: ,per_appraisals ap
2048: WHERE

Line 2079: per_objectives pobj

2075: CURSOR csr_chk_person
2076: IS
2077: SELECT 'Y'
2078: FROM
2079: per_objectives pobj
2080: ,per_personal_scorecards ppsc
2081: ,per_perf_mgmt_plans ppln
2082: WHERE
2083: ppln.plan_id = l_source_plan_id

Line 2190: (p_associated_column1 => 'PER_OBJECTIVES.ALIGNED_WITH_OBJECTIVE_ID'

2186: --
2187: EXCEPTION
2188: WHEN app_exception.application_exception THEN
2189: IF hr_multi_message.exception_add
2190: (p_associated_column1 => 'PER_OBJECTIVES.ALIGNED_WITH_OBJECTIVE_ID'
2191: ) THEN
2192: RAISE;
2193: END IF;
2194:

Line 2248: (p_associated_column1 => 'PER_OBJECTIVES.COPIED_FROM_OBJECTIVE_ID'

2244: --
2245: exception
2246: when app_exception.application_exception then
2247: if hr_multi_message.exception_add
2248: (p_associated_column1 => 'PER_OBJECTIVES.COPIED_FROM_OBJECTIVE_ID'
2249: ) then
2250: raise;
2251: end if;
2252:

Line 2288: ,p_sharing_access_code in per_objectives.sharing_access_code%TYPE

2284: procedure chk_sharing_access_code
2285: (p_objective_id in number
2286: ,p_object_version_number in number
2287: ,p_effective_date in date
2288: ,p_sharing_access_code in per_objectives.sharing_access_code%TYPE
2289: )
2290: is
2291: --
2292: l_exists varchar2(1);

Line 2335: (p_associated_column1 => 'PER_OBJECTIVES.SHARING_ACCESS_CODE'

2331: --
2332: exception
2333: when app_exception.application_exception then
2334: if hr_multi_message.exception_add
2335: (p_associated_column1 => 'PER_OBJECTIVES.SHARING_ACCESS_CODE'
2336: ) then
2337: raise;
2338: end if;
2339:

Line 2453: ,p_descflex_name => 'PER_OBJECTIVES'

2449: -- b) During insert.
2450: --
2451: hr_dflex_utility.ins_or_upd_descflex_attribs
2452: (p_appl_short_name => 'PER'
2453: ,p_descflex_name => 'PER_OBJECTIVES'
2454: ,p_attribute_category => p_rec.attribute_category
2455: ,p_attribute1_name => 'ATTRIBUTE1'
2456: ,p_attribute1_value => p_rec.attribute1
2457: ,p_attribute2_name => 'ATTRIBUTE2'

Line 3080: (p_objective_id in per_objectives.objective_id%TYPE

3076: -- ----------------------------------------------------------------------------
3077: -- |-----------------------< return_legislation_code >-------------------------|
3078: -- ----------------------------------------------------------------------------
3079: function return_legislation_code
3080: (p_objective_id in per_objectives.objective_id%TYPE
3081: ) return varchar2 is
3082: --
3083: -- Curson to find legislation code.
3084: --

Line 3088: per_objectives ppa

3084: --
3085: cursor csr_leg_code is
3086: select legislation_code
3087: from per_business_groups pbg,
3088: per_objectives ppa
3089: where ppa.objective_id = p_objective_id
3090: and pbg.business_group_id = ppa.business_group_id;
3091: --
3092: -- Declare local variables