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.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_OBJECTIVES

Line 66: objective_id per_objectives_library.objective_id%TYPE,

62: g_curr_sc_pop_tbl g_curr_sc_pop_t;
63:
64: -- Used for populating qualifying objectives
65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,

Line 67: objective_name per_objectives_library.objective_name%TYPE,

63:
64: -- Used for populating qualifying objectives
65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,

Line 68: valid_from per_objectives_library.valid_from%TYPE,

64: -- Used for populating qualifying objectives
65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,

Line 69: valid_to per_objectives_library.valid_to%TYPE,

65: TYPE g_qual_obj_r IS RECORD (
66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,

Line 70: target_date per_objectives_library.target_date%TYPE,

66: objective_id per_objectives_library.objective_id%TYPE,
67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,

Line 71: next_review_date per_objectives_library.next_review_date%TYPE,

67: objective_name per_objectives_library.objective_name%TYPE,
68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,

Line 72: group_code per_objectives_library.group_code%TYPE,

68: valid_from per_objectives_library.valid_from%TYPE,
69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,

Line 73: priority_code per_objectives_library.priority_code%TYPE,

69: valid_to per_objectives_library.valid_to%TYPE,
70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,

Line 74: appraise_flag per_objectives_library.appraise_flag%TYPE,

70: target_date per_objectives_library.target_date%TYPE,
71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

Line 75: weighting_percent per_objectives_library.weighting_percent%TYPE,

71: next_review_date per_objectives_library.next_review_date%TYPE,
72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,

Line 76: target_value per_objectives_library.target_value%TYPE,

72: group_code per_objectives_library.group_code%TYPE,
73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,

Line 77: uom_code per_objectives_library.uom_code%TYPE,

73: priority_code per_objectives_library.priority_code%TYPE,
74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,

Line 78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

74: appraise_flag per_objectives_library.appraise_flag%TYPE,
75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,

Line 79: measure_name per_objectives_library.measure_name%TYPE,

75: weighting_percent per_objectives_library.weighting_percent%TYPE,
76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,

Line 80: measure_type_code per_objectives_library.measure_type_code%TYPE,

76: target_value per_objectives_library.target_value%TYPE,
77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,

Line 81: measure_comments per_objectives_library.measure_comments%TYPE,

77: uom_code per_objectives_library.uom_code%TYPE,
78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE

Line 82: details per_objectives_library.details%TYPE,

78: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );

Line 83: success_criteria per_objectives_library.success_criteria%TYPE,

79: measure_name per_objectives_library.measure_name%TYPE,
80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );
87:

Line 84: comments per_objectives_library.comments%TYPE,

80: measure_type_code per_objectives_library.measure_type_code%TYPE,
81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );
87:
88: TYPE g_qual_obj_t IS TABLE OF g_qual_obj_r

Line 95: copied_from_library_id per_objectives.copied_from_library_id%TYPE,

91: g_qual_obj_tbl g_qual_obj_t;
92:
93: -- User for populating existing scorecard objectives
94: TYPE g_curr_sc_obj_r IS RECORD (
95: copied_from_library_id per_objectives.copied_from_library_id%TYPE,
96: objective_id per_objectives.objective_id%TYPE,
97: object_version_number per_objectives.object_version_number%TYPE
98: );
99:

Line 96: objective_id per_objectives.objective_id%TYPE,

92:
93: -- User for populating existing scorecard objectives
94: TYPE g_curr_sc_obj_r IS RECORD (
95: copied_from_library_id per_objectives.copied_from_library_id%TYPE,
96: objective_id per_objectives.objective_id%TYPE,
97: object_version_number per_objectives.object_version_number%TYPE
98: );
99:
100: TYPE g_curr_sc_obj_t IS TABLE OF g_curr_sc_obj_r

Line 97: object_version_number per_objectives.object_version_number%TYPE

93: -- User for populating existing scorecard objectives
94: TYPE g_curr_sc_obj_r IS RECORD (
95: copied_from_library_id per_objectives.copied_from_library_id%TYPE,
96: objective_id per_objectives.objective_id%TYPE,
97: object_version_number per_objectives.object_version_number%TYPE
98: );
99:
100: TYPE g_curr_sc_obj_t IS TABLE OF g_curr_sc_obj_r
101: INDEX BY BINARY_INTEGER;

Line 1345: FROM per_objectives_library pol, ben_elig_obj_f elig

