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 107: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,

103: g_curr_sc_obj_tbl g_curr_sc_obj_t;
104:
105: -- User for populating plan appraisal periods
106: TYPE g_plan_aprsl_pds_r IS RECORD (
107: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,

Line 108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,

104:
105: -- User for populating plan appraisal periods
106: TYPE g_plan_aprsl_pds_r IS RECORD (
107: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,

Line 109: start_date per_appraisal_periods.start_date%TYPE,

105: -- User for populating plan appraisal periods
106: TYPE g_plan_aprsl_pds_r IS RECORD (
107: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,

Line 110: end_date per_appraisal_periods.end_date%TYPE,

106: TYPE g_plan_aprsl_pds_r IS RECORD (
107: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

Line 111: task_start_date per_appraisal_periods.task_start_date%TYPE,

107: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

Line 112: task_end_date per_appraisal_periods.task_end_date%TYPE,

108: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

Line 113: initiator_code per_appraisal_periods.initiator_code%TYPE,

109: start_date per_appraisal_periods.start_date%TYPE,
110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

Line 114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

110: end_date per_appraisal_periods.end_date%TYPE,
111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
118: appraisal_type per_appraisal_periods.appraisal_type%TYPE

Line 115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

111: task_start_date per_appraisal_periods.task_start_date%TYPE,
112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
118: appraisal_type per_appraisal_periods.appraisal_type%TYPE
119: );

Line 116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

112: task_end_date per_appraisal_periods.task_end_date%TYPE,
113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
118: appraisal_type per_appraisal_periods.appraisal_type%TYPE
119: );
120:

Line 117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

113: initiator_code per_appraisal_periods.initiator_code%TYPE,
114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
118: appraisal_type per_appraisal_periods.appraisal_type%TYPE
119: );
120:
121: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r

Line 118: appraisal_type per_appraisal_periods.appraisal_type%TYPE

114: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
115: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
116: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
117: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
118: appraisal_type per_appraisal_periods.appraisal_type%TYPE
119: );
120:
121: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r
122: INDEX BY BINARY_INTEGER;

Line 211: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,

207: TYPE competences_tbl IS TABLE OF competences_rc
208: INDEX BY BINARY_INTEGER;
209:
210: TYPE appr_prds_rc IS RECORD (
211: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
212: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
213: business_group_id per_appraisal_templates.business_group_id%TYPE
214: );
215:

Line 212: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,

208: INDEX BY BINARY_INTEGER;
209:
210: TYPE appr_prds_rc IS RECORD (
211: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
212: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
213: business_group_id per_appraisal_templates.business_group_id%TYPE
214: );
215:
216: TYPE appr_prds_tbl IS TABLE OF appr_prds_rc

Line 883: FROM per_appraisal_periods prds, per_appraisal_templates templ

879:
880: CURSOR csr_apprl_periods (p_pln_id per_perf_mgmt_plans.plan_id%TYPE)
881: IS
882: SELECT prds.appraisal_period_id, prds.appraisal_template_id, templ.business_group_id
883: FROM per_appraisal_periods prds, per_appraisal_templates templ
884: WHERE prds.plan_id = p_pln_id AND templ.appraisal_template_id = prds.appraisal_template_id;
885:
886: l_last_bg_id per_appraisal_templates.business_group_id%TYPE;
887: l_bg_change BOOLEAN DEFAULT FALSE;

Line 1652: FROM per_appraisal_periods pap

1648: CURSOR csr_plan_apprsl_pds
1649: IS
1650: SELECT appraisal_period_id, appraisal_template_id, start_date, end_date, task_start_date, task_end_date, initiator_code,
1651: appraisal_system_type, auto_conc_process, days_before_task_st_dt, appraisal_assmt_status, appraisal_type
1652: FROM per_appraisal_periods pap
1653: WHERE pap.plan_id = p_plan_id;
1654: --
1655: BEGIN
1656: --

Line 2587: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,

