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_APPRAISALS

Line 1869: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE

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
1870: )
1871: return boolean
1872: is
1873: l_resp_id number;

Line 2205: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',

2201: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
2202: p_effective_date DATE,
2203: p_appraisal_start_date DATE,
2204: p_appraisal_end_date DATE,
2205: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
2206: p_type per_appraisals.type%TYPE default null,
2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,

Line 2206: p_type per_appraisals.type%TYPE default null,

2202: p_effective_date DATE,
2203: p_appraisal_start_date DATE,
2204: p_appraisal_end_date DATE,
2205: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
2206: p_type per_appraisals.type%TYPE default null,
2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,
2210: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,

Line 2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,

2203: p_appraisal_start_date DATE,
2204: p_appraisal_end_date DATE,
2205: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
2206: p_type per_appraisals.type%TYPE default null,
2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,
2210: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,
2211: p_status per_appraisals.status%TYPE default null,

Line 2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,

2204: p_appraisal_end_date DATE,
2205: p_appraisal_status per_appraisals.status%TYPE default 'PLANNED',
2206: p_type per_appraisals.type%TYPE default null,
2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,
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,

Line 2210: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE default null,

2206: p_type per_appraisals.type%TYPE default null,
2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,
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,

Line 2211: p_status per_appraisals.status%TYPE default null,

2207: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,
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

Line 2212: p_comments per_appraisals.comments%TYPE default null,

2208: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2209: p_plan_id number,
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: )

Line 2213: p_appraisee_access per_appraisals.appraisee_access%TYPE default null,

2209: p_plan_id number,
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

Line 2231: cursor get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)

2227: FROM per_all_assignments_f
2228: WHERE assignment_id = p_assignment_id
2229: and trunc(sysdate) between effective_start_date and effective_end_date;
2230:
2231: cursor get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)
2232: IS
2233: SELECT appraisal_template_id, assessment_type_id, objective_asmnt_type_id, business_group_id
2234: FROM per_appraisal_templates
2235: WHERE appraisal_template_id = p_appraisal_templ_id;

Line 2271: l_appraisal_ovn per_appraisals.object_version_number%TYPE;

2267: l_scorecard_info scorecard_info;
2268: NO_SCORE_CARD_WITH_THIS_ID EXCEPTION;
2269: l_assignment_info assignment_info;
2270: NO_ASSIGNMENT_WITH_THIS_ID EXCEPTION;
2271: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
2272: l_apprl_return_status VARCHAR2(10) default null;
2273: l_assess_comp_return_status VARCHAR2(10) default null;
2274: l_assess_obj_return_status VARCHAR2(10) default null;
2275: l_apprl_id per_appraisals.appraisal_id%TYPE default null;

Line 2275: l_apprl_id per_appraisals.appraisal_id%TYPE default null;

2271: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
2272: l_apprl_return_status VARCHAR2(10) default null;
2273: l_assess_comp_return_status VARCHAR2(10) default null;
2274: l_assess_obj_return_status VARCHAR2(10) default null;
2275: l_apprl_id per_appraisals.appraisal_id%TYPE default null;
2276: l_apprl_templ_info appraisal_templ_info;
2277: NO_APPRL_TEMPL_WITH_THIS_ID EXCEPTION;
2278: l_assessment_comp_id per_assessments.assessment_id%TYPE;
2279: l_assessment_obj_id per_assessments.assessment_id%TYPE;

Line 2849: cursor get_assessm_for_apprl(apprl_id per_appraisals.appraisal_id%TYPE) is

2845:
2846: -- Declare local variables
2847: l_proc varchar2(72) := g_package||'delete_appraisal_for_person ';
2848:
2849: cursor get_assessm_for_apprl(apprl_id per_appraisals.appraisal_id%TYPE) is
2850: select assessment_id, object_version_number from per_assessments
2851: where appraisal_id = apprl_id;
2852:
2853: cursor get_competences(assess_id per_assessments.assessment_id%TYPE) is

Line 3767: CURSOR csr_get_appr_part(p_appraisal_id per_appraisals.appraisal_id%TYPE) IS

3763: l_curr_sc_obj_index binary_integer;
3764: l_appr_ret_status varchar2(1);
3765: l_check_elig varchar2(1);
3766: -- Cursor to get the Participants of an appraisal other than MA
3767: CURSOR csr_get_appr_part(p_appraisal_id per_appraisals.appraisal_id%TYPE) IS
3768: select PARTICIPANT_ID ,OBJECT_VERSION_NUMBER,PARTICIPATION_TYPE from per_participants
3769: where participation_in_id =p_appraisal_id
3770: and participation_in_table = 'PER_APPRAISALS'
3771: and participation_in_column = 'APPRAISAL_ID'

Line 3770: and participation_in_table = 'PER_APPRAISALS'

