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 2591: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE

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
2592: )
2593: RETURN BOOLEAN
2594: IS
2595: l_resp_id NUMBER;

Line 2983: p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',

2979: p_appraisal_templ_id per_appraisal_templates.appraisal_template_id%TYPE,
2980: p_effective_date DATE,
2981: p_appraisal_start_date DATE,
2982: p_appraisal_end_date DATE,
2983: p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',
2984: p_type per_appraisals.TYPE%TYPE DEFAULT NULL,
2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,

Line 2984: p_type per_appraisals.TYPE%TYPE DEFAULT NULL,

2980: p_effective_date DATE,
2981: p_appraisal_start_date DATE,
2982: p_appraisal_end_date DATE,
2983: p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',
2984: p_type per_appraisals.TYPE%TYPE DEFAULT NULL,
2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,
2988: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE DEFAULT NULL,

Line 2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,

2981: p_appraisal_start_date DATE,
2982: p_appraisal_end_date DATE,
2983: p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',
2984: p_type per_appraisals.TYPE%TYPE DEFAULT NULL,
2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,
2988: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE DEFAULT NULL,
2989: p_status per_appraisals.status%TYPE DEFAULT NULL,

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

2982: p_appraisal_end_date DATE,
2983: p_appraisal_status per_appraisals.status%TYPE DEFAULT 'PLANNED',
2984: p_type per_appraisals.TYPE%TYPE DEFAULT NULL,
2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,
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,

Line 2988: p_next_appraisal_date per_appraisals.next_appraisal_date%TYPE DEFAULT NULL,

2984: p_type per_appraisals.TYPE%TYPE DEFAULT NULL,
2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,
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,

Line 2989: p_status per_appraisals.status%TYPE DEFAULT NULL,

2985: p_appraisal_date per_appraisals.appraisal_date%TYPE,
2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,
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

Line 2990: p_comments per_appraisals.comments%TYPE DEFAULT NULL,

2986: -- p_appraisal_system_status per_appraisals.appraisal_system_status%TYPE,
2987: p_plan_id NUMBER,
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: )

Line 2991: p_appraisee_access per_appraisals.appraisee_access%TYPE DEFAULT NULL,

2987: p_plan_id NUMBER,
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

Line 3009: CURSOR get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)

3005: effective_start_date
3006: FROM per_all_assignments_f
3007: WHERE assignment_id = p_assignment_id AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
3008:
3009: CURSOR get_appraisal_templ_info (p_appraisal_templ_id per_appraisals.appraisal_template_id%TYPE)
3010: IS
3011: SELECT appraisal_template_id, assessment_type_id, objective_asmnt_type_id, business_group_id
3012: FROM per_appraisal_templates
3013: WHERE appraisal_template_id = p_appraisal_templ_id;

Line 3049: l_appraisal_ovn per_appraisals.object_version_number%TYPE;

3045: l_scorecard_info scorecard_info;
3046: no_score_card_with_this_id EXCEPTION;
3047: l_assignment_info assignment_info;
3048: no_assignment_with_this_id EXCEPTION;
3049: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
3050: l_apprl_return_status VARCHAR2 (10) DEFAULT NULL;
3051: l_assess_comp_return_status VARCHAR2 (10) DEFAULT NULL;
3052: l_assess_obj_return_status VARCHAR2 (10) DEFAULT NULL;
3053: l_apprl_id per_appraisals.appraisal_id%TYPE DEFAULT NULL;

Line 3053: l_apprl_id per_appraisals.appraisal_id%TYPE DEFAULT NULL;

3049: l_appraisal_ovn per_appraisals.object_version_number%TYPE;
3050: l_apprl_return_status VARCHAR2 (10) DEFAULT NULL;
3051: l_assess_comp_return_status VARCHAR2 (10) DEFAULT NULL;
3052: l_assess_obj_return_status VARCHAR2 (10) DEFAULT NULL;
3053: l_apprl_id per_appraisals.appraisal_id%TYPE DEFAULT NULL;
3054: l_apprl_templ_info appraisal_templ_info;
3055: no_apprl_templ_with_this_id EXCEPTION;
3056: l_assessment_comp_id per_assessments.assessment_id%TYPE;
3057: l_assessment_obj_id per_assessments.assessment_id%TYPE;

