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_PERF_MGMT_PLANS

Line 225: TYPE t_plan_rec IS TABLE OF per_perf_mgmt_plans%ROWTYPE

221: INDEX BY BINARY_INTEGER;
222:
223: g_selected_entities t_selected_entities;
224:
225: TYPE t_plan_rec IS TABLE OF per_perf_mgmt_plans%ROWTYPE
226: INDEX BY BINARY_INTEGER;
227:
228: g_plan_rec t_plan_rec;
229: g_plan_dtls t_plan_rec;

Line 265: FROM per_perf_mgmt_plans

261:
262: CURSOR csr_plan_supervisor (p_plan_id IN NUMBER)
263: IS
264: SELECT hierarchy_type_code, supervisor_id, supervisor_assignment_id, assignment_types_code
265: FROM per_perf_mgmt_plans
266: WHERE plan_id = p_plan_id;
267:
268: l_plan_dtls csr_plan_supervisor%ROWTYPE;
269:

Line 716: PROCEDURE populate_qual_plan_population (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_effective_date IN DATE)

712: -- Internal Use Only.
713: --
714: -- {End Of Comments}
715: -- ----------------------------------------------------------------------------
716: PROCEDURE populate_qual_plan_population (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_effective_date IN DATE)
717: IS
718: -- Declare local variables
719: l_proc VARCHAR2 (72) := g_package || 'populate_qual_plan_population';
720: l_temp_pop_tbl g_qual_pop_t;

Line 880: CURSOR csr_apprl_periods (p_pln_id per_perf_mgmt_plans.plan_id%TYPE)

876: SELECT p_plan_rec.top_position_id subordinate_position_id
877: FROM DUAL)
878: );
879:
880: CURSOR csr_apprl_periods (p_pln_id per_perf_mgmt_plans.plan_id%TYPE)
881: IS
882: SELECT prds.appraisal_period_id, prds.appraisal_template_id, templ.business_group_id
883: FROM per_appraisal_periods prds, per_appraisal_templates templ
884: WHERE prds.plan_id = p_pln_id AND templ.appraisal_template_id = prds.appraisal_template_id;

Line 3939: p_plan_rec IN per_perf_mgmt_plans%ROWTYPE,

3935: -- |-----------------------------< start_process >----------------------------|
3936: -- ----------------------------------------------------------------------------
3937: --
3938: PROCEDURE start_process (
3939: p_plan_rec IN per_perf_mgmt_plans%ROWTYPE,
3940: p_effective_date IN DATE,
3941: p_reverse_mode IN VARCHAR2,
3942: p_item_type IN VARCHAR2,
3943: p_wf_process IN VARCHAR2

Line 4165: FROM per_perf_mgmt_plans

4161: -- Plan record
4162: CURSOR csr_get_plan_rec (p_plan_id NUMBER)
4163: IS
4164: SELECT *
4165: FROM per_perf_mgmt_plans
4166: WHERE plan_id = p_plan_id;
4167:
4168: --
4169: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

Line 4169: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

4165: FROM per_perf_mgmt_plans
4166: WHERE plan_id = p_plan_id;
4167:
4168: --
4169: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
4170: BEGIN
4171: --
4172: IF (funcmode = 'RUN')
4173: THEN

Line 4552: l_status_code per_perf_mgmt_plans.status_code%TYPE;

4548: )
4549: IS
4550: --
4551: l_object_version_number NUMBER := p_object_version_number;
4552: l_status_code per_perf_mgmt_plans.status_code%TYPE;
4553: l_dummy BOOLEAN;
4554: l_request_id NUMBER;
4555: l_effective_date DATE := NVL (p_effective_date, TRUNC (SYSDATE));
4556:

Line 4561: FROM per_perf_mgmt_plans

4557: -- Plan record
4558: CURSOR csr_get_plan_rec
4559: IS
4560: SELECT *
4561: FROM per_perf_mgmt_plans
4562: WHERE plan_id = p_plan_id;
4563:
4564: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
4565: --

Line 4564: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