1341: IS
1342: SELECT objective_id, objective_name, valid_from, valid_to, target_date, next_review_date, group_code, priority_code,
1343: appraise_flag, weighting_percent, target_value, uom_code, measurement_style_code, measure_name,
1344: measure_type_code, measure_comments, details, success_criteria, comments, elig.elig_obj_id
1345: FROM per_objectives_library pol, ben_elig_obj_f elig
1346: WHERE ( pol.valid_from BETWEEN p_start_date AND p_end_date
1347: OR p_start_date BETWEEN pol.valid_from AND NVL (pol.valid_to, TO_DATE ('31-12-4712', 'DD-MM-YYYY'))
1348: )
1349: AND pol.eligibility_type_code <> 'N_P'

Line 1350: AND elig.table_name = 'PER_OBJECTIVES_LIBRARY'

1346: WHERE ( pol.valid_from BETWEEN p_start_date AND p_end_date
1347: OR p_start_date BETWEEN pol.valid_from AND NVL (pol.valid_to, TO_DATE ('31-12-4712', 'DD-MM-YYYY'))
1348: )
1349: AND pol.eligibility_type_code <> 'N_P'
1350: AND elig.table_name = 'PER_OBJECTIVES_LIBRARY'
1351: AND column_name = 'OBJECTIVE_ID'
1352: AND elig.COLUMN_VALUE = pol.objective_id
1353: -- added 23-Jun-2009 schowdhu
1354: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;

Line 1507: FROM per_objectives pob

1503: -- Current scorecard objectives
1504: CURSOR csr_curr_sc_objs
1505: IS
1506: SELECT copied_from_library_id, objective_id, object_version_number
1507: FROM per_objectives pob
1508: WHERE pob.copied_from_library_id IS NOT NULL AND pob.scorecard_id = p_scorecard_id;
1509: --
1510: BEGIN
1511: --

Line 2350: op('Lock on per_objectives not acquired:' || l_proc, g_regular_log, 30);

2346: IF (p_objective_id IS NOT NULL AND p_object_version_number IS NOT NULL)
2347: THEN
2348: per_obj_shd.lck(p_objective_id, p_object_version_number);
2349: ELSE
2350: op('Lock on per_objectives not acquired:' || l_proc, g_regular_log, 30);
2351: END IF;
2352:
2353: --
2354: --

Line 2429: UPDATE per_objectives

2425: -- We must now examine each argument value in the
2426: -- procedure to see if a system default is being used. If a system default
2427: -- is being used then we must set to the 'current' argument value.
2428:
2429: UPDATE per_objectives
2430: SET scorecard_id = decode(p_scorecard_id,hr_api.g_number,per_obj_shd.g_old_rec.scorecard_id,p_scorecard_id)
2431: ,start_date = decode(p_start_date,hr_api.g_date,per_obj_shd.g_old_rec.start_date,p_start_date)
2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)
2433: ,target_date = l_target_date

Line 3033: CURSOR get_scorecard_objectives (p_scorecard_id per_objectives.scorecard_id%TYPE)

3029: SELECT default_job_competencies
3030: FROM per_assessment_types
3031: WHERE assessment_type_id = p_assessment_type_id;
3032:
3033: CURSOR get_scorecard_objectives (p_scorecard_id per_objectives.scorecard_id%TYPE)
3034: IS
3035: SELECT objective_id, scorecard_id, object_version_number, NAME
3036: FROM per_objectives
3037: WHERE scorecard_id = p_scorecard_id AND appraise_flag = 'Y';

Line 3036: FROM per_objectives

3032:
3033: CURSOR get_scorecard_objectives (p_scorecard_id per_objectives.scorecard_id%TYPE)
3034: IS
3035: SELECT objective_id, scorecard_id, object_version_number, NAME
3036: FROM per_objectives
3037: WHERE scorecard_id = p_scorecard_id AND appraise_flag = 'Y';
3038:
3039: CURSOR get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)
3040: IS

Line 4881: FROM per_objectives

4877: -- Scorecard Objectives
4878: CURSOR csr_sc_objectives (p_scorecard_id NUMBER)
4879: IS
4880: SELECT objective_id, object_version_number
4881: FROM per_objectives
4882: WHERE scorecard_id = p_scorecard_id;
4883:
4884: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
4885: IS

Line 6525: FROM per_objectives obj, per_personal_scorecards psc

6521: --
6522: CURSOR past_obj
6523: IS
6524: SELECT obj.*
6525: FROM per_objectives obj, per_personal_scorecards psc
6526: WHERE psc.plan_id = p_prev_plan_id
6527: AND psc.assignment_id = p_assignemnt_id
6528: AND psc.scorecard_id = obj.scorecard_id
6529: AND obj.achievement_date IS NULL

Line 6533: FROM per_personal_scorecards psc1, per_objectives pobj1