Line 3759: CURSOR get_assessm_for_apprl (apprl_id per_appraisals.appraisal_id%TYPE)

3755: IS
3756: -- Declare local variables
3757: l_proc VARCHAR2 (72) := g_package || 'delete_appraisal_for_person ';
3758:
3759: CURSOR get_assessm_for_apprl (apprl_id per_appraisals.appraisal_id%TYPE)
3760: IS
3761: SELECT assessment_id, object_version_number
3762: FROM per_assessments
3763: WHERE appraisal_id = apprl_id;

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

4839: l_message_req VARCHAR (2000);
4840:
4841: --
4842: -- Cursor to get the Participants of an appraisal other than MA
4843: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
4844: IS
4845: SELECT participant_id, object_version_number, participation_type
4846: FROM per_participants
4847: WHERE participation_in_id = p_appraisal_id

Line 4848: AND participation_in_table = 'PER_APPRAISALS'

4844: IS
4845: SELECT participant_id, object_version_number, participation_type
4846: FROM per_participants
4847: WHERE participation_in_id = p_appraisal_id
4848: AND participation_in_table = 'PER_APPRAISALS'
4849: AND participation_in_column = 'APPRAISAL_ID'
4850: AND participation_type <> 'MAINAP'
4851: AND participation_status = 'OPEN';
4852:

Line 4855: plan_id per_appraisals.plan_id%TYPE,

4851: AND participation_status = 'OPEN';
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

Line 4884: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)

4880: SELECT objective_id, object_version_number
4881: FROM per_objectives
4882: WHERE scorecard_id = p_scorecard_id;
4883:
4884: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
4885: IS
4886: SELECT appraisal_id, object_version_number
4887: FROM per_appraisals
4888: WHERE plan_id = plan_id;

Line 4887: FROM per_appraisals

4883:
4884: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
4885: IS
4886: SELECT appraisal_id, object_version_number
4887: FROM per_appraisals
4888: WHERE plan_id = plan_id;
4889:
4890: CURSOR csr_find_appr_for_scorecard (
4891: p_plan_id per_appraisals.plan_id%TYPE,

Line 4891: p_plan_id per_appraisals.plan_id%TYPE,

4887: FROM per_appraisals
4888: WHERE plan_id = plan_id;
4889:
4890: CURSOR csr_find_appr_for_scorecard (
4891: p_plan_id per_appraisals.plan_id%TYPE,
4892: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
4893: )
4894: IS
4895: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status

Line 4896: FROM per_appraisals pa, per_personal_scorecards pps

4892: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
4893: )
4894: IS
4895: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status
4896: FROM per_appraisals pa, per_personal_scorecards pps
4897: WHERE pa.plan_id = p_plan_id AND appraisee_person_id = pps.person_id AND pps.scorecard_id = p_scorecard_id;
4898:
4899: -- cursor added
4900: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.

Line 4922: l_appr_ovn per_appraisals.object_version_number%TYPE;

4918: l_scorecard_status_code VARCHAR2 (30);
4919: l_process_date DATE;
4920: l_process_date_char VARCHAR2 (50);
4921: l_request_id NUMBER;
4922: l_appr_ovn per_appraisals.object_version_number%TYPE;
4923: l_appr_id per_appraisals.appraisal_id%TYPE;
4924: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
4925: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
4926: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

Line 4923: l_appr_id per_appraisals.appraisal_id%TYPE;

4919: l_process_date DATE;
4920: l_process_date_char VARCHAR2 (50);
4921: l_request_id NUMBER;
4922: l_appr_ovn per_appraisals.object_version_number%TYPE;
4923: l_appr_id per_appraisals.appraisal_id%TYPE;
4924: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
4925: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
4926: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
4927: l_person_name per_all_people_f.full_name%TYPE;