3766: -- Cursor to get the Participants of an appraisal other than MA
3767: CURSOR csr_get_appr_part(p_appraisal_id per_appraisals.appraisal_id%TYPE) IS
3768: select PARTICIPANT_ID ,OBJECT_VERSION_NUMBER,PARTICIPATION_TYPE from per_participants
3769: where participation_in_id =p_appraisal_id
3770: and participation_in_table = 'PER_APPRAISALS'
3771: and participation_in_column = 'APPRAISAL_ID'
3772: and PARTICIPATION_TYPE <> 'MAINAP'
3773: and PARTICIPATION_STATUS = 'OPEN';
3774:

Line 3787: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) 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
3789: where plan_id = plan_id;
3790:
3791: CURSOR csr_find_appr_for_scorecard(p_plan_id per_appraisals.plan_id%TYPE,p_scorecard_id per_personal_scorecards.SCORECARD_ID%TYPE ) IS

Line 3788: select appraisal_id, object_version_number from per_appraisals

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
3789: where plan_id = plan_id;
3790:
3791: CURSOR csr_find_appr_for_scorecard(p_plan_id per_appraisals.plan_id%TYPE,p_scorecard_id per_personal_scorecards.SCORECARD_ID%TYPE ) IS
3792: select pa.appraisal_id, pa.object_version_number ,pa.appraisal_system_status

Line 3791: CURSOR csr_find_appr_for_scorecard(p_plan_id per_appraisals.plan_id%TYPE,p_scorecard_id per_personal_scorecards.SCORECARD_ID%TYPE ) IS

3787: CURSOR csr_plan_appraisals(plan_id per_appraisals.plan_id%TYPE) IS
3788: select appraisal_id, object_version_number from per_appraisals
3789: where plan_id = plan_id;
3790:
3791: CURSOR csr_find_appr_for_scorecard(p_plan_id per_appraisals.plan_id%TYPE,p_scorecard_id per_personal_scorecards.SCORECARD_ID%TYPE ) IS
3792: select pa.appraisal_id, pa.object_version_number ,pa.appraisal_system_status
3793: from per_appraisals pa,per_personal_scorecards pps
3794: where pa.plan_id = p_plan_id
3795: and APPRAISEE_PERSON_ID =pps.person_id

Line 3793: from per_appraisals pa,per_personal_scorecards pps

3789: where plan_id = plan_id;
3790:
3791: CURSOR csr_find_appr_for_scorecard(p_plan_id per_appraisals.plan_id%TYPE,p_scorecard_id per_personal_scorecards.SCORECARD_ID%TYPE ) IS
3792: select pa.appraisal_id, pa.object_version_number ,pa.appraisal_system_status
3793: from per_appraisals pa,per_personal_scorecards pps
3794: where pa.plan_id = p_plan_id
3795: and APPRAISEE_PERSON_ID =pps.person_id
3796: and pps.scorecard_id =p_scorecard_id;
3797:

Line 3805: l_appr_ovn per_appraisals.object_version_number%TYPE;

3801: l_scorecard_status_code varchar2(30);
3802: l_process_date date;
3803: l_process_date_char varchar2(50);
3804: l_request_id number;
3805: l_appr_ovn per_appraisals.object_version_number%TYPE;
3806: l_appr_id per_appraisals.appraisal_id%TYPE;
3807: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
3808: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
3809: begin

Line 3806: l_appr_id per_appraisals.appraisal_id%TYPE;

3802: l_process_date date;
3803: l_process_date_char varchar2(50);
3804: l_request_id number;
3805: l_appr_ovn per_appraisals.object_version_number%TYPE;
3806: l_appr_id per_appraisals.appraisal_id%TYPE;
3807: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
3808: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
3809: begin
3810: --

Line 3807: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;

3803: l_process_date_char varchar2(50);
3804: l_request_id number;
3805: l_appr_ovn per_appraisals.object_version_number%TYPE;
3806: l_appr_id per_appraisals.appraisal_id%TYPE;
3807: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
3808: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
3809: begin
3810: --
3811: -- Initialize logging

Line 3808: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

3804: l_request_id number;
3805: l_appr_ovn per_appraisals.object_version_number%TYPE;
3806: l_appr_id per_appraisals.appraisal_id%TYPE;
3807: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
3808: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
3809: begin
3810: --
3811: -- Initialize logging
3812: --

Line 4345: UPDATE per_appraisals

4341: hr_utility.set_location('Before transfer out _for_person',107);
4342: fetch csr_find_appr_for_scorecard into l_appr_id,l_appr_ovn,l_appr_sys_status;
4343: exit when csr_find_appr_for_scorecard%notfound;
4344: IF l_appr_sys_status <> 'COMPLETED' THEN
4345: UPDATE per_appraisals
4346: SET appraisal_system_status = 'TRANSFER_OUT'
4347: WHERE appraisal_id =l_appr_id;
4348: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.
4349: FOR i in csr_get_appr_part(l_appr_id)

Line 5150: FROM per_appraisals pa

5146: ,pat.name APPRAISAL_TEMPLATE_NAME
5147: ,pa.appraisal_period_start_date
5148: ,pa.appraisal_period_end_date
5149: , count(*) COUNT
5150: FROM per_appraisals pa
5151: ,per_appraisal_templates pat
5152: WHERE pa.plan_id = p_plan_id
5153: AND pa.appraisal_template_id = pat.appraisal_template_id
5154: GROUP BY

Line 5254: FROM per_appraisals

5250: PROCEDURE delete_appraisals(p_plan_id IN NUMBER) IS
5251: CURSOR csr_appr(p_plan_id IN NUMBER) IS
5252: SELECT appraisal_id
5253: ,object_version_number
5254: FROM per_appraisals
5255: WHERE plan_id = p_plan_id;
5256: BEGIN
5257: log_message('Deleting Appraisals for the plan');
5258: FOR i IN csr_appr(p_plan_id)

Line 5338: TYPE tab_person_id IS TABLE OF per_appraisals.appraisee_person_id%TYPE INDEX BY binary_integer;

5334:
5335:
5336:
5337: l_plan_name per_perf_mgmt_plans.plan_name%type;
5338: TYPE tab_person_id IS TABLE OF per_appraisals.appraisee_person_id%TYPE INDEX BY binary_integer;
5339: person_ids tab_person_id;
5340: l_effective_date DATE;
5341: l_object_version_number number;
5342: l_status_code per_perf_mgmt_plans.status_code%TYPE;

Line 5823: FROM per_appraisals

5819: CURSOR csr_apprs_exist(p_plan_id IN NUMBER) IS
5820: SELECT 'Y'
5821: FROM dual
5822: WHERE EXISTS (SELECT 'x'
5823: FROM per_appraisals
5824: WHERE plan_id = p_plan_id);
5825: l_chk_exists VARCHAR2(1);
5826: --
5827: --

Line 5911: FROM per_appraisals pa

5907: ,pe.event_id
5908: ,pe.object_version_number EVENT_OVN
5909: ,ppr.performance_review_id
5910: ,ppr.object_version_number REVIEW_OVN
5911: FROM per_appraisals pa
5912: ,per_events pe
5913: ,per_performance_reviews ppr
5914: WHERE pa.appraisal_id = p_appraisal_id
5915: AND pa.event_id = pe.event_id

Line 6011: FROM per_appraisals pa

6007: appraisal_period_end_date
6008: ,to_char(appraisal_date,'DD-MON-YYYY') appraisal_date
6009: ,pa.status
6010: ,pa.assignment_id
6011: FROM per_appraisals pa
6012: ,per_people_f papf
6013: ,per_people_f papf1
6014: WHERE pa.appraisal_id = p_appraisal_id
6015: AND pa.plan_id = p_plan_id

Line 6023: l_person_id per_appraisals.appraisee_person_id%type;

6019: AND pa.appraisee_person_id = papf1.person_id
6020: AND p_effective_date BETWEEN papf1.effective_start_date AND
6021: papf1.effective_end_date;
6022: l_appraisal_dtls VARCHAR2(4000);
6023: l_person_id per_appraisals.appraisee_person_id%type;
6024: l_assignment_id per_appraisals.assignment_id%type;
6025: l_full_name per_people_f.full_name%type;
6026: BEGIN
6027: FOR i in g_selected_entities.FIRST .. g_selected_entities.LAST

Line 6024: l_assignment_id per_appraisals.assignment_id%type;

6020: AND p_effective_date BETWEEN papf1.effective_start_date AND
6021: papf1.effective_end_date;
6022: l_appraisal_dtls VARCHAR2(4000);
6023: l_person_id per_appraisals.appraisee_person_id%type;
6024: l_assignment_id per_appraisals.assignment_id%type;
6025: l_full_name per_people_f.full_name%type;
6026: BEGIN
6027: FOR i in g_selected_entities.FIRST .. g_selected_entities.LAST
6028: LOOP

Line 6044: UPDATE per_appraisals pa

6040: revert_appraisal_details(p_appraisal_id => g_selected_entities(i)
6041: ,p_plan_id => p_plan_id
6042: ,p_effective_date => p_effective_date);
6043: --
6044: UPDATE per_appraisals pa
6045: SET system_params = SUBSTR(system_params,1,instr(pa.system_params,'pItemKey=')-2),
6046: appraisal_system_status = 'ONGOING' ,
6047: event_id = NULL
6048: WHERE pa.appraisal_id = g_selected_entities(i);

Line 6102: FROM per_appraisals

6098: papf.effective_end_date;
6099: --
6100: CURSOR csr_appr_dtls(p_person_id NUMBER, p_plan_id NUMBER) IS
6101: SELECT appraisal_id,object_version_number
6102: FROM per_appraisals
6103: WHERE plan_id = p_plan_id
6104: AND appraisee_person_id = p_person_id;
6105: --
6106: l_sc_dtls VARCHAR2(500);