6529: AND obj.achievement_date IS NULL
6530: AND obj.appraisal_id IS NULL
6531: AND NOT EXISTS (
6532: SELECT 'X'
6533: FROM per_personal_scorecards psc1, per_objectives pobj1
6534: WHERE psc1.plan_id = p_curr_plan_id
6535: AND psc1.assignment_id = psc.assignment_id
6536: AND psc1.scorecard_id = pobj1.scorecard_id
6537: AND pobj1.copied_from_objective_id = obj.objective_id);

Line 6944: DELETE FROM per_objectives

6940: DELETE FROM hr_api_transactions
6941: WHERE transaction_ref_id = l_sc_ids (i) AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6942: -- Delete all score card objectives
6943: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6944: DELETE FROM per_objectives
6945: WHERE scorecard_id = l_sc_ids (i);
6946: -- Delete all score cards now
6947: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6948: DELETE FROM per_personal_scorecards

Line 7877: FROM per_objectives po

7873: --
7874: CURSOR csr_appr_objs (p_appraisal_id NUMBER)
7875: IS
7876: SELECT po.objective_id, po.object_version_number
7877: FROM per_objectives po
7878: WHERE appraisal_id = p_appraisal_id;
7879:
7880: --
7881: CURSOR csr_sc_obj (p_sc_id NUMBER, p_objective_id NUMBER)

Line 7884: FROM per_objectives po

7880: --
7881: CURSOR csr_sc_obj (p_sc_id NUMBER, p_objective_id NUMBER)
7882: IS
7883: SELECT po.objective_id, po.object_version_number
7884: FROM per_objectives po
7885: WHERE scorecard_id = p_sc_id AND copied_from_objective_id = p_objective_id;
7886:
7887: --
7888: CURSOR csr_sc_id (p_appraisee_person_id NUMBER, p_plan_id NUMBER)

Line 8038: DELETE FROM per_objectives

8034: DELETE FROM hr_api_transactions
8035: WHERE transaction_ref_id = p_scorecard_id AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
8036:
8037: --
8038: DELETE FROM per_objectives
8039: WHERE scorecard_id = p_scorecard_id;
8040: END remove_scorecard_details;
8041:
8042: PROCEDURE admin_remove_scorecard (p_plan_id IN NUMBER, p_effective_date IN DATE)

Line 8235: FROM per_objectives

8231:
8232: CURSOR csr_sc_dup_obj (p_scorecard_id IN NUMBER, p_library_id IN NUMBER)
8233: IS
8234: SELECT 'Y'
8235: FROM per_objectives
8236: WHERE scorecard_id = p_scorecard_id AND copied_from_library_id = p_library_id;
8237:
8238: l_sc_dup_obj VARCHAR2 (1);
8239: l_sup_id per_all_assignments_f.supervisor_id%TYPE DEFAULT NULL;

Line 8679: FROM per_objectives

8675:
8676: CURSOR csr_curr_objs (p_sc_id IN NUMBER)
8677: IS
8678: SELECT *
8679: FROM per_objectives
8680: WHERE scorecard_id = p_sc_id;
8681:
8682:
8683: l_objective_id NUMBER;

Line 8702: FROM per_objectives

8698: SELECT 'Y'
8699: INTO l_exists
8700: FROM DUAL
8701: WHERE EXISTS (Select 'x'
8702: FROM per_objectives
8703: WHERE scorecard_id = p_target_sc_id
8704: AND (copied_from_library_id = i.copied_from_library_id
8705: OR copied_from_objective_id = i.objective_id));
8706: EXCEPTION

Line 9878: FROM per_objectives

9874:
9875: CURSOR csr_sc_dup_obj (p_scorecard_id IN NUMBER, p_library_id IN NUMBER)
9876: IS
9877: SELECT 'Y'
9878: FROM per_objectives
9879: WHERE scorecard_id = p_scorecard_id AND copied_from_library_id = p_library_id;
9880:
9881: --
9882: CURSOR csr_sc_obj (p_scorecard_id IN NUMBER, p_objective_id IN NUMBER)

Line 9885: FROM per_objectives po

9881: --
9882: CURSOR csr_sc_obj (p_scorecard_id IN NUMBER, p_objective_id IN NUMBER)
9883: IS
9884: SELECT objective_id, object_version_number
9885: FROM per_objectives po
9886: WHERE po.scorecard_id = p_scorecard_id AND po.copied_from_library_id = p_objective_id;
9887:
9888: l_obj_ovn NUMBER;
9889: l_objective_id NUMBER;

Line 10910: FROM per_objectives

10906: -- Scorecard Objectives
10907: CURSOR csr_sc_objectives (p_scorecard_id NUMBER)
10908: IS
10909: SELECT objective_id, object_version_number
10910: FROM per_objectives
10911: WHERE scorecard_id = p_scorecard_id;
10912:
10913: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
10914: IS