Line 4924: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;

4920: l_process_date_char VARCHAR2 (50);
4921: l_request_id NUMBER;
4922: l_appr_ovn per_appraisals.object_version_number%TYPE;
4923: l_appr_id per_appraisals.appraisal_id%TYPE;
4924: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
4925: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
4926: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
4927: l_person_name per_all_people_f.full_name%TYPE;
4928: BEGIN

Line 4925: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

4921: l_request_id NUMBER;
4922: l_appr_ovn per_appraisals.object_version_number%TYPE;
4923: l_appr_id per_appraisals.appraisal_id%TYPE;
4924: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
4925: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
4926: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
4927: l_person_name per_all_people_f.full_name%TYPE;
4928: BEGIN
4929: --

Line 5775: UPDATE per_appraisals

5771: EXIT WHEN csr_find_appr_for_scorecard%NOTFOUND;
5772:
5773: IF l_appr_sys_status NOT IN ('COMPLETED','APPRFEEDBACK')
5774: THEN
5775: UPDATE per_appraisals
5776: SET appraisal_system_status = 'TRANSFER_OUT'
5777: WHERE appraisal_id = l_appr_id;
5778:
5779: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.

Line 6855: FROM per_appraisals pa, per_appraisal_templates pat

6851: IS
6852: SELECT hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status) status,
6853: pat.NAME appraisal_template_name, pa.appraisal_period_start_date, pa.appraisal_period_end_date, COUNT (*)
6854: COUNT
6855: FROM per_appraisals pa, per_appraisal_templates pat
6856: WHERE pa.plan_id = p_plan_id AND pa.appraisal_template_id = pat.appraisal_template_id
6857: GROUP BY hr_general.decode_lookup ('APPRAISAL_SYSTEM_STATUS', appraisal_system_status),
6858: pat.NAME,
6859: pa.appraisal_period_start_date,

Line 6973: FROM per_appraisals

6969: IS
6970: CURSOR csr_appr (p_plan_id IN NUMBER)
6971: IS
6972: SELECT appraisal_id, object_version_number
6973: FROM per_appraisals
6974: WHERE plan_id = p_plan_id;
6975: BEGIN
6976: log_message ('Deleting Appraisals for the plan');
6977:

Line 7082: TYPE tab_person_id IS TABLE OF per_appraisals.appraisee_person_id%TYPE

7078: WHERE plan_id = p_plan_id;
7079:
7080: l_plan_name per_perf_mgmt_plans.plan_name%TYPE;
7081:
7082: TYPE tab_person_id IS TABLE OF per_appraisals.appraisee_person_id%TYPE
7083: INDEX BY BINARY_INTEGER;
7084:
7085: person_ids tab_person_id;
7086: l_effective_date DATE;

Line 7749: FROM per_appraisals

7745: IS
7746: SELECT 'Y'
7747: FROM DUAL
7748: WHERE EXISTS (SELECT 'x'
7749: FROM per_appraisals
7750: WHERE plan_id = p_plan_id);
7751:
7752: l_chk_exists VARCHAR2 (1);
7753:

Line 7868: FROM per_appraisals pa, per_events pe, per_performance_reviews ppr

7864: CURSOR csr_event_dtls (p_appraisal_id NUMBER)
7865: IS
7866: SELECT pa.appraisee_person_id, pe.event_id, pe.object_version_number event_ovn, ppr.performance_review_id,
7867: ppr.object_version_number review_ovn
7868: FROM per_appraisals pa, per_events pe, per_performance_reviews ppr
7869: WHERE pa.appraisal_id = p_appraisal_id AND pa.event_id = pe.event_id AND pe.event_id = ppr.event_id;
7870:
7871: l_appraisee_person_id NUMBER;
7872:

Line 7960: FROM per_appraisals pa, per_people_f papf, per_people_f papf1

