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 141: INSERT INTO PER_ASSIGNMENTS_F(

137: ,X_eff_dt => X_Effective_Start_Date
138: ,X_primary_flag => X_primary_flag);
139: --
140: hr_utility.set_location('per_assignments_v7_pkg.insert_row',60);
141: INSERT INTO PER_ASSIGNMENTS_F(
142: assignment_id,
143: effective_start_date,
144: effective_end_date,
145: business_group_id,

Line 413: FROM PER_ASSIGNMENTS_F

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

Line 797: UPDATE PER_ASSIGNMENTS_F

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

Line 904: DELETE FROM PER_ASSIGNMENTS_F

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

Line 1068: per_assignments_f

1064: is
1065: select 'Y'
1066: from sys.dual
1067: where exists (select 1 from
1068: per_assignments_f
1069: where person_id =X_person_id
1070: and X_eff_dt between effective_start_date
1071: and effective_end_date);
1072: --

Line 1092: from per_assignments_f p

1088: ,X_current_application_id NUMBER DEFAULT NULL) is
1089: --
1090: cursor get_previous_changes is
1091: select 'Y'
1092: from per_assignments_f p
1093: where p.effective_start_date < x_effective_start_date
1094: and p.effective_end_date <> hr_general.end_of_time
1095: and p.assignment_id = x_assignment_id
1096: and p.effective_start_date = (select max(p1.effective_start_date)

Line 1097: from per_assignments_f p1

1093: where p.effective_start_date < x_effective_start_date
1094: and p.effective_end_date <> hr_general.end_of_time
1095: and p.assignment_id = x_assignment_id
1096: and p.effective_start_date = (select max(p1.effective_start_date)
1097: from per_assignments_f p1
1098: where p1.assignment_id = p.assignment_id);
1099: --
1100: l_dummy VARCHAR2(1);
1101: --

Line 1121: from per_assignments_f p

1117: ,x_effective_start_date DATE
1118: ,x_current_application_id NUMBER DEFAULT NULL) is
1119: cursor get_future_changes is
1120: select 'Y'
1121: from per_assignments_f p
1122: where trunc(p.effective_start_date) > trunc(x_effective_start_date) -- #1862029
1123: and p.assignment_id = x_assignment_id;
1124: --
1125: l_dummy VARCHAR2(1);