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_ALL_ASSIGNMENTS_F

Line 37: assignment_id per_all_assignments_f.assignment_id%TYPE,

33: --
34:
35: -- Used for populating Plan Population
36: TYPE g_qual_pop_r IS RECORD (
37: assignment_id per_all_assignments_f.assignment_id%TYPE,
38: person_id per_all_assignments_f.person_id%TYPE,
39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,

Line 38: person_id per_all_assignments_f.person_id%TYPE,

34:
35: -- Used for populating Plan Population
36: TYPE g_qual_pop_r IS RECORD (
37: assignment_id per_all_assignments_f.assignment_id%TYPE,
38: person_id per_all_assignments_f.person_id%TYPE,
39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,
42: organization_id per_all_assignments_f.organization_id%TYPE,

Line 39: business_group_id per_all_assignments_f.business_group_id%TYPE,

35: -- Used for populating Plan Population
36: TYPE g_qual_pop_r IS RECORD (
37: assignment_id per_all_assignments_f.assignment_id%TYPE,
38: person_id per_all_assignments_f.person_id%TYPE,
39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,
42: organization_id per_all_assignments_f.organization_id%TYPE,
43: position_id per_all_assignments_f.position_id%TYPE

Line 40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

36: TYPE g_qual_pop_r IS RECORD (
37: assignment_id per_all_assignments_f.assignment_id%TYPE,
38: person_id per_all_assignments_f.person_id%TYPE,
39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,
42: organization_id per_all_assignments_f.organization_id%TYPE,
43: position_id per_all_assignments_f.position_id%TYPE
44: );

Line 41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,

37: assignment_id per_all_assignments_f.assignment_id%TYPE,
38: person_id per_all_assignments_f.person_id%TYPE,
39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,
42: organization_id per_all_assignments_f.organization_id%TYPE,
43: position_id per_all_assignments_f.position_id%TYPE
44: );
45:

Line 42: organization_id per_all_assignments_f.organization_id%TYPE,

38: person_id per_all_assignments_f.person_id%TYPE,
39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,
42: organization_id per_all_assignments_f.organization_id%TYPE,
43: position_id per_all_assignments_f.position_id%TYPE
44: );
45:
46: TYPE g_qual_pop_t IS TABLE OF g_qual_pop_r

Line 43: position_id per_all_assignments_f.position_id%TYPE

39: business_group_id per_all_assignments_f.business_group_id%TYPE,
40: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
41: supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%TYPE,
42: organization_id per_all_assignments_f.organization_id%TYPE,
43: position_id per_all_assignments_f.position_id%TYPE
44: );
45:
46: TYPE g_qual_pop_t IS TABLE OF g_qual_pop_r
47: INDEX BY BINARY_INTEGER;

Line 142: assignment_id per_all_assignments_f.assignment_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,
143: business_group_id per_all_assignments_f.business_group_id%TYPE,
144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,

Line 143: business_group_id per_all_assignments_f.business_group_id%TYPE,