7956: papf1.full_name "APPRAISEE_NAME",
7957: TO_CHAR (appraisal_period_start_date, 'DD-MON-YYYY') appraisal_period_start_date,
7958: TO_CHAR (appraisal_period_end_date, 'DD-MON-YYYY') appraisal_period_end_date,
7959: TO_CHAR (appraisal_date, 'DD-MON-YYYY') appraisal_date, pa.status, pa.assignment_id
7960: FROM per_appraisals pa, per_people_f papf, per_people_f papf1
7961: WHERE pa.appraisal_id = p_appraisal_id
7962: AND pa.plan_id = p_plan_id
7963: AND pa.main_appraiser_id = papf.person_id
7964: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date

Line 7969: l_person_id per_appraisals.appraisee_person_id%TYPE;

7965: AND pa.appraisee_person_id = papf1.person_id
7966: AND p_effective_date BETWEEN papf1.effective_start_date AND papf1.effective_end_date;
7967:
7968: l_appraisal_dtls VARCHAR2 (4000);
7969: l_person_id per_appraisals.appraisee_person_id%TYPE;
7970: l_assignment_id per_appraisals.assignment_id%TYPE;
7971: l_full_name per_people_f.full_name%TYPE;
7972: BEGIN
7973: FOR i IN g_selected_entities.FIRST .. g_selected_entities.LAST

Line 7970: l_assignment_id per_appraisals.assignment_id%TYPE;

7966: AND p_effective_date BETWEEN papf1.effective_start_date AND papf1.effective_end_date;
7967:
7968: l_appraisal_dtls VARCHAR2 (4000);
7969: l_person_id per_appraisals.appraisee_person_id%TYPE;
7970: l_assignment_id per_appraisals.assignment_id%TYPE;
7971: l_full_name per_people_f.full_name%TYPE;
7972: BEGIN
7973: FOR i IN g_selected_entities.FIRST .. g_selected_entities.LAST
7974: LOOP

Line 7997: UPDATE per_appraisals pa

7993: p_effective_date => p_effective_date
7994: );
7995:
7996: --
7997: UPDATE per_appraisals pa
7998: SET system_params = SUBSTR (system_params, 1, INSTR (pa.system_params, 'pItemKey=') - 2),
7999: appraisal_system_status = 'ONGOING',
8000: event_id = NULL
8001: WHERE pa.appraisal_id = g_selected_entities (i);

Line 8057: FROM per_appraisals

8053: --
8054: CURSOR csr_appr_dtls (p_person_id NUMBER, p_plan_id NUMBER)
8055: IS
8056: SELECT appraisal_id, object_version_number
8057: FROM per_appraisals
8058: WHERE plan_id = p_plan_id AND appraisee_person_id = p_person_id;
8059: --15902260
8060: CURSOR csr_valid_plan (p_plan_id IN NUMBER)
8061: IS

Line 8869: FROM per_appraisals

8865:
8866: CURSOR csr_target_appr (p_plan_id IN NUMBER, p_person_id IN NUMBER)
8867: IS
8868: SELECT appraisal_id
8869: FROM per_appraisals
8870: WHERE plan_id = p_plan_id AND appraisee_person_id = p_person_id;
8871:
8872: l_target_appr_id NUMBER (15);
8873: CURSOR csr_find_appr_for_scorecard (

Line 8874: p_plan_id per_appraisals.plan_id%TYPE,

8870: WHERE plan_id = p_plan_id AND appraisee_person_id = p_person_id;
8871:
8872: l_target_appr_id NUMBER (15);
8873: CURSOR csr_find_appr_for_scorecard (
8874: p_plan_id per_appraisals.plan_id%TYPE,
8875: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
8876: )
8877: IS
8878: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status

Line 8879: FROM per_appraisals pa, per_personal_scorecards pps

8875: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
8876: )
8877: IS
8878: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status
8879: FROM per_appraisals pa, per_personal_scorecards pps
8880: WHERE pa.plan_id = p_plan_id AND appraisee_person_id = pps.person_id AND pps.scorecard_id = p_scorecard_id;
8881: -- Cursor to get the Participants of an appraisal other than MA
8882: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
8883: IS

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

