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_PERSONAL_SCORECARDS

Line 53: assignment_id per_personal_scorecards.assignment_id%TYPE,

49: g_qual_pop_tbl g_qual_pop_t;
50:
51: -- Used for populating existing scorecard population
52: TYPE g_curr_sc_pop_r IS RECORD (
53: assignment_id per_personal_scorecards.assignment_id%TYPE,
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: object_version_number per_personal_scorecards.object_version_number%TYPE,
56: status_code per_personal_scorecards.status_code%TYPE
57: );

Line 54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,

50:
51: -- Used for populating existing scorecard population
52: TYPE g_curr_sc_pop_r IS RECORD (
53: assignment_id per_personal_scorecards.assignment_id%TYPE,
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: object_version_number per_personal_scorecards.object_version_number%TYPE,
56: status_code per_personal_scorecards.status_code%TYPE
57: );
58:

Line 55: object_version_number per_personal_scorecards.object_version_number%TYPE,

51: -- Used for populating existing scorecard population
52: TYPE g_curr_sc_pop_r IS RECORD (
53: assignment_id per_personal_scorecards.assignment_id%TYPE,
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: object_version_number per_personal_scorecards.object_version_number%TYPE,
56: status_code per_personal_scorecards.status_code%TYPE
57: );
58:
59: TYPE g_curr_sc_pop_t IS TABLE OF g_curr_sc_pop_r

Line 56: status_code per_personal_scorecards.status_code%TYPE

52: TYPE g_curr_sc_pop_r IS RECORD (
53: assignment_id per_personal_scorecards.assignment_id%TYPE,
54: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
55: object_version_number per_personal_scorecards.object_version_number%TYPE,
56: status_code per_personal_scorecards.status_code%TYPE
57: );
58:
59: TYPE g_curr_sc_pop_t IS TABLE OF g_curr_sc_pop_r
60: INDEX BY BINARY_INTEGER;

Line 135: scorecard_id per_personal_scorecards.scorecard_id%TYPE,

131: g_fetched_plan_member_index NUMBER;
132:
133: --
134: TYPE scorecard_info IS RECORD (
135: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
136: assignment_id per_personal_scorecards.assignment_id%TYPE,
137: person_id per_personal_scorecards.person_id%TYPE,
138: scorecard_name per_personal_scorecards.scorecard_name%TYPE
139: );

Line 136: assignment_id per_personal_scorecards.assignment_id%TYPE,

132:
133: --
134: TYPE scorecard_info IS RECORD (
135: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
136: assignment_id per_personal_scorecards.assignment_id%TYPE,
137: person_id per_personal_scorecards.person_id%TYPE,
138: scorecard_name per_personal_scorecards.scorecard_name%TYPE
139: );
140:

Line 137: person_id per_personal_scorecards.person_id%TYPE,

