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.

[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_APPRAISAL_PERIODS

Line 32: TYPE g_plan_aprsl_pds_r IS RECORD (appraisal_period_id per_appraisal_periods.appraisal_period_id%TYPE,

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

Line 33: appraisal_template_id per_appraisal_periods.appraisal_template_id%TYPE,

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

Line 34: start_date per_appraisal_periods.start_date%TYPE,

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

Line 35: end_date per_appraisal_periods.end_date%TYPE,

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

Line 36: task_start_date per_appraisal_periods.task_start_date%TYPE,

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

Line 37: task_end_date per_appraisal_periods.task_end_date%TYPE,

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

Line 38: initiator_code per_appraisal_periods.initiator_code%TYPE,

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

Line 39: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,

35: end_date per_appraisal_periods.end_date%TYPE,
36: task_start_date per_appraisal_periods.task_start_date%TYPE,
37: task_end_date per_appraisal_periods.task_end_date%TYPE,
38: initiator_code per_appraisal_periods.initiator_code%TYPE,
39: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
40: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
41: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
42: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
43: appraisal_type per_appraisal_periods.appraisal_type%TYPE);

Line 40: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,

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

Line 41: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,

37: task_end_date per_appraisal_periods.task_end_date%TYPE,
38: initiator_code per_appraisal_periods.initiator_code%TYPE,
39: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
40: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
41: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
42: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
43: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
44:
45: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;

Line 42: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,

38: initiator_code per_appraisal_periods.initiator_code%TYPE,
39: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
40: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
41: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
42: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
43: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
44:
45: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;
46: g_plan_aprsl_pds_tbl g_plan_aprsl_pds_t;

Line 43: appraisal_type per_appraisal_periods.appraisal_type%TYPE);

39: appraisal_system_type per_appraisal_periods.appraisal_system_type%TYPE,
40: auto_conc_process per_appraisal_periods.auto_conc_process%TYPE,
41: days_before_task_st_dt per_appraisal_periods.days_before_task_st_dt%TYPE,
42: appraisal_assmt_status per_appraisal_periods.appraisal_assmt_status%TYPE,
43: appraisal_type per_appraisal_periods.appraisal_type%TYPE);
44:
45: TYPE g_plan_aprsl_pds_t IS TABLE OF g_plan_aprsl_pds_r INDEX BY binary_integer;
46: g_plan_aprsl_pds_tbl g_plan_aprsl_pds_t;
47: --

Line 385: from per_appraisal_periods pap

381: CURSOR csr_plan_apprsl_pds IS
382: select appraisal_period_id, appraisal_template_id, start_date, end_date, task_start_date,
383: task_end_date, initiator_code, appraisal_system_type, auto_conc_process, days_before_task_st_dt,
384: appraisal_assmt_status, appraisal_type
385: from per_appraisal_periods pap
386: where pap.plan_id = p_plan_id
387: and pap.appraisal_period_id = p_appr_period_id;
388: --
389: Begin

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

427:
428: End populate_plan_apprsl_periods;
429: --
430:
431: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,
432: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,
433: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,
434: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,
435: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE

Line 781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,

777: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,
780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
782: p_appraisal_system_type in per_appraisal_periods.appraisal_system_type%TYPE,
783: p_return_status out nocopy VARCHAR2
784: )
785: IS

Line 782: p_appraisal_system_type in per_appraisal_periods.appraisal_system_type%TYPE,

778: p_status per_appraisals.status%TYPE default null,
779: p_comments per_appraisals.comments%TYPE default null,
780: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,
781: p_appraisal_initiator per_appraisal_periods.initiator_code%TYPE,
782: p_appraisal_system_type in per_appraisal_periods.appraisal_system_type%TYPE,
783: p_return_status out nocopy VARCHAR2
784: )
785: IS
786:

Line 919: l_appraisal_sys_type per_appraisal_periods.appraisal_system_type%TYPE;

915: l_error_message varchar2(1000) default null;
916: APPRAISAL_CREATION_ERROR EXCEPTION;
917: ASSESS_COMP_ERROR EXCEPTION;
918: ASSESS_OBJ_ERROR EXCEPTION;
919: l_appraisal_sys_type per_appraisal_periods.appraisal_system_type%TYPE;
920: function_360_exists boolean default false;
921: APPRAISAL_SYSTEM_TYPE_ERROR EXCEPTION;
922: l_weighting_over_100_warning boolean;
923: l_weighting_appraisal_warning boolean;

Line 1651: p_type => 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

1647: p_appraisal_status => 'PLANNED', -- decided in the meeting
1648: p_plan_id => p_plan_id,
1649: p_next_appraisal_date => null, -- to be
1650: p_appraisal_initiator => g_plan_aprsl_pds_tbl(l_plan_aprsl_pds_index).initiator_code,
1651: p_type => 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
1652: p_appraisal_system_type => g_plan_aprsl_pds_tbl(l_plan_aprsl_pds_index).appraisal_system_type,
1653: p_return_status => l_appr_ret_status
1654: );
1655: IF g_dbg THEN op(l_proc, g_DEBUG_LOG, 80); END IF;