8878: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status
8879: FROM per_appraisals pa, per_personal_scorecards pps
8880: WHERE pa.plan_id = p_plan_id AND appraisee_person_id = pps.person_id AND pps.scorecard_id = p_scorecard_id;
8881: -- Cursor to get the Participants of an appraisal other than MA
8882: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
8883: IS
8884: SELECT participant_id, object_version_number, participation_type
8885: FROM per_participants
8886: WHERE participation_in_id = p_appraisal_id

Line 8887: AND participation_in_table = 'PER_APPRAISALS'

8883: IS
8884: SELECT participant_id, object_version_number, participation_type
8885: FROM per_participants
8886: WHERE participation_in_id = p_appraisal_id
8887: AND participation_in_table = 'PER_APPRAISALS'
8888: AND participation_in_column = 'APPRAISAL_ID'
8889: AND participation_type <> 'MAINAP'
8890: AND participation_status = 'OPEN';
8891: CURSOR csr_chek_appr_exist (p_plan_id IN NUMBER) IS

Line 8895: FROM per_appraisals

8891: CURSOR csr_chek_appr_exist (p_plan_id IN NUMBER) IS
8892: SELECT 'Y'
8893: FROM dual
8894: WHERE EXISTS (SELECT 'X'
8895: FROM per_appraisals
8896: WHERE plan_id = p_plan_id
8897: AND appraisal_system_status <> 'DELETED');
8898:
8899: l_dummy BOOLEAN;

Line 8900: l_appr_ovn per_appraisals.object_version_number%TYPE;

8896: WHERE plan_id = p_plan_id
8897: AND appraisal_system_status <> 'DELETED');
8898:
8899: l_dummy BOOLEAN;
8900: l_appr_ovn per_appraisals.object_version_number%TYPE;
8901: l_appr_id per_appraisals.appraisal_id%TYPE;
8902: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
8903: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
8904: --bug14046867

Line 8901: l_appr_id per_appraisals.appraisal_id%TYPE;

8897: AND appraisal_system_status <> 'DELETED');
8898:
8899: l_dummy BOOLEAN;
8900: l_appr_ovn per_appraisals.object_version_number%TYPE;
8901: l_appr_id per_appraisals.appraisal_id%TYPE;
8902: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
8903: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
8904: --bug14046867
8905: l_person_id per_personal_scorecards.person_id%TYPE;

Line 8902: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;

8898:
8899: l_dummy BOOLEAN;
8900: l_appr_ovn per_appraisals.object_version_number%TYPE;
8901: l_appr_id per_appraisals.appraisal_id%TYPE;
8902: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
8903: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
8904: --bug14046867
8905: l_person_id per_personal_scorecards.person_id%TYPE;
8906: l_src_supervisor_id per_personal_scorecards.supervisor_id%TYPE;

Line 8903: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

8899: l_dummy BOOLEAN;
8900: l_appr_ovn per_appraisals.object_version_number%TYPE;
8901: l_appr_id per_appraisals.appraisal_id%TYPE;
8902: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
8903: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
8904: --bug14046867
8905: l_person_id per_personal_scorecards.person_id%TYPE;
8906: l_src_supervisor_id per_personal_scorecards.supervisor_id%TYPE;
8907: l_tgt_supervisor_id per_personal_scorecards.supervisor_id%TYPE;

Line 9059: UPDATE per_appraisals

9055: EXIT WHEN csr_find_appr_for_scorecard%NOTFOUND;
9056:
9057: IF l_appr_sys_status NOT IN ('COMPLETED','APPRFEEDBACK')
9058: THEN
9059: UPDATE per_appraisals
9060: SET appraisal_system_status = 'TRANSFER_OUT'
9061: WHERE appraisal_id = l_appr_id;
9062:
9063: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.

Line 10424: p_plan_id per_appraisals.plan_id%TYPE,

10420: SELECT full_name
10421: FROM per_all_people_f ppf
10422: WHERE ppf.person_id = p_person_id AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
10423: CURSOR csr_find_appr_for_scorecard (
10424: p_plan_id per_appraisals.plan_id%TYPE,
10425: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
10426: )
10427: IS
10428: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status

Line 10429: FROM per_appraisals pa, per_personal_scorecards pps

10425: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
10426: )
10427: IS
10428: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status
10429: FROM per_appraisals pa, per_personal_scorecards pps
10430: WHERE pa.plan_id = p_plan_id AND appraisee_person_id = pps.person_id AND pps.scorecard_id = p_scorecard_id;
10431: -- Cursor to get the Participants of an appraisal other than MA
10432: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
10433: IS

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

10428: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status
10429: FROM per_appraisals pa, per_personal_scorecards pps
10430: WHERE pa.plan_id = p_plan_id AND appraisee_person_id = pps.person_id AND pps.scorecard_id = p_scorecard_id;
10431: -- Cursor to get the Participants of an appraisal other than MA
10432: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
10433: IS
10434: SELECT participant_id, object_version_number, participation_type
10435: FROM per_participants
10436: WHERE participation_in_id = p_appraisal_id

Line 10437: AND participation_in_table = 'PER_APPRAISALS'

10433: IS
10434: SELECT participant_id, object_version_number, participation_type
10435: FROM per_participants
10436: WHERE participation_in_id = p_appraisal_id
10437: AND participation_in_table = 'PER_APPRAISALS'
10438: AND participation_in_column = 'APPRAISAL_ID'
10439: AND participation_type <> 'MAINAP'
10440: AND participation_status = 'OPEN';
10441:

Line 10443: l_appr_ovn per_appraisals.object_version_number%TYPE;

10439: AND participation_type <> 'MAINAP'
10440: AND participation_status = 'OPEN';
10441:
10442: l_dummy BOOLEAN;
10443: l_appr_ovn per_appraisals.object_version_number%TYPE;
10444: l_appr_id per_appraisals.appraisal_id%TYPE;
10445: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10446: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10447: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

Line 10444: l_appr_id per_appraisals.appraisal_id%TYPE;

10440: AND participation_status = 'OPEN';
10441:
10442: l_dummy BOOLEAN;
10443: l_appr_ovn per_appraisals.object_version_number%TYPE;
10444: l_appr_id per_appraisals.appraisal_id%TYPE;
10445: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10446: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10447: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10448: l_person_name per_all_people_f.full_name%TYPE;

Line 10445: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;

10441:
10442: l_dummy BOOLEAN;
10443: l_appr_ovn per_appraisals.object_version_number%TYPE;
10444: l_appr_id per_appraisals.appraisal_id%TYPE;
10445: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10446: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10447: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10448: l_person_name per_all_people_f.full_name%TYPE;
10449: l_qual_pop_index BINARY_INTEGER;

Line 10446: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

10442: l_dummy BOOLEAN;
10443: l_appr_ovn per_appraisals.object_version_number%TYPE;
10444: l_appr_id per_appraisals.appraisal_id%TYPE;
10445: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10446: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10447: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10448: l_person_name per_all_people_f.full_name%TYPE;
10449: l_qual_pop_index BINARY_INTEGER;
10450: l_curr_sc_pop_index BINARY_INTEGER;

Line 10771: UPDATE per_appraisals

10767: EXIT WHEN csr_find_appr_for_scorecard%NOTFOUND;
10768:
10769: IF l_appr_sys_status NOT IN ('COMPLETED','APPRFEEDBACK')
10770: THEN
10771: UPDATE per_appraisals
10772: SET appraisal_system_status = 'TRANSFER_OUT'
10773: WHERE appraisal_id = l_appr_id;
10774:
10775: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.

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