133: --
134: TYPE scorecard_info IS RECORD (
135: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
136: assignment_id per_personal_scorecards.assignment_id%TYPE,
137: person_id per_personal_scorecards.person_id%TYPE,
138: scorecard_name per_personal_scorecards.scorecard_name%TYPE
139: );
140:
141: TYPE assignment_info IS RECORD (

Line 138: scorecard_name per_personal_scorecards.scorecard_name%TYPE

134: TYPE scorecard_info IS RECORD (
135: scorecard_id per_personal_scorecards.scorecard_id%TYPE,
136: assignment_id per_personal_scorecards.assignment_id%TYPE,
137: person_id per_personal_scorecards.person_id%TYPE,
138: scorecard_name per_personal_scorecards.scorecard_name%TYPE
139: );
140:
141: TYPE assignment_info IS RECORD (
142: assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 1204: FROM per_personal_scorecards

1200: -- Current Plan population
1201: CURSOR csr_curr_plan_pop
1202: IS
1203: SELECT assignment_id, scorecard_id, object_version_number, status_code
1204: FROM per_personal_scorecards
1205: WHERE creator_type = 'AUTO' AND plan_id = p_plan_id AND status_code <> 'TRANSFER_OUT';
1206: --
1207: BEGIN
1208: --

Line 2978: p_score_card_id per_personal_scorecards.scorecard_id%TYPE,

2974: --
2975: -- {End Of Comments}
2976: -- ----------------------------------------------------------------------------
2977: PROCEDURE create_appraisal_for_person (
2978: p_score_card_id per_personal_scorecards.scorecard_id%TYPE,
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,

Line 2996: CURSOR get_scorecard_info (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)

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)
2997: IS
2998: SELECT scorecard_id, assignment_id, person_id, scorecard_name
2999: FROM per_personal_scorecards
3000: WHERE scorecard_id = p_scorecard_id;

Line 2999: FROM per_personal_scorecards

2995: IS
2996: CURSOR get_scorecard_info (p_scorecard_id per_personal_scorecards.scorecard_id%TYPE)
2997: IS
2998: SELECT scorecard_id, assignment_id, person_id, scorecard_name
2999: FROM per_personal_scorecards
3000: WHERE scorecard_id = p_scorecard_id;
3001:
3002: CURSOR get_assignment_info (p_assignment_id per_all_assignments_f.assignment_id%TYPE)
3003: IS

Line 4429: FROM per_personal_scorecards

4425: IS
4426: SELECT 'Y'
4427: FROM DUAL
4428: WHERE EXISTS (SELECT 'X'
4429: FROM per_personal_scorecards
4430: WHERE plan_id = p_plan_id AND assignment_id = p_assignment_id);
4431: --
4432: BEGIN
4433: --

Line 4822: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;

4818: l_object_version_number NUMBER;
4819: l_status_code per_perf_mgmt_plans.status_code%TYPE;
4820: l_dummy BOOLEAN;
4821: --
4822: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
4823: --
4824: l_message_count NUMBER := 0;
4825: l_message VARCHAR2 (256);
4826: l_qual_pop_index BINARY_INTEGER;

Line 4892: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE

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
4896: FROM per_appraisals pa, per_personal_scorecards pps

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 5071: 'PER_PERSONAL_SCORECARDS';

5067: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';
5069: -- Processing
5070: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).transaction_ref_table :=
5071: 'PER_PERSONAL_SCORECARDS';
5072: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';
5073: -- Default handling cases of plan republish
5074: END IF;
5075:

Line 6525: FROM per_objectives obj, per_personal_scorecards psc

6521: --
6522: CURSOR past_obj
6523: IS
6524: SELECT obj.*
6525: FROM per_objectives obj, per_personal_scorecards psc
6526: WHERE psc.plan_id = p_prev_plan_id
6527: AND psc.assignment_id = p_assignemnt_id
6528: AND psc.scorecard_id = obj.scorecard_id
6529: AND obj.achievement_date IS NULL

Line 6533: FROM per_personal_scorecards psc1, per_objectives pobj1

6529: AND obj.achievement_date IS NULL
6530: AND obj.appraisal_id IS NULL
6531: AND NOT EXISTS (
6532: SELECT 'X'
6533: FROM per_personal_scorecards psc1, per_objectives pobj1
6534: WHERE psc1.plan_id = p_curr_plan_id
6535: AND psc1.assignment_id = psc.assignment_id
6536: AND psc1.scorecard_id = pobj1.scorecard_id
6537: AND pobj1.copied_from_objective_id = obj.objective_id);

Line 6844: FROM per_personal_scorecards

6840: IS
6841: CURSOR csr_sc_summary (p_plan_id IN NUMBER)
6842: IS
6843: SELECT hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code) status, COUNT (*) COUNT
6844: FROM per_personal_scorecards
6845: WHERE plan_id = p_plan_id
6846: GROUP BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code)
6847: ORDER BY hr_general.decode_lookup ('HR_WPM_SCORECARD_STATUS', status_code);
6848:

Line 6914: FROM per_personal_scorecards

6910: IS
6911: CURSOR csr_sc_ids (p_plan_id IN NUMBER)
6912: IS
6913: SELECT scorecard_id
6914: FROM per_personal_scorecards
6915: WHERE plan_id = p_plan_id;
6916:
6917: TYPE t_sc_ids IS TABLE OF NUMBER
6918: INDEX BY BINARY_INTEGER;

Line 6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');

6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id
6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)
6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
6939: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6940: DELETE FROM hr_api_transactions
6941: WHERE transaction_ref_id = l_sc_ids (i) AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6942: -- Delete all score card objectives

Line 6941: WHERE transaction_ref_id = l_sc_ids (i) AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';

6937: WHERE trn.transaction_ref_id = l_sc_ids (i)
6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
6939: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6940: DELETE FROM hr_api_transactions
6941: WHERE transaction_ref_id = l_sc_ids (i) AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6942: -- Delete all score card objectives
6943: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6944: DELETE FROM per_objectives
6945: WHERE scorecard_id = l_sc_ids (i);

Line 6948: DELETE FROM per_personal_scorecards

6944: DELETE FROM per_objectives
6945: WHERE scorecard_id = l_sc_ids (i);
6946: -- Delete all score cards now
6947: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6948: DELETE FROM per_personal_scorecards
6949: WHERE scorecard_id = l_sc_ids (i);
6950: EXIT WHEN csr_sc_ids%NOTFOUND;
6951: END LOOP;
6952:

Line 7066: FROM per_personal_scorecards

7062: IS
7063: SELECT 'Y'
7064: FROM DUAL
7065: WHERE EXISTS (SELECT NULL
7066: FROM per_personal_scorecards
7067: WHERE plan_id = p_plan_id);
7068:
7069: l_sc_rec VARCHAR2 (1);
7070:

Line 7077: FROM per_personal_scorecards

7073: --psugumar 7294077
7074: CURSOR csr_person_ids (p_plan_id IN NUMBER)
7075: IS
7076: SELECT person_id
7077: FROM per_personal_scorecards
7078: WHERE plan_id = p_plan_id;
7079:
7080: l_plan_name per_perf_mgmt_plans.plan_name%TYPE;
7081:

Line 7759: FROM per_personal_scorecards

7755: --
7756: CURSOR csr_asg_enrolled (p_assignment_id IN NUMBER, p_plan_id IN NUMBER)
7757: IS
7758: SELECT 'Y'
7759: FROM per_personal_scorecards
7760: WHERE plan_id = p_plan_id AND assignment_id = p_assignment_id AND status_code <> 'TRANSFER_OUT';
7761:
7762: l_asg_already_enrolled VARCHAR2 (1);
7763: l_person_id NUMBER;

Line 7891: FROM per_personal_scorecards sc

7887: --
7888: CURSOR csr_sc_id (p_appraisee_person_id NUMBER, p_plan_id NUMBER)
7889: IS
7890: SELECT scorecard_id
7891: FROM per_personal_scorecards sc
7892: WHERE person_id = p_appraisee_person_id AND plan_id = p_plan_id;
7893:
7894: l_sc_id NUMBER;
7895: -- Variables for IN/OUT parameters

Line 8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');

