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_INTERVIEW dependencies on PER_ASSIGNMENTS_F

Line 37: references to per_assignments_f

33: -------+---------+----------+---------+-----------------------
34: 70.0 09-FEB-93 PShergill Date Created
35: 70.1 11-MAR-93 Nkhan Added 'exit' to the end
36: 70.2 17-AUG-93 Nkhan Added SOURCE_TYPE field
37: references to per_assignments_f
38: 70.3 16-JUN-94 PShergill Fix 220466 added ATTRIBUTE21..30
39: 70.11 23-NOV-94 RFine Suppressed index on business_group_id
40: 115.3 23-DEC-03 bsubrama Bug 3333891 - Changed the NVL values
41: for salary rewiew period, performance

Line 82: FROM per_assignments_f

78: p_dummy VARCHAR2(1);
79: --
80: CURSOR select_ass_for_insert IS
81: SELECT *
82: FROM per_assignments_f
83: WHERE assignment_id = p_assignment_id
84: FOR UPDATE;
85: --
86: --

Line 109: FROM per_assignments_f

105: INTO p_dummy
106: FROM sys.dual
107: WHERE EXISTS
108: ( SELECT '1'
109: FROM per_assignments_f
110: WHERE assignment_id = p_assignment_id
111: AND ((effective_end_date <> to_date('31/12/4712','DD/MM/YYYY')
112: AND effective_end_date >= p_int_date)
113: OR (effective_start_date = p_int_date)));

Line 127: INSERT INTO per_assignments_f

123: --
124: -- Insert the Interview
125: hr_utility.set_location('hr_interview.insert_interview',3);
126: --
127: INSERT INTO per_assignments_f
128: (
129: assignment_id
130: ,effective_start_date
131: ,effective_end_date

Line 311: FROM per_assignments_f

307: ,last_update_login
308: ,created_by
309: ,creation_date
310: ,source_type
311: FROM per_assignments_f
312: WHERE assignment_id = p_assignment_id
313: AND p_int_date
314: BETWEEN effective_start_date and effective_end_date;
315: --

Line 324: UPDATE per_assignments_f

320: hr_utility.raise_error;
321: ELSE
322: hr_utility.set_location('hr_interview.insert_interview',4);
323: --
324: UPDATE per_assignments_f
325: SET effective_start_date = p_int_date
326: , assignment_status_type_id = p_assignment_status_type_id
327: , last_updated_by = p_last_updated_by
328: , last_update_login = p_last_update_login

Line 369: FROM per_assignments_f c

365: l_results varchar2(10);
366: --
367: cursor csr_asg is
368: SELECT *
369: FROM per_assignments_f c
370: WHERE c.assignment_id = p_assignment_id
371: AND p_effective_date BETWEEN
372: c.effective_start_date AND c.effective_end_date;
373: --

Line 376: FROM per_assignments_f o

372: c.effective_start_date AND c.effective_end_date;
373: --
374: cursor csr_prev_asg(cp_asg_id number, cp_effective_date date, cp_bg_id number) is
375: SELECT *
376: FROM per_assignments_f o
377: WHERE o.assignment_id = cp_asg_id
378: AND o.effective_end_date = cp_effective_date
379: AND o.business_group_id + 0 = cp_bg_id + 0;
380: --

Line 525: FROM per_assignments_f

521: p_new_status_type_date DATE;
522: --
523: CURSOR select_ass_for_delete IS
524: SELECT *
525: FROM per_assignments_f
526: WHERE assignment_id = p_assignment_id
527: FOR UPDATE;
528: --
529: BEGIN

Line 561: FROM per_assignments_f a

557: hr_utility.set_location('hr_interview.delete_interview',3);
558: --
559: SELECT a.assignment_status_type_id
560: INTO p_old_interview_status
561: FROM per_assignments_f a
562: WHERE a.assignment_id = p_assignment_id
563: AND a.effective_start_date = p_int_date;
564: --
565: EXCEPTION

Line 586: UPDATE per_assignments_f a

582: -- done For CASE A, B, and C
583: --
584: hr_utility.set_location('hr_interview.delete_interview',4);
585: --
586: UPDATE per_assignments_f a
587: SET effective_end_date = (SELECT effective_end_date
588: FROM per_assignments_f b
589: WHERE b.assignment_id = p_assignment_id
590: AND b.effective_start_date =

Line 588: FROM per_assignments_f b

584: hr_utility.set_location('hr_interview.delete_interview',4);
585: --
586: UPDATE per_assignments_f a
587: SET effective_end_date = (SELECT effective_end_date
588: FROM per_assignments_f b
589: WHERE b.assignment_id = p_assignment_id
590: AND b.effective_start_date =
591: p_int_date)
592: , last_updated_by = p_last_updated_by

Line 607: DELETE per_assignments_f a

603: END IF;
604: --
605: hr_utility.set_location('hr_interview.delete_interview',5);
606: --
607: DELETE per_assignments_f a
608: WHERE a.assignment_id = p_assignment_id
609: AND a.effective_start_date = p_int_date;
610: --
611: IF SQL%ROWCOUNT <> 1 THEN

Line 629: FROM per_assignments_f a

625: hr_utility.set_location('hr_interview.delete_interview',6);
626: --
627: SELECT a.effective_end_date
628: INTO p_dummy_date
629: FROM per_assignments_f a
630: WHERE a.assignment_id = p_assignment_id
631: AND p_int_date BETWEEN a.effective_start_date AND a.effective_end_date;
632: --
633: EXCEPTION

Line 652: FROM per_assignments_f d

648: hr_utility.set_location('hr_interview.delete_interview',7);
649: --
650: SELECT d.assignment_status_type_id
651: INTO p_previous_status
652: FROM per_assignments_f d
653: WHERE d.assignment_id = p_assignment_id
654: AND d.effective_end_date = p_int_date -1;
655: --
656: EXCEPTION

Line 664: UPDATE per_assignments_f a

660: hr_utility.set_message_token('STEP','6');
661: hr_utility.raise_error;
662: END;
663: --
664: UPDATE per_assignments_f a
665: SET assignment_status_type_id = p_previous_status
666: , last_updated_by = p_last_updated_by
667: , last_update_login = p_last_update_login
668: , last_update_date = sysdate

Line 702: FROM per_assignments_f d

698: hr_utility.set_location('hr_interview.delete_interview',9);
699: --
700: SELECT d.assignment_status_type_id
701: INTO p_previous_status
702: FROM per_assignments_f d
703: WHERE d.assignment_id = p_assignment_id
704: AND p_int_date
705: BETWEEN d.effective_start_date AND d.effective_end_date;
706: --

Line 723: FROM per_assignments_f d

719: hr_utility.set_location('hr_interview.delete_interview',10);
720: --
721: SELECT d.assignment_status_type_id
722: INTO p_previous_status
723: FROM per_assignments_f d
724: WHERE d.assignment_id = p_assignment_id
725: AND d.effective_end_date = p_int_date -1;
726: --
727: EXCEPTION

Line 744: FROM per_assignments_f c

740: hr_utility.set_location('hr_interview.delete_interview',11);
741: --
742: SELECT MIN(c.effective_start_date)
743: INTO p_new_status_type_date
744: FROM per_assignments_f c
745: WHERE c.assignment_id = p_assignment_id
746: AND c.effective_start_date > p_int_date
747: AND c.assignment_status_type_id <> p_old_interview_status;
748: --

Line 756: UPDATE per_assignments_f a

752: -- Ripple the pre interview status CASE B,C and D.
753: --
754: hr_utility.set_location('hr_interview.delete_interview',12);
755: --
756: UPDATE per_assignments_f a
757: SET assignment_status_type_id = p_previous_status
758: , last_updated_by = p_last_updated_by
759: , last_update_login = p_last_update_login
760: , last_update_date = sysdate

Line 776: UPDATE per_assignments_f a

772: IF p_nxt_interview_date IS NULL AND p_new_status_type_date IS NULL THEN
773: --
774: hr_utility.set_location('hr_interview.delete_interview',14);
775: --
776: UPDATE per_assignments_f a
777: SET assignment_status_type_id = p_previous_status
778: , last_updated_by = p_last_updated_by
779: , last_update_login = p_last_update_login
780: , last_update_date = sysdate

Line 826: FROM per_assignments_f

822: p_ass_status_type_id INTEGER;
823: --
824: CURSOR select_ass_for_update IS
825: SELECT *
826: FROM per_assignments_f
827: WHERE assignment_id = p_assignment_id
828: FOR UPDATE;
829: --
830: BEGIN

Line 856: FROM per_assignments_f a

852: INTO p_no_update
853: FROM sys.dual
854: WHERE EXISTS
855: (SELECT '1'
856: FROM per_assignments_f a
857: WHERE a.assignment_id = p_assignment_id
858: AND (((a.effective_start_date
859: BETWEEN p_old_int_date + 1 AND p_int_date -1)
860: AND p_old_int_date < p_int_date)

Line 889: FROM per_assignments_f a

885: hr_utility.set_location('hr_interview.update_interview',4);
886: BEGIN
887: SELECT 'Y'
888: INTO p_matches
889: FROM per_assignments_f a
890: WHERE a.assignment_id = p_assignment_id
891: AND a.effective_start_date = p_int_date;
892: EXCEPTION
893: WHEN NO_DATA_FOUND THEN NULL;

Line 901: UPDATE per_assignments_f a

897: --
898: IF p_matches = 'N' THEN /* CASE A */
899: --
900: hr_utility.set_location('hr_interview.update_interview',6);
901: UPDATE per_assignments_f a
902: SET a.effective_start_date = p_int_date
903: , a.last_updated_by = p_last_updated_by
904: , a.last_update_login = p_last_update_login
905: , a.last_update_date = sysdate

Line 917: UPDATE per_assignments_f a

913: hr_utility.raise_error;
914: END IF;
915: --
916: hr_utility.set_location('hr_interview.update_interview',7);
917: UPDATE per_assignments_f a
918: SET a.effective_end_date = p_int_date -1
919: , a.last_updated_by = p_last_updated_by
920: , a.last_update_login = p_last_update_login
921: , a.last_update_date = sysdate

Line 935: DELETE per_assignments_f a

931: --
932: ELSE /* CASE C */
933: --
934: hr_utility.set_location('hr_interview.update_interview',8);
935: DELETE per_assignments_f a
936: WHERE a.assignment_id = p_assignment_id
937: AND a.effective_start_date = p_old_int_date;
938: --
939: IF SQL%ROWCOUNT <> 1 THEN

Line 947: UPDATE per_assignments_f a

943: hr_utility.raise_error;
944: END IF;
945: --
946: hr_utility.set_location('hr_interview.update_interview',9);
947: UPDATE per_assignments_f a
948: SET a.effective_end_date = p_int_date -1
949: , a.last_updated_by = p_last_updated_by
950: , a.last_update_login = p_last_update_login
951: , a.last_update_date = sysdate

Line 980: FROM per_assignments_f a

976: INTO p_no_update
977: FROM sys.dual
978: WHERE EXISTS
979: (SELECT '1'
980: FROM per_assignments_f a
981: WHERE a.assignment_id = p_assignment_id
982: AND a.effective_start_date >= p_int_date);
983: EXCEPTION
984: --

Line 998: FROM per_assignments_f a

994: hr_utility.set_location('hr_interview.update_interview',11);
995: --
996: SELECT a.assignment_status_type_id
997: INTO p_ass_status_type_id
998: FROM per_assignments_f a
999: WHERE a.assignment_id = p_assignment_id
1000: AND a.effective_end_date = p_old_int_date -1;
1001: --
1002: IF SQL%ROWCOUNT <> 1 THEN

Line 1011: INSERT INTO per_assignments_f

1007: END IF;
1008: --
1009: hr_utility.set_location('hr_interview.update_interview',12);
1010: --
1011: INSERT INTO per_assignments_f
1012: (
1013: assignment_id
1014: ,effective_start_date
1015: ,effective_end_date

Line 1195: FROM per_assignments_f

1191: ,last_update_login
1192: ,created_by
1193: ,creation_date
1194: ,source_type
1195: FROM per_assignments_f
1196: WHERE assignment_id = p_assignment_id
1197: AND effective_start_date = p_old_int_date;
1198: --
1199: IF SQL%ROWCOUNT <> 1 THEN

Line 1206: UPDATE per_assignments_f a

1202: hr_utility.set_message_token('STEP','6');
1203: hr_utility.raise_error;
1204: ELSE
1205: hr_utility.set_location('hr_interview.update_interview',13);
1206: UPDATE per_assignments_f a
1207: SET a.effective_start_date = p_int_date
1208: , a.last_updated_by = p_last_updated_by
1209: , a.last_update_login = p_last_update_login
1210: , a.last_update_date = sysdate

Line 1227: FROM per_assignments_f a

1223: --
1224: hr_utility.set_location('hr_interview.update_interview',14);
1225: SELECT a.assignment_status_type_id
1226: INTO p_ass_status_type_id
1227: FROM per_assignments_f a
1228: WHERE a.assignment_id = p_assignment_id
1229: AND a.effective_start_date = p_old_int_date;
1230: --
1231: IF SQL%ROWCOUNT <> 1 THEN

Line 1241: FROM per_assignments_f a

1237: --
1238: hr_utility.set_location('hr_interview.update_interview',15);
1239: SELECT a.effective_start_date
1240: INTO p_old_prev_start_date
1241: FROM per_assignments_f a
1242: WHERE a.assignment_id = p_assignment_id
1243: AND a.effective_end_date = p_old_int_date -1;
1244: --
1245: IF SQL%ROWCOUNT <> 1 THEN

Line 1255: INSERT INTO per_assignments_f

1251: --
1252: -- Insert the Interview
1253: hr_utility.set_location('hr_interview.update_interview',16);
1254: --
1255: INSERT INTO per_assignments_f
1256: (
1257: assignment_id
1258: ,effective_start_date
1259: ,effective_end_date

Line 1439: FROM per_assignments_f

1435: ,last_update_login
1436: ,created_by
1437: ,creation_date
1438: ,source_type
1439: FROM per_assignments_f
1440: WHERE assignment_id = p_assignment_id
1441: AND effective_end_date = p_old_int_date -1;
1442: --
1443: IF SQL%ROWCOUNT <>1 THEN

Line 1451: UPDATE per_assignments_f a

1447: hr_utility.raise_error;
1448: ELSE
1449: hr_utility.set_location('hr_interview.update_interview',17);
1450: --
1451: UPDATE per_assignments_f a
1452: SET a.effective_end_date = p_int_date -1
1453: , a.last_updated_by = p_last_updated_by
1454: , a.last_update_login = p_last_update_login
1455: , a.last_update_date = sysdate