4560: SELECT *
4561: FROM per_perf_mgmt_plans
4562: WHERE plan_id = p_plan_id;
4563:
4564: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
4565: --
4566: BEGIN
4567: -- Submit the request
4568: l_request_id :=

Line 4648: FROM per_perf_mgmt_plans

4644: --
4645: CURSOR csr_plan_ovn
4646: IS
4647: SELECT object_version_number
4648: FROM per_perf_mgmt_plans
4649: WHERE plan_id = p_plan_id;
4650:
4651: CURSOR csr_plan_status_code
4652: IS

Line 4654: FROM per_perf_mgmt_plans

4650:
4651: CURSOR csr_plan_status_code
4652: IS
4653: SELECT status_code
4654: FROM per_perf_mgmt_plans
4655: WHERE plan_id = p_plan_id;
4656:
4657: l_object_version_number NUMBER;
4658: l_status_code per_perf_mgmt_plans.status_code%TYPE;

Line 4658: l_status_code per_perf_mgmt_plans.status_code%TYPE;

4654: FROM per_perf_mgmt_plans
4655: WHERE plan_id = p_plan_id;
4656:
4657: l_object_version_number NUMBER;
4658: l_status_code per_perf_mgmt_plans.status_code%TYPE;
4659: l_dummy BOOLEAN;
4660: l_wpm_batch_action_id VARCHAR2 (30);
4661: --
4662: BEGIN

Line 4783: UPDATE per_perf_mgmt_plans

4779:
4780: --
4781: -- update status of the plan to 'Failed'
4782: --
4783: UPDATE per_perf_mgmt_plans
4784: SET status_code = 'FAILED'
4785: WHERE plan_id = p_plan_id;
4786:
4787: COMMIT;

Line 4819: l_status_code per_perf_mgmt_plans.status_code%TYPE;

4815: l_logging pay_action_parameters.parameter_value%TYPE;
4816: l_debug BOOLEAN := FALSE;
4817: l_effective_date DATE := TRUNC (NVL (p_effective_date, SYSDATE));
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: --

Line 4874: FROM per_perf_mgmt_plans

4870: -- Plan record
4871: CURSOR csr_get_plan_rec
4872: IS
4873: SELECT *
4874: FROM per_perf_mgmt_plans
4875: WHERE plan_id = p_plan_id;
4876:
4877: -- Scorecard Objectives
4878: CURSOR csr_sc_objectives (p_scorecard_id NUMBER)

Line 4901: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)

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.
4901: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
4902: IS
4903: SELECT elig.elig_obj_id
4904: FROM ben_elig_obj_f elig
4905: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'

Line 4905: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'

4901: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
4902: IS
4903: SELECT elig.elig_obj_id
4904: FROM ben_elig_obj_f elig
4905: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'
4906: AND elig.column_name = 'PLAN_ID'
4907: AND elig.COLUMN_VALUE = p_plan_id
4908: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;
4909:

Line 4916: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

4912: SELECT full_name
4913: FROM per_all_people_f ppf
4914: WHERE ppf.person_id = p_person_id AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
4915:
4916: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
4917: l_obj_date DATE := TRUNC (SYSDATE);
4918: l_scorecard_status_code VARCHAR2 (30);
4919: l_process_date DATE;
4920: l_process_date_char VARCHAR2 (50);

Line 6239: FROM per_perf_mgmt_plans

6235:
6236: CURSOR csr_get_admin
6237: IS
6238: SELECT administrator_person_id, supervisor_id
6239: FROM per_perf_mgmt_plans
6240: WHERE plan_id = l_plan_id;
6241:
6242: l_admin_person_id NUMBER;
6243: l_supervisor_id NUMBER;

Line 6308: PROCEDURE send_fyi_admin (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_status IN VARCHAR2, p_request_id IN NUMBER)