2583: END IF;
2584: END delete_scorecard_objective;
2585:
2586: FUNCTION get_appraisal_config_params (
2587: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,
2588: p_function_id IN OUT NOCOPY fnd_form_functions.function_id%TYPE,
2589: p_function_name IN OUT NOCOPY fnd_form_functions.function_name%TYPE,
2590: p_func_parameters IN OUT NOCOPY fnd_form_functions.PARAMETERS%TYPE,
2591: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE

Line 2992: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,

2988: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE DEFAULT NULL,
2989: p_status per_appraisals.status%TYPE DEFAULT NULL,
2990: p_comments per_appraisals.comments%TYPE DEFAULT NULL,
2991: p_appraisee_access per_appraisals.appraisee_access%TYPE DEFAULT NULL,
2992: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
2993: p_return_status OUT NOCOPY VARCHAR2
2994: )
2995: IS
2996: CURSOR get_scorecard_info (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

Line 4856: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE

4852:
4853: --Cursor to get pending Requests
4854: CURSOR previous_concurrent_requests (
4855: plan_id per_appraisals.plan_id%TYPE,
4856: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE
4857: )
4858: IS
4859: SELECT cr.request_id, cr.phase_code
4860: FROM fnd_concurrent_programs cp, fnd_concurrent_requests cr

Line 7429: CURSOR get_elig_obj_id_for_period (p_appraisal_period_id IN per_appraisal_periods.appraisal_period_id%TYPE)

7425: l_proc VARCHAR2 (72) := g_package || 'enroll_a_person';
7426:
7427: -- cursor added
7428: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.
7429: CURSOR get_elig_obj_id_for_period (p_appraisal_period_id IN per_appraisal_periods.appraisal_period_id%TYPE)
7430: IS
7431: SELECT elig.elig_obj_id
7432: FROM ben_elig_obj_f elig
7433: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'

Line 7433: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'

7429: CURSOR get_elig_obj_id_for_period (p_appraisal_period_id IN per_appraisal_periods.appraisal_period_id%TYPE)
7430: IS
7431: SELECT elig.elig_obj_id
7432: FROM ben_elig_obj_f elig
7433: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'
7434: AND elig.column_name = 'APPRAISAL_PERIOD_ID'
7435: AND elig.COLUMN_VALUE = p_appraisal_period_id
7436: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;
7437: BEGIN

Line 7698: -- A column to be added to UI and table in per_appraisal_periods

7694: p_plan_id => p_plan_id,
7695: p_next_appraisal_date => NULL, -- to be
7696: p_appraisal_initiator => g_plan_aprsl_pds_tbl (l_plan_aprsl_pds_index).initiator_code,
7697: p_type => g_plan_aprsl_pds_tbl (l_plan_aprsl_pds_index).appraisal_type,
7698: -- A column to be added to UI and table in per_appraisal_periods
7699: p_appraisal_system_type => g_plan_aprsl_pds_tbl (l_plan_aprsl_pds_index).appraisal_system_type,
7700: p_return_status => l_appr_ret_status
7701: );
7702: END IF; -- eligibility check

Line 8138: FROM per_appraisal_periods

8134:
8135: CURSOR csr_appr_in_progress (p_plan_id IN NUMBER, p_effective_date IN DATE)
8136: IS
8137: SELECT 'Y'
8138: FROM per_appraisal_periods
8139: WHERE plan_id = p_plan_id AND p_effective_date BETWEEN task_start_date AND task_end_date;
8140:
8141: l_appraisals_in_progress VARCHAR2 (1) := 'N';
8142: l_sc_dtls VARCHAR2 (500);

Line 8822: FROM per_personal_scorecards sc, per_perf_mgmt_plans pl, per_appraisal_periods ap

8818: SELECT 'Y'
8819: FROM DUAL
8820: WHERE EXISTS (
8821: SELECT 'x'
8822: FROM per_personal_scorecards sc, per_perf_mgmt_plans pl, per_appraisal_periods ap
8823: WHERE sc.scorecard_id = p_scorecard_id
8824: AND sc.plan_id = pl.plan_id
8825: AND pl.plan_id = ap.plan_id
8826: AND p_eff_date BETWEEN ap.task_start_date AND ap.task_end_date);