139: );
140:
141: TYPE assignment_info IS RECORD (
142: assignment_id per_all_assignments_f.assignment_id%TYPE,
143: business_group_id per_all_assignments_f.business_group_id%TYPE,
144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,

Line 144: grade_id per_all_assignments_f.grade_id%TYPE,

140:
141: TYPE assignment_info IS RECORD (
142: assignment_id per_all_assignments_f.assignment_id%TYPE,
143: business_group_id per_all_assignments_f.business_group_id%TYPE,
144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,
148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

Line 145: position_id per_all_assignments_f.position_id%TYPE,

141: TYPE assignment_info IS RECORD (
142: assignment_id per_all_assignments_f.assignment_id%TYPE,
143: business_group_id per_all_assignments_f.business_group_id%TYPE,
144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,
148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
149: effective_state_date per_all_assignments_f.effective_start_date%TYPE

Line 146: job_id per_all_assignments_f.job_id%TYPE,

142: assignment_id per_all_assignments_f.assignment_id%TYPE,
143: business_group_id per_all_assignments_f.business_group_id%TYPE,
144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,
148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
149: effective_state_date per_all_assignments_f.effective_start_date%TYPE
150: );

Line 147: org_id per_all_assignments_f.organization_id%TYPE,

143: business_group_id per_all_assignments_f.business_group_id%TYPE,
144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,
148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
149: effective_state_date per_all_assignments_f.effective_start_date%TYPE
150: );
151:

Line 148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

144: grade_id per_all_assignments_f.grade_id%TYPE,
145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,
148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
149: effective_state_date per_all_assignments_f.effective_start_date%TYPE
150: );
151:
152: TYPE appraisal_templ_info IS RECORD (

Line 149: effective_state_date per_all_assignments_f.effective_start_date%TYPE

145: position_id per_all_assignments_f.position_id%TYPE,
146: job_id per_all_assignments_f.job_id%TYPE,
147: org_id per_all_assignments_f.organization_id%TYPE,
148: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
149: effective_state_date per_all_assignments_f.effective_start_date%TYPE
150: );
151:
152: TYPE appraisal_templ_info IS RECORD (
153: appraisal_template_id per_appraisal_templates.appraisal_template_id%TYPE,

Line 290: FROM per_all_assignments_f paaf, per_periods_of_service pps

286: SELECT 'Y'
287: FROM DUAL
288: WHERE EXISTS (
289: SELECT 'x'
290: FROM per_all_assignments_f paaf, per_periods_of_service pps
291: WHERE paaf.assignment_id = p_supervisor_asg_id
292: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
293: AND paaf.period_of_service_id = pps.period_of_service_id
294: AND TRUNC (SYSDATE) BETWEEN pps.date_start AND NVL (pps.actual_termination_date, TRUNC (SYSDATE)));

Line 316: FROM per_all_assignments_f paaf, per_periods_of_placement ppp

312: SELECT 'Y'
313: FROM DUAL
314: WHERE EXISTS (
315: SELECT 'x'
316: FROM per_all_assignments_f paaf, per_periods_of_placement ppp
317: WHERE paaf.assignment_id = p_supervisor_asg_id
318: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
319: AND paaf.person_id = ppp.person_id
320: AND paaf.period_of_placement_date_start = ppp.date_start

Line 731: FROM per_all_assignments_f asg

727: IS
728: SELECT *
729: FROM (SELECT asg.assignment_id, asg.person_id, asg.business_group_id, asg.supervisor_id,
730: asg.supervisor_assignment_id, asg.organization_id, asg.position_id
731: FROM per_all_assignments_f asg
732: WHERE ( ( p_plan_rec.assignment_types_code IN ('E', 'C')
733: AND asg.assignment_type = p_plan_rec.assignment_types_code
734: )
735: OR (p_plan_rec.assignment_types_code = 'EC' AND asg.assignment_type IN ('E', 'C'))

Line 767: FROM per_all_assignments_f asg

763: IS
764: SELECT *
765: FROM (SELECT asg.assignment_id, asg.person_id, asg.business_group_id, asg.supervisor_id,
766: asg.supervisor_assignment_id, asg.organization_id, asg.position_id
767: FROM per_all_assignments_f asg
768: WHERE ( ( p_plan_rec.assignment_types_code IN ('E', 'C')
769: AND asg.assignment_type = p_plan_rec.assignment_types_code
770: )
771: OR (p_plan_rec.assignment_types_code = 'EC' AND asg.assignment_type IN ('E', 'C'))

Line 799: FROM per_all_assignments_f asg

795: CURSOR csr_org_hier_pop
796: IS
797: SELECT asg.assignment_id, asg.person_id, asg.business_group_id, asg.supervisor_id, asg.supervisor_assignment_id,
798: asg.organization_id, asg.position_id
799: FROM per_all_assignments_f asg
800: WHERE ( (p_plan_rec.assignment_types_code IN ('E', 'C') AND asg.assignment_type = 'E')
801: OR (p_plan_rec.assignment_types_code = 'EC' AND asg.assignment_type IN ('E', 'C'))
802: )
803: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 843: FROM per_all_assignments_f asg

839: CURSOR csr_pos_hier_pop
840: IS
841: SELECT asg.assignment_id, asg.person_id, asg.business_group_id, asg.supervisor_id, asg.supervisor_assignment_id,
842: asg.organization_id, asg.position_id
843: FROM per_all_assignments_f asg
844: WHERE ( (p_plan_rec.assignment_types_code IN ('E', 'C') AND asg.assignment_type = p_plan_rec.assignment_types_code)
845: OR (p_plan_rec.assignment_types_code = 'EC' AND asg.assignment_type IN ('E', 'C'))
846: )
847: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 3002: CURSOR get_assignment_info (p_assignment_id per_all_assignments_f.assignment_id%TYPE)

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
3004: SELECT assignment_id, business_group_id, grade_id, position_id, job_id, organization_id, supervisor_id,
3005: effective_start_date
3006: FROM per_all_assignments_f

Line 3006: FROM per_all_assignments_f

3002: CURSOR get_assignment_info (p_assignment_id per_all_assignments_f.assignment_id%TYPE)
3003: IS
3004: SELECT assignment_id, business_group_id, grade_id, position_id, job_id, organization_id, supervisor_id,
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

Line 6779: FROM per_all_assignments_f paa

6775: ---- cursor to get the organisation of the person.
6776: CURSOR csr_get_org (p_person_id IN NUMBER)
6777: IS
6778: SELECT paa.organization_id
6779: FROM per_all_assignments_f paa
6780: WHERE (TRUNC (SYSDATE) BETWEEN paa.effective_start_date AND paa.effective_end_date)
6781: AND paa.person_id = p_person_id
6782: AND paa.primary_flag = 'Y';
6783:

Line 8144: --Bug7567079 l_sup_id per_all_assignments_f.supervisor_id%type default null;

8140:
8141: l_appraisals_in_progress VARCHAR2 (1) := 'N';
8142: l_sc_dtls VARCHAR2 (500);
8143: l_scorecard_status_code VARCHAR2 (30);
8144: --Bug7567079 l_sup_id per_all_assignments_f.supervisor_id%type default null;
8145: BEGIN
8146: OPEN csr_appr_in_progress (p_plan_id, p_effective_date);
8147:
8148: FETCH csr_appr_in_progress

Line 8239: l_sup_id per_all_assignments_f.supervisor_id%TYPE DEFAULT NULL;

8235: FROM per_objectives
8236: WHERE scorecard_id = p_scorecard_id AND copied_from_library_id = p_library_id;
8237:
8238: l_sc_dup_obj VARCHAR2 (1);
8239: l_sup_id per_all_assignments_f.supervisor_id%TYPE DEFAULT NULL;
8240: BEGIN
8241: IF (g_plan_dtls (1).automatic_allocation_flag = 'Y')
8242: THEN
8243: populate_qual_objectives (g_plan_dtls (1).start_date, g_plan_dtls (1).end_date);

Line 8427: FROM per_all_assignments_f asg

8423: IS
8424: SELECT *
8425: FROM (SELECT asg.assignment_id, asg.person_id, asg.business_group_id, asg.supervisor_id,
8426: asg.supervisor_assignment_id, asg.organization_id, asg.position_id
8427: FROM per_all_assignments_f asg
8428: WHERE ( ( g_plan_dtls (1).assignment_types_code IN ('E', 'C')
8429: AND asg.assignment_type = g_plan_dtls (1).assignment_types_code
8430: )
8431: OR (g_plan_dtls (1).assignment_types_code = 'EC' AND asg.assignment_type IN ('E', 'C'))

Line 8463: FROM per_all_assignments_f asg

8459: IS
8460: SELECT *
8461: FROM (SELECT asg.assignment_id, asg.person_id, asg.business_group_id, asg.supervisor_id,
8462: asg.supervisor_assignment_id, asg.organization_id, asg.position_id
8463: FROM per_all_assignments_f asg
8464: WHERE ( ( g_plan_dtls (1).assignment_types_code IN ('E', 'C')
8465: AND asg.assignment_type = g_plan_dtls (1).assignment_types_code
8466: )
8467: OR (g_plan_dtls (1).assignment_types_code = 'EC' AND asg.assignment_type IN ('E', 'C'))

Line 9505: p_person_id IN per_all_assignments_f.person_id%TYPE,

9501: err_msg := SUBSTR ('Error ' || TO_CHAR (SQLCODE) || ': ' || SQLERRM, 1, 255);
9502: END send_message_notification;
9503:
9504: FUNCTION get_manager_id (
9505: p_person_id IN per_all_assignments_f.person_id%TYPE,
9506: p_assignment_id per_all_assignments_f.assignment_id%TYPE
9507: )
9508: RETURN NUMBER
9509: IS

Line 9506: p_assignment_id per_all_assignments_f.assignment_id%TYPE

9502: END send_message_notification;
9503:
9504: FUNCTION get_manager_id (
9505: p_person_id IN per_all_assignments_f.person_id%TYPE,
9506: p_assignment_id per_all_assignments_f.assignment_id%TYPE
9507: )
9508: RETURN NUMBER
9509: IS
9510: CURSOR get_supervisor_id (person_id per_all_people_f.person_id%TYPE)

Line 9514: FROM per_all_assignments_f

9510: CURSOR get_supervisor_id (person_id per_all_people_f.person_id%TYPE)
9511: IS
9512: --8262552 Changes to get the correct supervisor Id based on assignment Id
9513: SELECT supervisor_id
9514: FROM per_all_assignments_f
9515: WHERE person_id = p_person_id
9516: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date
9517: AND assignment_id = p_assignment_id;
9518:

Line 9519: l_super_visor_id per_all_assignments_f.supervisor_id%TYPE;

9515: WHERE person_id = p_person_id
9516: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date
9517: AND assignment_id = p_assignment_id;
9518:
9519: l_super_visor_id per_all_assignments_f.supervisor_id%TYPE;
9520: l_role wf_local_roles.NAME%TYPE DEFAULT NULL;
9521: BEGIN
9522: OPEN get_supervisor_id (p_person_id);
9523:

Line 9891: l_sup_id per_all_assignments_f.supervisor_id%TYPE DEFAULT NULL;

9887:
9888: l_obj_ovn NUMBER;
9889: l_objective_id NUMBER;
9890: l_sc_dup_obj VARCHAR2 (1);
9891: l_sup_id per_all_assignments_f.supervisor_id%TYPE DEFAULT NULL;
9892: BEGIN
9893: l_scorecard_id := p_scorecard_id;
9894: OPEN csr_sc_dtls (p_scorecard_id, p_plan_id, l_obj_date);
9895: