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_WPM_MASS_APR_PUSH dependencies on PER_APPRAISAL_PERIODS

Line 34: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,

30: -- Private user-defined types.
31: --
32: -- Used for populating plan appraisal periods
33: TYPE g_plan_aprsl_pds_r IS RECORD (
34: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,

Line 35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,

31: --
32: -- Used for populating plan appraisal periods
33: TYPE g_plan_aprsl_pds_r IS RECORD (
34: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,

Line 36: start_date per_appraisal_periods.start_date%TYPE,

32: -- Used for populating plan appraisal periods
33: TYPE g_plan_aprsl_pds_r IS RECORD (
34: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,

Line 37: end_date per_appraisal_periods.end_date%TYPE,

33: TYPE g_plan_aprsl_pds_r IS RECORD (
34: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

Line 38: task_start_date per_appraisal_periods.task_start_date%TYPE,

34: appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,
35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

Line 39: task_end_date per_appraisal_periods.task_end_date%TYPE,

35: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,
36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

Line 40: initiator_code per_appraisal_periods.initiator_code%TYPE,

36: start_date per_appraisal_periods.start_date%TYPE,
37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

Line 41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

37: end_date per_appraisal_periods.end_date%TYPE,
38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,

Line 42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

38: task_start_date per_appraisal_periods.task_start_date%TYPE,
39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,
46: participation_type per_appraisal_periods.participation_type%TYPE,

Line 43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

39: task_end_date per_appraisal_periods.task_end_date%TYPE,
40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,
46: participation_type per_appraisal_periods.participation_type%TYPE,
47: questionnaire_template_id per_appraisal_periods.questionnaire_template_id%TYPE

Line 44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

40: initiator_code per_appraisal_periods.initiator_code%TYPE,
41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,
46: participation_type per_appraisal_periods.participation_type%TYPE,
47: questionnaire_template_id per_appraisal_periods.questionnaire_template_id%TYPE
48: );

Line 45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,

41: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,
46: participation_type per_appraisal_periods.participation_type%TYPE,
47: questionnaire_template_id per_appraisal_periods.questionnaire_template_id%TYPE
48: );
49:

Line 46: participation_type per_appraisal_periods.participation_type%TYPE,

42: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,
46: participation_type per_appraisal_periods.participation_type%TYPE,
47: questionnaire_template_id per_appraisal_periods.questionnaire_template_id%TYPE
48: );
49:
50: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r

Line 47: questionnaire_template_id per_appraisal_periods.questionnaire_template_id%TYPE

43: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
44: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
45: appraisal_type per_appraisal_periods.appraisal_type%TYPE,
46: participation_type per_appraisal_periods.participation_type%TYPE,
47: questionnaire_template_id per_appraisal_periods.questionnaire_template_id%TYPE
48: );
49:
50: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r
51: INDEX BY BINARY_INTEGER;

Line 450: FROM per_appraisal_periods pap

446: appraisal_system_type, auto_conc_process,
447: days_before_task_st_dt, appraisal_assmt_status,
448: appraisal_type, participation_type,
449: questionnaire_template_id
450: FROM per_appraisal_periods pap
451: WHERE pap.plan_id = p_plan_id
452: AND pap.appraisal_period_id = p_appr_period_id;
453: --
454: BEGIN

Line 520: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,

516: END populate_plan_apprsl_periods;
517:
518: --
519: FUNCTION get_appraisal_config_params (
520: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,
521: p_function_id IN OUT NOCOPY fnd_form_functions.function_id%TYPE,
522: p_function_name IN OUT NOCOPY fnd_form_functions.function_name%TYPE,
523: p_func_parameters IN OUT NOCOPY fnd_form_functions.PARAMETERS%TYPE,
524: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE

Line 1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,

1037: p_comments per_appraisals.comments%TYPE
1038: DEFAULT NULL,
1039: p_appraisee_access per_appraisals.appraisee_access%TYPE
1040: DEFAULT NULL,
1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
1042: p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,
1043: p_participation_type IN per_appraisal_periods.participation_type%TYPE
1044: DEFAULT NULL,
1045: p_questionnaire_template_id IN per_appraisal_periods.questionnaire_template_id%TYPE

Line 1042: p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,

1038: DEFAULT NULL,
1039: p_appraisee_access per_appraisals.appraisee_access%TYPE
1040: DEFAULT NULL,
1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
1042: p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,
1043: p_participation_type IN per_appraisal_periods.participation_type%TYPE
1044: DEFAULT NULL,
1045: p_questionnaire_template_id IN per_appraisal_periods.questionnaire_template_id%TYPE
1046: DEFAULT NULL,

Line 1043: p_participation_type IN per_appraisal_periods.participation_type%TYPE

1039: p_appraisee_access per_appraisals.appraisee_access%TYPE
1040: DEFAULT NULL,
1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
1042: p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,
1043: p_participation_type IN per_appraisal_periods.participation_type%TYPE
1044: DEFAULT NULL,
1045: p_questionnaire_template_id IN per_appraisal_periods.questionnaire_template_id%TYPE
1046: DEFAULT NULL,
1047: p_return_status OUT NOCOPY VARCHAR2

Line 1045: p_questionnaire_template_id IN per_appraisal_periods.questionnaire_template_id%TYPE

1041: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
1042: p_appraisal_system_type IN per_appraisal_periods.appraisal_system_type%TYPE,
1043: p_participation_type IN per_appraisal_periods.participation_type%TYPE
1044: DEFAULT NULL,
1045: p_questionnaire_template_id IN per_appraisal_periods.questionnaire_template_id%TYPE
1046: DEFAULT NULL,
1047: p_return_status OUT NOCOPY VARCHAR2
1048: )
1049: IS

Line 1240: l_appraisal_sys_type per_appraisal_periods.appraisal_system_type%TYPE;

1236: l_error_message VARCHAR2 (1000) DEFAULT NULL;
1237: appraisal_creation_error EXCEPTION;
1238: assess_comp_error EXCEPTION;
1239: assess_obj_error EXCEPTION;
1240: l_appraisal_sys_type per_appraisal_periods.appraisal_system_type%TYPE;
1241: function_360_exists BOOLEAN DEFAULT FALSE;
1242: appraisal_system_type_error EXCEPTION;
1243: l_weighting_over_100_warning BOOLEAN;
1244: l_weighting_appraisal_warning BOOLEAN;

Line 2422: p_appr_period_id per_appraisal_periods.appraisal_period_id%TYPE

2418: AND p_effective_date BETWEEN papf.effective_start_date
2419: AND papf.effective_end_date;
2420:
2421: CURSOR csr_get_elig_obj_id (
2422: p_appr_period_id per_appraisal_periods.appraisal_period_id%TYPE
2423: )
2424: IS
2425: SELECT elig.elig_obj_id
2426: FROM ben_elig_obj_f elig

Line 2427: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'

2423: )
2424: IS
2425: SELECT elig.elig_obj_id
2426: FROM ben_elig_obj_f elig
2427: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'
2428: AND elig.column_name = 'APPRAISAL_PERIOD_ID'
2429: AND elig.COLUMN_VALUE = p_appr_period_id
2430: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date
2431: AND elig.effective_end_date;

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

2718: ).initiator_code,
2719: p_type => g_plan_aprsl_pds_tbl
2720: (l_plan_aprsl_pds_index
2721: ).appraisal_type,
2722: -- A column to be added to UI and table in per_appraisal_periods
2723: p_appraisal_system_type => g_plan_aprsl_pds_tbl
2724: (l_plan_aprsl_pds_index
2725: ).appraisal_system_type,
2726: p_participation_type => g_plan_aprsl_pds_tbl