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_APPRAISAL_PERIODS

Line 89: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%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
89: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,

Line 90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,

86: g_curr_sc_obj_tbl g_curr_sc_obj_t;
87:
88: -- User for populating plan appraisal periods
89: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,

Line 91: start_date per_appraisal_periods.start_date%TYPE,

87:
88: -- User for populating plan appraisal periods
89: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,

Line 92: end_date per_appraisal_periods.end_date%TYPE,

88: -- User for populating plan appraisal periods
89: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

Line 93: task_start_date per_appraisal_periods.task_start_date%TYPE,

89: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

Line 94: task_end_date per_appraisal_periods.task_end_date%TYPE,

90: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

Line 95: initiator_code per_appraisal_periods.initiator_code%TYPE,

91: start_date per_appraisal_periods.start_date%TYPE,
92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

Line 96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

92: end_date per_appraisal_periods.end_date%TYPE,
93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
100: appraisal_type per_appraisal_periods.appraisal_type%TYPE);

Line 97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

93: task_start_date per_appraisal_periods.task_start_date%TYPE,
94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
100: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
101: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;

Line 98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

94: task_end_date per_appraisal_periods.task_end_date%TYPE,
95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
100: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
101: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;
102: g_plan_aprsl_pds_tbl g_plan_aprsl_pds_t;

Line 99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

95: initiator_code per_appraisal_periods.initiator_code%TYPE,
96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
100: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
101: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;
102: g_plan_aprsl_pds_tbl g_plan_aprsl_pds_t;
103: --

Line 100: appraisal_type per_appraisal_periods.appraisal_type%TYPE);

96: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
97: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
98: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
99: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
100: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
101: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;
102: g_plan_aprsl_pds_tbl g_plan_aprsl_pds_t;
103: --
104: TYPE g_boolean_t IS TABLE OF BOOLEAN INDEX BY binary_integer;

Line 179: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,

175: competence_id per_competences.competence_id%TYPE );
176: type competences_tbl is TABLE OF competences_rc INDEX BY BINARY_INTEGER;
177:
178: TYPE appr_prds_rc is RECORD (
179: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
180: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
181: business_group_id per_appraisal_templates.business_group_id%TYPE);
182: type appr_prds_tbl is table of appr_prds_rc index by binary_integer;
183:

Line 180: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,

176: type competences_tbl is TABLE OF competences_rc INDEX BY BINARY_INTEGER;
177:
178: TYPE appr_prds_rc is RECORD (
179: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
180: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
181: business_group_id per_appraisal_templates.business_group_id%TYPE);
182: type appr_prds_tbl is table of appr_prds_rc index by binary_integer;
183:
184:

Line 576: from per_appraisal_periods prds, per_appraisal_templates templ

572: select p_plan_rec.top_position_id subordinate_position_id from dual));
573:
574: CURSOR csr_apprl_periods(p_pln_id per_perf_mgmt_plans.plan_id%TYPE) IS
575: select prds.appraisal_period_id, prds.appraisal_template_id, templ.business_group_id
576: from per_appraisal_periods prds, per_appraisal_templates templ
577: where prds.plan_id = p_pln_id
578: and templ.appraisal_template_id = prds.appraisal_template_id;
579:
580: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;

Line 1151: from per_appraisal_periods pap

1147: CURSOR csr_plan_apprsl_pds IS
1148: select appraisal_period_id, appraisal_template_id, start_date, end_date, task_start_date,
1149: task_end_date, initiator_code, appraisal_system_type, auto_conc_process, days_before_task_st_dt,
1150: appraisal_assmt_status, appraisal_type
1151: from per_appraisal_periods pap
1152: where pap.plan_id = p_plan_id;
1153: --
1154: Begin
1155: --

Line 1865: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,

1861: RAISE;
1862: END IF;
1863: End delete_scorecard_objective;
1864:
1865: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,
1866: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,
1867: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,
1868: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,
1869: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE

Line 2214: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,

2210: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
2211: p_status per_appraisals.status%TYPE default null,
2212: p_comments per_appraisals.comments%TYPE default null,
2213: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
2214: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
2215: p_return_status out nocopy VARCHAR2
2216: )
2217: IS
2218:

Line 5770: g_plan_aprsl_pds_tbl(l_plan_aprsl_pds_index).appraisal_type, -- A column to be added to UI and table in per_appraisal_periods

5766: p_next_appraisal_date => null, -- to be
5767: p_appraisal_initiator =>
5768: g_plan_aprsl_pds_tbl(l_plan_aprsl_pds_index).initiator_code,
5769: p_type =>
5770: g_plan_aprsl_pds_tbl(l_plan_aprsl_pds_index).appraisal_type, -- A column to be added to UI and table in per_appraisal_periods
5771: p_appraisal_system_type =>
5772: g_plan_aprsl_pds_tbl(l_plan_aprsl_pds_index).appraisal_system_type,
5773: p_return_status => l_appr_ret_status
5774: );

Line 6175: FROM per_appraisal_periods

6171: papf.effective_end_date;
6172: CURSOR csr_appr_in_progress(p_plan_id IN NUMBER,
6173: p_effective_date IN DATE) IS
6174: SELECT 'Y'
6175: FROM per_appraisal_periods
6176: WHERE plan_id = p_plan_id
6177: AND p_effective_date BETWEEN task_start_date AND task_end_date;
6178: l_appraisals_in_progress VARCHAR2(1) := 'N';
6179: l_sc_dtls VARCHAR2(500);