10885: l_message_req VARCHAR (2000);
10886:
10887: --
10888: -- Cursor to get the Participants of an appraisal other than MA
10889: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
10890: IS
10891: SELECT participant_id, object_version_number, participation_type
10892: FROM per_participants
10893: WHERE participation_in_id = p_appraisal_id

Line 10894: AND participation_in_table = 'PER_APPRAISALS'

10890: IS
10891: SELECT participant_id, object_version_number, participation_type
10892: FROM per_participants
10893: WHERE participation_in_id = p_appraisal_id
10894: AND participation_in_table = 'PER_APPRAISALS'
10895: AND participation_in_column = 'APPRAISAL_ID'
10896: AND participation_type <> 'MAINAP'
10897: AND participation_status = 'OPEN';
10898:

Line 10913: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)

10909: SELECT objective_id, object_version_number
10910: FROM per_objectives
10911: WHERE scorecard_id = p_scorecard_id;
10912:
10913: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
10914: IS
10915: SELECT appraisal_id, object_version_number
10916: FROM per_appraisals
10917: WHERE plan_id = plan_id;

Line 10916: FROM per_appraisals

10912:
10913: CURSOR csr_plan_appraisals (plan_id per_appraisals.plan_id%TYPE)
10914: IS
10915: SELECT appraisal_id, object_version_number
10916: FROM per_appraisals
10917: WHERE plan_id = plan_id;
10918:
10919: CURSOR csr_find_appr_for_scorecard (
10920: p_plan_id per_appraisals.plan_id%TYPE,

Line 10920: p_plan_id per_appraisals.plan_id%TYPE,

10916: FROM per_appraisals
10917: WHERE plan_id = plan_id;
10918:
10919: CURSOR csr_find_appr_for_scorecard (
10920: p_plan_id per_appraisals.plan_id%TYPE,
10921: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
10922: )
10923: IS
10924: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status

Line 10925: FROM per_appraisals pa, per_personal_scorecards pps

10921: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE
10922: )
10923: IS
10924: SELECT pa.appraisal_id, pa.object_version_number, pa.appraisal_system_status
10925: FROM per_appraisals pa, per_personal_scorecards pps
10926: WHERE pa.plan_id = p_plan_id AND appraisee_person_id = pps.person_id AND pps.scorecard_id = p_scorecard_id;
10927:
10928: -- cursor added
10929: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.

Line 10951: l_appr_ovn per_appraisals.object_version_number%TYPE;

10947: l_scorecard_status_code VARCHAR2 (30);
10948: l_process_date DATE;
10949: l_process_date_char VARCHAR2 (50);
10950: l_request_id NUMBER;
10951: l_appr_ovn per_appraisals.object_version_number%TYPE;
10952: l_appr_id per_appraisals.appraisal_id%TYPE;
10953: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10954: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10955: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

Line 10952: l_appr_id per_appraisals.appraisal_id%TYPE;

10948: l_process_date DATE;
10949: l_process_date_char VARCHAR2 (50);
10950: l_request_id NUMBER;
10951: l_appr_ovn per_appraisals.object_version_number%TYPE;
10952: l_appr_id per_appraisals.appraisal_id%TYPE;
10953: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10954: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10955: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10956: l_person_name per_all_people_f.full_name%TYPE;

Line 10953: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;

10949: l_process_date_char VARCHAR2 (50);
10950: l_request_id NUMBER;
10951: l_appr_ovn per_appraisals.object_version_number%TYPE;
10952: l_appr_id per_appraisals.appraisal_id%TYPE;
10953: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10954: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10955: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10956: l_person_name per_all_people_f.full_name%TYPE;
10957: l_task_codes VARCHAR2 (200);

Line 10954: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;

10950: l_request_id NUMBER;
10951: l_appr_ovn per_appraisals.object_version_number%TYPE;
10952: l_appr_id per_appraisals.appraisal_id%TYPE;
10953: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10954: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10955: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10956: l_person_name per_all_people_f.full_name%TYPE;
10957: l_task_codes VARCHAR2 (200);
10958: t_task_codes DBMS_UTILITY.lname_array;