APPS.PER_ASSIGNMENTS_V8_PKG dependencies on PER_ASSIGNMENTS_F

Line 66: CURSOR C0 is select * from per_assignments_f

62: -- Cursor to get rest of the fields not used/required by PA but
63: -- which may have had values added by other apps and therfore preserve them
64: -- for these other APPS.
65: --
66: CURSOR C0 is select * from per_assignments_f
67: where rowid = X_ROWID;
68: --
69: --
70: -- Get the rowid effective as of start date

Line 73: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENTS_F

69: --
70: -- Get the rowid effective as of start date
71: -- May not necessarily be one if EFS appears between another record.
72: --
73: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENTS_F
74: WHERE assignment_id = X_Assignment_Id
75: and effective_start_date = X_effective_start_date
76: for update of assignment_id;
77: --

Line 83: from per_assignments_f

79: -- Cursor to ensure the Assignment was entered.
80: --
81: CURSOR C2 is
82: select rowid
83: from per_assignments_f
84: where assignment_id = X_ASSIGNMENT_ID
85: and effective_start_Date = X_EFFECTIVE_START_DATE
86: and effective_end_date = X_EFFECTIVE_END_DATE;
87: --

Line 92: CURSOR C3 is select rowid from per_assignments_f

88: --
89: -- Update any records that exist between start and
90: -- end of the new assignment.
91: --
92: CURSOR C3 is select rowid from per_assignments_f
93: where rowid <> X_ROWID
94: and effective_end_date between
95: X_EFFECTIVE_START_DATE
96: and X_EFFECTIVE_END_DATE

Line 126: INSERT INTO PER_ASSIGNMENTS_F(

122: --
123:
124: hr_utility.set_location('Enterring:per_assignments_v8_pkg.insert_row',10);
125:
126: INSERT INTO PER_ASSIGNMENTS_F(
127: assignment_id,
128: effective_start_date,
129: effective_end_date,
130: business_group_id,

Line 308: UPDATE PER_ASSIGNMENTS_F

304: --
305: open c3;
306: fetch c3 into asg_rec;
307: while c3%found loop
308: UPDATE PER_ASSIGNMENTS_F
309: SET EFFECTIVE_END_DATE = X_EFFECTIVE_START_DATE - 1,
310: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
311: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
312: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 447: delete from per_assignments_f

443: END Insert_Row;
444: --
445: procedure delete_record(p_rowid VARCHAR2) is
446: begin
447: delete from per_assignments_f
448: where rowid = chartorowid(p_rowid);
449: end;
450: --
451: procedure get_enddate_and_defaults(p_effective_start_date IN OUT NOCOPY DATE

Line 575: PER_ASSIGNMENTS_F PAS

571: PER_JOBS_V PJ,
572: HR_POSITIONS_F PP,
573: HR_LOCATIONS LOC,
574: PER_ORGANIZATION_UNITS_PERF PO,
575: PER_ASSIGNMENTS_F PAS
576: WHERE PJ.JOB_ID(+) = PAS.JOB_ID
577: AND PP.POSITION_ID(+) = PAS.POSITION_ID
578: AND PP.JOB_ID(+) = PAS.JOB_ID
579: AND PAS.ORGANIZATION_ID = PO.ORGANIZATION_ID

Line 599: FROM PER_ASSIGNMENTS_F

595: --
596: cursor get_minimum_end
597: IS
598: SELECT MIN(EFFECTIVE_START_DATE) - 1
599: FROM PER_ASSIGNMENTS_F
600: WHERE EFFECTIVE_START_DATE >
601: p_EFFECTIVE_START_DATE
602: AND PERSON_ID = p_PERSON_ID
603: and assignment_id =p_assignment_id

Line 613: FROM PER_ASSIGNMENTS_F

609: --
610: cursor get_end_date
611: IS
612: SELECT MIN(EFFECTIVE_END_DATE)
613: FROM PER_ASSIGNMENTS_F
614: WHERE EFFECTIVE_END_DATE >
615: p_effective_start_date
616: AND PERSON_ID = p_person_id
617: and assignment_id =p_assignment_id

Line 688: PER_ASSIGNMENTS_F PAS

684: PER_JOBS_V PJ,
685: HR_POSITIONS_F PP,
686: HR_LOCATIONS LOC,
687: PER_ORGANIZATION_UNITS_PERF PO,
688: PER_ASSIGNMENTS_F PAS
689: WHERE
690: PAS.JOB_ID = PJ.JOB_ID (+)
691: AND PP.POSITION_ID(+) = PAS.POSITION_ID
692: AND PP.JOB_ID(+) = PAS.JOB_ID