6304: -- ----------------------------------------------------------------------------
6305: -- |------------------------------< send_fyi_admin >--------------------------|
6306: -- ----------------------------------------------------------------------------
6307: --
6308: PROCEDURE send_fyi_admin (p_plan_rec IN per_perf_mgmt_plans%ROWTYPE, p_status IN VARCHAR2, p_request_id IN NUMBER)
6309: IS
6310: l_to_role_name wf_roles.NAME%TYPE;
6311: l_to_role_displayname wf_roles.display_name%TYPE;
6312: l_from_role_name wf_roles.NAME%TYPE;

Line 6808: l_status_code per_perf_mgmt_plans.status_code%TYPE;

6804: -----------------< change_plan_active_status >-----------------------------------------
6805: ---------------------------------------------------------------------------------------
6806: PROCEDURE change_plan_active_status (p_plan_id IN NUMBER)
6807: IS
6808: l_status_code per_perf_mgmt_plans.status_code%TYPE;
6809: BEGIN
6810: SELECT status_code
6811: INTO l_status_code
6812: FROM per_perf_mgmt_plans

Line 6812: FROM per_perf_mgmt_plans

6808: l_status_code per_perf_mgmt_plans.status_code%TYPE;
6809: BEGIN
6810: SELECT status_code
6811: INTO l_status_code
6812: FROM per_perf_mgmt_plans
6813: WHERE plan_id = p_plan_id;
6814:
6815: --- this is the logic for dectivating a published plan .
6816: IF (l_status_code = 'PUBLISHED')

Line 6818: UPDATE per_perf_mgmt_plans

6814:
6815: --- this is the logic for dectivating a published plan .
6816: IF (l_status_code = 'PUBLISHED')
6817: THEN
6818: UPDATE per_perf_mgmt_plans
6819: SET status_code = 'INACTIVE'
6820: WHERE plan_id = p_plan_id;
6821:
6822: COMMIT;

Line 6826: UPDATE per_perf_mgmt_plans

6822: COMMIT;
6823: --- logic for status code updated to published if already inactive
6824: ELSIF (l_status_code = 'INACTIVE')
6825: THEN
6826: UPDATE per_perf_mgmt_plans
6827: SET status_code = 'PUBLISHED'
6828: WHERE plan_id = p_plan_id;
6829:
6830: COMMIT;

Line 7055: FROM per_perf_mgmt_plans

7051:
7052: CURSOR csr_valid_plan (p_plan_id IN NUMBER)
7053: IS
7054: SELECT *
7055: FROM per_perf_mgmt_plans
7056: WHERE plan_id = p_plan_id;
7057:
7058: l_plan_rec csr_valid_plan%ROWTYPE;
7059:

Line 7080: l_plan_name per_perf_mgmt_plans.plan_name%TYPE;

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:
7082: TYPE tab_person_id IS TABLE OF per_appraisals.appraisee_person_id%TYPE
7083: INDEX BY BINARY_INTEGER;
7084:

Line 7088: l_status_code per_perf_mgmt_plans.status_code%TYPE;

7084:
7085: person_ids tab_person_id;
7086: l_effective_date DATE;
7087: l_object_version_number NUMBER;
7088: l_status_code per_perf_mgmt_plans.status_code%TYPE;
7089: l_dummy BOOLEAN;
7090: -- added for 13650421
7091: l_request_id NUMBER;
7092: BEGIN

Line 7723: l_plan_name per_perf_mgmt_plans.plan_name%TYPE;

7719: --
7720: PROCEDURE admin_enroll_into_plan (p_plan_id IN NUMBER, p_effective_date IN DATE)
7721: IS
7722: l_proc VARCHAR2 (72) := g_package || 'admin_enroll_into_plan';
7723: l_plan_name per_perf_mgmt_plans.plan_name%TYPE;
7724:
7725: --
7726: CURSOR csr_person_dtls (p_assignment_id IN NUMBER, p_effective_date IN DATE)
7727: IS

Line 8063: FROM per_perf_mgmt_plans

8059: --15902260
8060: CURSOR csr_valid_plan (p_plan_id IN NUMBER)
8061: IS
8062: SELECT *
8063: FROM per_perf_mgmt_plans
8064: WHERE plan_id = p_plan_id;
8065:
8066: l_plan_rec csr_valid_plan%ROWTYPE;
8067:

Line 8574: UPDATE per_perf_mgmt_plans

8570:
8571: -- Now update the plan with new supervisor id
8572: IF g_plan_dtls (1).hierarchy_type_code = 'SUP'
8573: THEN
8574: UPDATE per_perf_mgmt_plans
8575: SET supervisor_id = p_supervisor_id
8576: WHERE plan_id = p_plan_id;
8577:
8578: log_message ('Update plan sup to:' || p_supervisor_id);

Line 8581: UPDATE per_perf_mgmt_plans

8577:
8578: log_message ('Update plan sup to:' || p_supervisor_id);
8579: ELSIF g_plan_dtls (1).hierarchy_type_code = 'SUP_ASG'
8580: THEN
8581: UPDATE per_perf_mgmt_plans
8582: SET supervisor_assignment_id = p_supervisor_assignment_id
8583: WHERE plan_id = p_plan_id;
8584:
8585: log_message ('Update plan supasg to:' || p_supervisor_assignment_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 9200: FROM per_perf_mgmt_plans

9196:
9197: CURSOR csr_plan_dtls (p_plan_id IN NUMBER)
9198: IS
9199: SELECT *
9200: FROM per_perf_mgmt_plans
9201: WHERE plan_id = p_plan_id;
9202:
9203: l_effective_date DATE;
9204: l_sup_rollback_req_id NUMBER;

Line 9364: p_plan_id per_perf_mgmt_plans.plan_id%TYPE DEFAULT NULL,

9360: --
9361: PROCEDURE send_message_notification (
9362: p_person_id IN NUMBER,
9363: p_message VARCHAR2,
9364: p_plan_id per_perf_mgmt_plans.plan_id%TYPE DEFAULT NULL,
9365: p_full_name per_all_people_f.full_name%TYPE
9366: )
9367: IS
9368: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)

Line 9374: CURSOR csr_plan_det (p_plan_id per_perf_mgmt_plans.plan_id%TYPE)

9370: SELECT wf.NAME role_name
9371: FROM wf_roles wf
9372: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;
9373:
9374: CURSOR csr_plan_det (p_plan_id per_perf_mgmt_plans.plan_id%TYPE)
9375: IS
9376: SELECT plan_name, administrator_person_id
9377: FROM per_perf_mgmt_plans
9378: WHERE plan_id = p_plan_id;

Line 9377: FROM per_perf_mgmt_plans

9373:
9374: CURSOR csr_plan_det (p_plan_id per_perf_mgmt_plans.plan_id%TYPE)
9375: IS
9376: SELECT plan_name, administrator_person_id
9377: FROM per_perf_mgmt_plans
9378: WHERE plan_id = p_plan_id;
9379:
9380: CURSOR csr_full_name
9381: IS

Line 9703: l_pl_rec per_perf_mgmt_plans%ROWTYPE;

9699: IS
9700: l_proc VARCHAR2 (72) := g_package || 'submit_publish_plan_rep_cp';
9701: l_request_id NUMBER;
9702: l_effective_date DATE := NVL (p_effective_date, TRUNC (SYSDATE));
9703: l_pl_rec per_perf_mgmt_plans%ROWTYPE;
9704: l_dummy BOOLEAN;
9705: l_dummy1 VARCHAR2 (10);
9706: l_status_code VARCHAR2 (30);
9707: l_object_version_number NUMBER;

Line 9712: FROM per_perf_mgmt_plans

9708:
9709: CURSOR csr_plan (p_plan_id IN NUMBER)
9710: IS
9711: SELECT *
9712: FROM per_perf_mgmt_plans
9713: WHERE plan_id = p_plan_id;
9714:
9715: CURSOR csr_sc_exist (p_plan_id IN NUMBER)
9716: IS

Line 9726: FROM per_perf_mgmt_plans

