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 57: objective_id per_objectives_library.objective_id%TYPE,

53: g_curr_sc_pop_tbl g_curr_sc_pop_t;
54:
55: -- Used for populating qualifying objectives
56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,

Line 58: objective_name per_objectives_library.objective_name%TYPE,

54:
55: -- Used for populating qualifying objectives
56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,

Line 59: valid_from per_objectives_library.valid_from%TYPE,

55: -- Used for populating qualifying objectives
56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,

Line 60: valid_to per_objectives_library.valid_to%TYPE,

56: TYPE g_qual_obj_r IS RECORD (
57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,

Line 61: target_date per_objectives_library.target_date%TYPE,

57: objective_id per_objectives_library.objective_id%TYPE,
58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,

Line 62: next_review_date per_objectives_library.NEXT_review_date%TYPE,

58: objective_name per_objectives_library.objective_name%TYPE,
59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,

Line 63: group_code per_objectives_library.group_code%TYPE,

59: valid_from per_objectives_library.valid_from%TYPE,
60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,

Line 64: priority_code per_objectives_library.priority_code%TYPE,

60: valid_to per_objectives_library.valid_to%TYPE,
61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,

Line 65: appraise_flag per_objectives_library.appraise_flag%TYPE,

61: target_date per_objectives_library.target_date%TYPE,
62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

Line 66: weighting_percent per_objectives_library.weighting_percent%TYPE,

62: next_review_date per_objectives_library.NEXT_review_date%TYPE,
63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,

Line 67: target_value per_objectives_library.target_value%TYPE,

63: group_code per_objectives_library.group_code%TYPE,
64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,

Line 68: uom_code per_objectives_library.uom_code%TYPE,

64: priority_code per_objectives_library.priority_code%TYPE,
65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,

Line 69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,

65: appraise_flag per_objectives_library.appraise_flag%TYPE,
66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,

Line 70: measure_name per_objectives_library.measure_name%TYPE,

66: weighting_percent per_objectives_library.weighting_percent%TYPE,
67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,

Line 71: measure_type_code per_objectives_library.measure_type_code%TYPE,

67: target_value per_objectives_library.target_value%TYPE,
68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,

Line 72: measure_comments per_objectives_library.measure_comments%TYPE,

68: uom_code per_objectives_library.uom_code%TYPE,
69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);

Line 73: details per_objectives_library.details%TYPE,

69: measurement_style_code per_objectives_library.measurement_style_code%TYPE,
70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);
77:

Line 74: success_criteria per_objectives_library.success_criteria%TYPE,

70: measure_name per_objectives_library.measure_name%TYPE,
71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);
77:
78: TYPE g_qual_obj_t is table of g_qual_obj_r INDEX BY binary_integer;

Line 75: comments per_objectives_library.comments%TYPE,

71: measure_type_code per_objectives_library.measure_type_code%TYPE,
72: measure_comments per_objectives_library.measure_comments%TYPE,
73: details per_objectives_library.details%TYPE,
74: success_criteria per_objectives_library.success_criteria%TYPE,
75: comments per_objectives_library.comments%TYPE,
76: elig_obj_id ben_elig_obj_f.ELIG_OBJ_ID%type);
77:
78: TYPE g_qual_obj_t is table of g_qual_obj_r INDEX BY binary_integer;
79: g_qual_obj_tbl g_qual_obj_t;

