APPS.PER_ASSIGNMENTS_V7_PKG dependencies on PER_ASSIGNMENTS_F

Line 90: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENTS_F

86: X_Created_By NUMBER,
87: X_Creation_Date DATE,
88: X_Title VARCHAR2
89: ) IS
90: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENTS_F
91: WHERE assignment_id = X_Assignment_Id;
92: CURSOR C2 IS SELECT per_assignments_s.nextval FROM sys.dual;
93: cursor c3 is
94: select past.assignment_status_type_id

Line 138: INSERT INTO PER_ASSIGNMENTS_F(

134: per_assignments_v7_pkg.check_primary(X_person_id => X_person_id
135: ,X_primary_flag => X_primary_flag);
136: --
137: hr_utility.set_location('per_assignments_v7_pkg.insert_row',60);
138: INSERT INTO PER_ASSIGNMENTS_F(
139: assignment_id,
140: effective_start_date,
141: effective_end_date,
142: business_group_id,

Line 410: FROM PER_ASSIGNMENTS_F

406: X_Title VARCHAR2
407: ) IS
408: CURSOR C IS
409: SELECT *
410: FROM PER_ASSIGNMENTS_F
411: WHERE rowid = X_Rowid
412: FOR UPDATE of Assignment_Id NOWAIT;
413: Recinfo C%ROWTYPE;
414: BEGIN

Line 794: UPDATE PER_ASSIGNMENTS_F

790: close org;
791: end if;
792: --
793: hr_utility.set_location('per_assignments_v7_pkg.update_row',50);
794: UPDATE PER_ASSIGNMENTS_F
795: SET
796: assignment_id = X_Assignment_Id,
797: effective_start_date = X_Effective_Start_Date,
798: effective_end_date = X_Effective_End_Date,

Line 901: DELETE FROM PER_ASSIGNMENTS_F

897: END Update_Row;
898: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
899: BEGIN
900: hr_utility.set_location('per_assignments_v7_pkg.delete_row',10);
901: DELETE FROM PER_ASSIGNMENTS_F
902: WHERE rowid = X_Rowid;
903: if (SQL%NOTFOUND) then
904: RAISE NO_DATA_FOUND;
905: end if;

Line 1063: per_assignments_f

1059: is
1060: select 'Y'
1061: from sys.dual
1062: where exists (select 1 from
1063: per_assignments_f
1064: where person_id =X_person_id
1065: and sysdate between effective_start_date
1066: and effective_end_date);
1067: --

Line 1087: from per_assignments_f p

1083: ,X_current_application_id NUMBER DEFAULT NULL) is
1084: --
1085: cursor get_previous_changes is
1086: select 'Y'
1087: from per_assignments_f p
1088: where p.effective_start_date < x_effective_start_date
1089: and p.effective_end_date <> hr_general.end_of_time
1090: and p.assignment_id = x_assignment_id
1091: and p.effective_start_date = (select max(p1.effective_start_date)

Line 1092: from per_assignments_f p1

1088: where p.effective_start_date < x_effective_start_date
1089: and p.effective_end_date <> hr_general.end_of_time
1090: and p.assignment_id = x_assignment_id
1091: and p.effective_start_date = (select max(p1.effective_start_date)
1092: from per_assignments_f p1
1093: where p1.assignment_id = p.assignment_id);
1094: --
1095: l_dummy VARCHAR2(1);
1096: --

Line 1116: from per_assignments_f p

1112: ,x_effective_start_date DATE
1113: ,x_current_application_id NUMBER DEFAULT NULL) is
1114: cursor get_future_changes is
1115: select 'Y'
1116: from per_assignments_f p
1117: where trunc(p.effective_start_date) > trunc(x_effective_start_date) -- #1862029
1118: and p.assignment_id = x_assignment_id;
1119: --
1120: l_dummy VARCHAR2(1);