9722:
9723: CURSOR csr_get_plan_rec
9724: IS
9725: SELECT *
9726: FROM per_perf_mgmt_plans
9727: WHERE plan_id = p_plan_id;
9728:
9729: l_plan_rec csr_get_plan_rec%ROWTYPE;
9730: BEGIN

Line 10409: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)

10405: END rebuild_sup_hierarchy;
10406:
10407: PROCEDURE reevaluate_plan_pop (p_plan_id IN NUMBER)
10408: IS
10409: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
10410: IS
10411: SELECT elig.elig_obj_id
10412: FROM ben_elig_obj_f elig
10413: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'

Line 10413: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'

10409: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
10410: IS
10411: SELECT elig.elig_obj_id
10412: FROM ben_elig_obj_f elig
10413: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'
10414: AND elig.column_name = 'PLAN_ID'
10415: AND elig.COLUMN_VALUE = p_plan_id
10416: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;
10417:

Line 10865: l_status_code per_perf_mgmt_plans.status_code%TYPE;

10861: l_logging pay_action_parameters.parameter_value%TYPE;
10862: l_debug BOOLEAN := FALSE;
10863: l_effective_date DATE := TRUNC (NVL (p_effective_date, SYSDATE));
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: --

Line 10903: FROM per_perf_mgmt_plans

10899: -- Plan record
10900: CURSOR csr_get_plan_rec
10901: IS
10902: SELECT *
10903: FROM per_perf_mgmt_plans
10904: WHERE plan_id = p_plan_id;
10905:
10906: -- Scorecard Objectives
10907: CURSOR csr_sc_objectives (p_scorecard_id NUMBER)

Line 10930: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)

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.
10930: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
10931: IS
10932: SELECT elig.elig_obj_id
10933: FROM ben_elig_obj_f elig
10934: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'

Line 10934: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'

10930: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
10931: IS
10932: SELECT elig.elig_obj_id
10933: FROM ben_elig_obj_f elig
10934: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'
10935: AND elig.column_name = 'PLAN_ID'
10936: AND elig.COLUMN_VALUE = p_plan_id
10937: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;
10938:

Line 10945: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

10941: SELECT full_name
10942: FROM per_all_people_f ppf
10943: WHERE ppf.person_id = p_person_id AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
10944:
10945: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
10946: l_obj_date DATE := TRUNC (SYSDATE);
10947: l_scorecard_status_code VARCHAR2 (30);
10948: l_process_date DATE;
10949: l_process_date_char VARCHAR2 (50);

Line 11089: l_pl_rec per_perf_mgmt_plans%ROWTYPE;

11085: )
11086: IS
11087: l_object_version_number NUMBER;
11088: l_proc VARCHAR2 (72) := g_package || 'plan_republish';
11089: l_pl_rec per_perf_mgmt_plans%ROWTYPE;
11090: l_dummy VARCHAR2 (10);
11091:
11092: CURSOR csr_plan (p_plan_id IN NUMBER)
11093: IS

Line 11095: FROM per_perf_mgmt_plans

11091:
11092: CURSOR csr_plan (p_plan_id IN NUMBER)
11093: IS
11094: SELECT *
11095: FROM per_perf_mgmt_plans
11096: WHERE plan_id = p_plan_id;
11097:
11098: CURSOR csr_sc_exist (p_plan_id IN NUMBER)
11099: IS

Line 11217: UPDATE per_perf_mgmt_plans

11213: SET end_date = SYSDATE,
11214: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
11215: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
11216:
11217: UPDATE per_perf_mgmt_plans
11218: SET status_code = 'PUBLISHED'
11219: WHERE plan_id = p_plan_id;
11220: COMMIT;
11221: hr_utility.set_location ('Leaving:' || l_proc, 80);

Line 11241: UPDATE per_perf_mgmt_plans

11237:
11238: --
11239: -- update status of the plan to 'Failed'
11240: --
11241: UPDATE per_perf_mgmt_plans
11242: SET status_code = 'FAILED'
11243: WHERE plan_id = p_plan_id;
11244:
11245: COMMIT;