Line 82: TYPE g_curr_sc_obj_r IS RECORD (copied_from_library_id per_objectives.copied_from_library_id%TYPE,

78: TYPE g_qual_obj_t is table of g_qual_obj_r INDEX BY binary_integer;
79: g_qual_obj_tbl g_qual_obj_t;
80:
81: -- User for populating existing scorecard objectives
82: TYPE g_curr_sc_obj_r IS RECORD (copied_from_library_id per_objectives.copied_from_library_id%TYPE,
83: objective_id per_objectives.objective_id%TYPE,
84: object_version_number per_objectives.object_version_number%TYPE);
85: TYPE g_curr_sc_obj_t IS TABLE OF g_curr_sc_obj_r INDEX BY binary_integer;
86: g_curr_sc_obj_tbl g_curr_sc_obj_t;

Line 83: objective_id per_objectives.objective_id%TYPE,

79: g_qual_obj_tbl g_qual_obj_t;
80:
81: -- User for populating existing scorecard objectives
82: TYPE g_curr_sc_obj_r IS RECORD (copied_from_library_id per_objectives.copied_from_library_id%TYPE,
83: objective_id per_objectives.objective_id%TYPE,
84: object_version_number per_objectives.object_version_number%TYPE);
85: TYPE g_curr_sc_obj_t IS TABLE OF g_curr_sc_obj_r INDEX BY binary_integer;
86: g_curr_sc_obj_tbl g_curr_sc_obj_t;
87:

Line 84: object_version_number per_objectives.object_version_number%TYPE);

80:
81: -- User for populating existing scorecard objectives
82: TYPE g_curr_sc_obj_r IS RECORD (copied_from_library_id per_objectives.copied_from_library_id%TYPE,
83: objective_id per_objectives.objective_id%TYPE,
84: object_version_number per_objectives.object_version_number%TYPE);
85: TYPE g_curr_sc_obj_t IS TABLE OF g_curr_sc_obj_r INDEX BY binary_integer;
86: g_curr_sc_obj_tbl g_curr_sc_obj_t;
87:
88: -- User for populating plan appraisal periods

Line 907: from per_objectives_library pol,

903: select objective_id, objective_name, valid_from, valid_to, target_date, next_review_date, group_code,
904: priority_code, appraise_flag, weighting_percent, target_value, uom_code, measurement_style_code,
905: measure_name, measure_type_code, measure_comments, details, success_criteria, comments,
906: elig.elig_obj_id
907: from per_objectives_library pol,
908: ben_elig_obj_f elig
909: where (pol.valid_from between p_start_date and p_end_date OR
910: p_start_date between pol.valid_from and nvl(pol.valid_to,to_date('31-12-4712', 'DD-MM-YYYY')))
911: and POL.ELIGIBILITY_TYPE_CODE <> 'N_P'

Line 912: and elig.table_name = 'PER_OBJECTIVES_LIBRARY'

908: ben_elig_obj_f elig
909: where (pol.valid_from between p_start_date and p_end_date OR
910: p_start_date between pol.valid_from and nvl(pol.valid_to,to_date('31-12-4712', 'DD-MM-YYYY')))
911: and POL.ELIGIBILITY_TYPE_CODE <> 'N_P'
912: and elig.table_name = 'PER_OBJECTIVES_LIBRARY'
913: and column_name = 'OBJECTIVE_ID'
914: and elig.column_value = pol.objective_id;
915:
916: Begin

Line 1037: from per_objectives pob

1033:
1034: -- Current scorecard objectives
1035: CURSOR csr_curr_sc_objs IS
1036: select copied_from_library_id, objective_id, object_version_number
1037: from per_objectives pob
1038: where pob.copied_from_library_id IS NOT NULL
1039: and pob.scorecard_id = p_scorecard_id;
1040: --
1041: Begin

Line 2256: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)

2252: IS
2253: select DEFAULT_JOB_COMPETENCIES from per_assessment_types
2254: where assessment_type_id = p_assessment_type_id;
2255:
2256: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)
2257: is
2258: select objective_id, scorecard_id, object_version_number, name from per_objectives
2259: where scorecard_id = p_scorecard_id
2260: and APPRAISE_FLAG = 'Y';

Line 2258: select objective_id, scorecard_id, object_version_number, name from per_objectives

2254: where assessment_type_id = p_assessment_type_id;
2255:
2256: cursor get_scorecard_objectives(p_scorecard_id per_objectives.scorecard_id%TYPE)
2257: is
2258: select objective_id, scorecard_id, object_version_number, name from per_objectives
2259: where scorecard_id = p_scorecard_id
2260: and APPRAISE_FLAG = 'Y';
2261:
2262: cursor get_assess_templ_info (p_assess_templ per_appraisal_templates.assessment_type_id%TYPE)

Line 3784: from per_objectives

3780:
3781: -- Scorecard Objectives
3782: CURSOR csr_sc_objectives(p_scorecard_id number) IS
3783: select objective_id, object_version_number
3784: from per_objectives
3785: where scorecard_id = p_scorecard_id;
3786:
3787: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) IS
3788: select appraisal_id, object_version_number from per_appraisals

Line 4867: FROM per_objectives obj

4863: l_next_review_date date;
4864: --
4865: cursor past_obj is
4866: SELECT obj.*
4867: FROM per_objectives obj
4868: ,per_personal_scorecards psc
4869: WHERE psc.plan_id = p_prev_plan_id
4870: AND psc.assignment_id = p_assignemnt_id
4871: AND psc.scorecard_id = obj.scorecard_id

Line 4875: from per_personal_scorecards psc1, per_objectives pobj1

4871: AND psc.scorecard_id = obj.scorecard_id
4872: AND obj.achievement_date is null
4873: AND obj.appraisal_id is null
4874: AND not exists (select 'X'
4875: from per_personal_scorecards psc1, per_objectives pobj1
4876: where psc1.plan_id = p_curr_plan_id
4877: and psc1.assignment_id = psc.assignment_id
4878: and psc1.scorecard_id = pobj1.scorecard_id
4879: and pobj1.copied_from_objective_id = obj.objective_id);

Line 5229: FROM per_objectives

5225: AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
5226: -- Delete all score card objectives
5227: FORALL i in l_sc_ids.FIRST .. l_sc_ids.LAST
5228: DELETE
5229: FROM per_objectives
5230: WHERE scorecard_id = l_sc_ids(i);
5231: -- Delete all score cards now
5232: FORALL i in l_sc_ids.FIRST .. l_sc_ids.LAST
5233: DELETE

Line 5922: FROM per_objectives po

5918: --
5919: CURSOR csr_appr_objs(p_appraisal_id NUMBER) IS
5920: SELECT po.objective_id
5921: ,po.object_version_number
5922: FROM per_objectives po
5923: WHERE appraisal_id = p_appraisal_id;
5924: --
5925: CURSOR csr_sc_obj(p_sc_id NUMBER, p_objective_id NUMBER) IS
5926: SELECT po.objective_id

Line 5928: FROM per_objectives po

5924: --
5925: CURSOR csr_sc_obj(p_sc_id NUMBER, p_objective_id NUMBER) IS
5926: SELECT po.objective_id
5927: ,po.object_version_number
5928: FROM per_objectives po
5929: WHERE scorecard_id = p_sc_id
5930: AND copied_from_objective_id = p_objective_id;
5931: --
5932: CURSOR csr_sc_id (p_appraisee_person_id NUMBER

Line 6080: FROM per_objectives

6076: WHERE transaction_ref_id = p_scorecard_id
6077: AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6078: --
6079: DELETE
6080: FROM per_objectives
6081: WHERE scorecard_id = p_scorecard_id;
6082: END remove_scorecard_details;
6083: PROCEDURE admin_remove_scorecard(p_plan_id IN NUMBER
6084: ,p_effective_date IN DATE) IS

Line 6273: FROM per_objectives

6269: l_check_elig VARCHAR2(10);
6270: CURSOR csr_sc_dup_obj (p_scorecard_id IN NUMBER,
6271: p_library_id IN NUMBER) IS
6272: SELECT 'Y'
6273: FROM per_objectives
6274: WHERE scorecard_id = p_scorecard_id
6275: AND copied_from_library_id = p_library_id;
6276: l_sc_dup_obj VARCHAR2(1);
6277: l_sup_id per_all_assignments_f.supervisor_id%type default null;