8028: WHERE step.transaction_id IN (
8029: SELECT trn.transaction_id
8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id
8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
8033:
8034: DELETE FROM hr_api_transactions
8035: WHERE transaction_ref_id = p_scorecard_id AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
8036:

Line 8035: WHERE transaction_ref_id = p_scorecard_id AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';

8031: WHERE trn.transaction_ref_id = p_scorecard_id
8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
8033:
8034: DELETE FROM hr_api_transactions
8035: WHERE transaction_ref_id = p_scorecard_id AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
8036:
8037: --
8038: DELETE FROM per_objectives
8039: WHERE scorecard_id = p_scorecard_id;

Line 8047: FROM per_personal_scorecards pc, per_people_f papf

8043: IS
8044: CURSOR csr_sc_dtls (p_sc_id IN NUMBER, p_plan_id IN NUMBER, p_effective_date IN DATE)
8045: IS
8046: SELECT pc.scorecard_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code
8047: FROM per_personal_scorecards pc, per_people_f papf
8048: WHERE pc.scorecard_id = p_sc_id
8049: AND pc.plan_id = p_plan_id
8050: AND pc.person_id = papf.person_id
8051: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date;

Line 8070: l_person_id per_personal_scorecards.person_id%TYPE;

8066: l_plan_rec csr_valid_plan%ROWTYPE;
8067:
8068: --
8069: l_sc_dtls VARCHAR2 (500);
8070: l_person_id per_personal_scorecards.person_id%TYPE;
8071: BEGIN
8072: FOR i IN g_selected_entities.FIRST .. g_selected_entities.LAST
8073: LOOP
8074: BEGIN

Line 8083: DELETE per_personal_scorecards

8079: -- no need to remove score card details
8080: remove_scorecard_details (g_selected_entities (i));
8081:
8082: -- UPdate the status of score card to DELETED
8083: DELETE per_personal_scorecards
8084: WHERE scorecard_id = g_selected_entities (i);
8085:
8086: --
8087: FOR k IN csr_appr_dtls (j.person_id, p_plan_id)

Line 8127: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

8123: CURSOR csr_sc_dtls (p_sc_id IN NUMBER, p_plan_id IN NUMBER, p_effective_date IN DATE)
8124: IS
8125: SELECT pc.scorecard_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code, papf.business_group_id,
8126: paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id, paaf.supervisor_id -- Bug7567079
8127: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
8128: WHERE pc.scorecard_id = p_sc_id
8129: AND pc.plan_id = p_plan_id
8130: AND pc.assignment_id = paaf.assignment_id
8131: AND pc.person_id = papf.person_id

Line 8187: UPDATE per_personal_scorecards

8183:
8184: --ELSE
8185: -- l_scorecard_status_code := 'MGR';
8186: --END IF;
8187: UPDATE per_personal_scorecards
8188: SET status_code = l_scorecard_status_code
8189: WHERE scorecard_id = g_selected_entities (i);
8190:
8191: --l_sup_id := get_manager_id(j.person_id);

Line 8217: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

8213: CURSOR csr_sc_dtls (p_sc_id IN NUMBER, p_plan_id IN NUMBER, p_effective_date IN DATE)
8214: IS
8215: SELECT pc.scorecard_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code, papf.business_group_id,
8216: paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id, paaf.supervisor_id -- Bug7567079
8217: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
8218: WHERE pc.scorecard_id = p_sc_id
8219: AND pc.plan_id = p_plan_id
8220: AND pc.assignment_id = paaf.assignment_id
8221: AND pc.person_id = papf.person_id

Line 8374: UPDATE per_personal_scorecards

8370: ELSE
8371: l_scorecard_status_code := 'NOT_STARTED_WITH_WKR';
8372: END IF;
8373:
8374: UPDATE per_personal_scorecards
8375: SET status_code = l_scorecard_status_code
8376: WHERE scorecard_id = l_scorecard_id;
8377:
8378: --Bug7567079 l_sup_id := get_manager_id(l_sc_rec.person_id);

Line 8410: FROM per_personal_scorecards pps, per_assignments_f paf

8406: IS
8407: SELECT pps.scorecard_id, pps.person_id, pps.assignment_id, NVL (pps.supervisor_id, paf.supervisor_id) supervisor_id,
8408: NVL (pps.supervisor_assignment_id, paf.supervisor_assignment_id) supervisor_assignment_id,
8409: pps.object_version_number, hr_general.decode_person_name (pps.person_id) worker_name
8410: FROM per_personal_scorecards pps, per_assignments_f paf
8411: WHERE pps.plan_id = p_plan_id
8412: AND pps.assignment_id = paf.assignment_id
8413: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
8414:

Line 8617: UPDATE per_personal_scorecards

8613: log_message ('Assignment :' || l_asg_index || ' exists in the current and proposed hierarchy.');
8614: ELSE
8615: log_message ('Assignment :' || l_asg_index || ' does not exists in the proposed hierarchy. Transferring out.');
8616:
8617: UPDATE per_personal_scorecards
8618: SET status_code = 'TRANSFER_OUT'
8619: WHERE scorecard_id = l_curr_pop (l_asg_index).scorecard_id;
8620:
8621: send_message_notification (p_person_id => l_curr_pop (l_asg_index).person_id,

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);

Line 8834: FROM per_personal_scorecards

8830:
8831: CURSOR csr_sc_dtls (p_sc_id IN NUMBER)
8832: IS
8833: SELECT *
8834: FROM per_personal_scorecards
8835: WHERE scorecard_id = p_sc_id;
8836:
8837: l_sc_rec csr_sc_dtls%ROWTYPE;
8838:

Line 8843: FROM per_personal_scorecards

8839: --bug14046867 ... cursor for target supervisor_id and person full name.
8840: CURSOR csr_target_sup ( l_target_sc_id IN NUMBER)
8841: IS
8842: SELECT supervisor_id
8843: FROM per_personal_scorecards
8844: WHERE scorecard_id = l_target_sc_id;
8845:
8846: l_target_sup_id NUMBER;
8847:

Line 8851: FROM per_all_people_f ppf, per_personal_scorecards pps

8847:
8848: CURSOR csr_person_full_name (p_sc_id IN NUMBER)
8849: IS
8850: SELECT hr_person_name.get_list_name(ppf.global_name, ppf.local_name) full_name
8851: FROM per_all_people_f ppf, per_personal_scorecards pps
8852: WHERE ppf.person_id = pps.person_id
8853: AND pps.scorecard_id = p_sc_id
8854: AND TRUNC(SYSDATE) between ppf.effective_start_date and ppf.effective_end_date;
8855:

Line 8861: FROM per_personal_scorecards

8857: --bug14046867
8858: CURSOR csr_target_sc (p_assignment_id IN NUMBER, p_plan_id IN NUMBER)
8859: IS
8860: SELECT scorecard_id
8861: FROM per_personal_scorecards
8862: WHERE plan_id = p_plan_id AND assignment_id = p_assignment_id;
8863:
8864: l_target_sc_id NUMBER;
8865:

Line 8875: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE

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
8879: FROM per_appraisals pa, per_personal_scorecards pps

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 8905: l_person_id per_personal_scorecards.person_id%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;
8908: --bug14046867
8909:

Line 8906: l_src_supervisor_id per_personal_scorecards.supervisor_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;
8908: --bug14046867
8909:
8910: BEGIN

Line 8907: l_tgt_supervisor_id per_personal_scorecards.supervisor_id%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;
8908: --bug14046867
8909:
8910: BEGIN
8911: hr_utility.set_location ('Entering:' || l_proc, 10);

Line 9623: FROM per_personal_scorecards

9619: IS
9620: SELECT 'Y'
9621: FROM DUAL
9622: WHERE EXISTS (SELECT 'X'
9623: FROM per_personal_scorecards
9624: WHERE plan_id = p_plan_id AND assignment_id = p_assignment_id);
9625: BEGIN
9626: --
9627: IF (funcmode = 'RUN')

Line 9720: FROM per_personal_scorecards

9716: IS
9717: SELECT 'Y'
9718: FROM DUAL
9719: WHERE EXISTS (SELECT 'x'
9720: FROM per_personal_scorecards
9721: WHERE plan_id = p_plan_id);
9722:
9723: CURSOR csr_get_plan_rec
9724: IS

Line 9860: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

9856: IS
9857: SELECT pc.scorecard_id, pc.person_id, pc.object_version_number, papf.full_name scorecard_owner, pc.status_code,
9858: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
9859: paaf.supervisor_id -- Bug7567079
9860: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
9861: WHERE pc.scorecard_id = p_sc_id
9862: AND pc.plan_id = p_plan_id
9863: AND pc.assignment_id = paaf.assignment_id
9864: AND pc.person_id = papf.person_id

Line 10077: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

10073: IS
10074: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10075: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10076: paaf.supervisor_id -- Bug7567079
10077: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10078: WHERE pc.scorecard_id = p_sc_id
10079: AND pc.assignment_id = paaf.assignment_id
10080: AND pc.person_id = papf.person_id
10081: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 10139: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

10135: IS
10136: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10137: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10138: paaf.supervisor_id -- Bug7567079
10139: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10140: WHERE pc.scorecard_id = p_sc_id
10141: AND pc.assignment_id = paaf.assignment_id
10142: AND pc.person_id = papf.person_id
10143: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 10201: UPDATE per_personal_scorecards

10197: END IF;
10198:
10199: log_message ('Updating sc to NOT_STARTED:' || g_curr_sc_pop_tbl (l_curr_sc_pop_index).scorecard_id);
10200:
10201: UPDATE per_personal_scorecards
10202: SET status_code = l_scorecard_status_code
10203: WHERE scorecard_id = g_curr_sc_pop_tbl (l_curr_sc_pop_index).scorecard_id;
10204: END IF; --- reset scorecard status
10205:

Line 10239: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

10235: IS
10236: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10237: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10238: paaf.supervisor_id -- Bug7567079
10239: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10240: WHERE pc.scorecard_id = p_sc_id
10241: AND pc.assignment_id = paaf.assignment_id
10242: AND pc.person_id = papf.person_id
10243: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 10311: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf

10307: IS
10308: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10309: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10310: paaf.supervisor_id -- Bug7567079
10311: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10312: WHERE pc.scorecard_id = p_sc_id
10313: AND pc.assignment_id = paaf.assignment_id
10314: AND pc.person_id = papf.person_id
10315: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 10326: FROM per_personal_scorecards sc, per_assignments_f paf

10322: IS
10323: CURSOR csr_curr_sup (p_sc_id IN NUMBER)
10324: IS
10325: SELECT paf.supervisor_id, paf.supervisor_assignment_id, sc.object_version_number
10326: FROM per_personal_scorecards sc, per_assignments_f paf
10327: WHERE sc.scorecard_id = p_sc_id
10328: AND sc.assignment_id = paf.assignment_id
10329: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date;
10330:

Line 10425: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE

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
10429: FROM per_appraisals pa, per_personal_scorecards pps

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 10868: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;

10864: l_object_version_number NUMBER;
10865: l_status_code per_perf_mgmt_plans.status_code%TYPE;
10866: l_dummy BOOLEAN;
10867: --
10868: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
10869: --
10870: l_message_count NUMBER := 0;
10871: l_message VARCHAR2 (256);
10872: l_qual_pop_index BINARY_INTEGER;

Line 10921: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE

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
10925: FROM per_appraisals pa, per_personal_scorecards pps

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 11103: FROM per_personal_scorecards

11099: IS
11100: SELECT 'Y'
11101: FROM DUAL
11102: WHERE EXISTS (SELECT 'x'
11103: FROM per_personal_scorecards
11104: WHERE plan_id = p_plan_id);
11105:
11106: l_wpm_batch_action_id VARCHAR2 (30);
11107: l_effective_date DATE;