APPS.PER_ABT_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 63: SELECT rowid FROM PER_ABSENCE_ATTENDANCE_TYPES

59: X_Element_End_Date DATE,
60: X_END_OF_TIME DATE
61: ) IS
62: CURSOR C IS
63: SELECT rowid FROM PER_ABSENCE_ATTENDANCE_TYPES
64: WHERE absence_attendance_type_id = X_Absence_Attendance_Type_Id;
65: --
66: CURSOR C2 IS
67: SELECT per_absence_attendance_types_s.nextval

Line 67: SELECT per_absence_attendance_types_s.nextval

63: SELECT rowid FROM PER_ABSENCE_ATTENDANCE_TYPES
64: WHERE absence_attendance_type_id = X_Absence_Attendance_Type_Id;
65: --
66: CURSOR C2 IS
67: SELECT per_absence_attendance_types_s.nextval
68: FROM sys.dual;
69: BEGIN
70: -- check the uniqueness of the name
71: --

Line 96: INSERT INTO PER_ABSENCE_ATTENDANCE_TYPES(

92: OPEN C2;
93: FETCH C2 INTO X_Absence_Attendance_Type_Id;
94: CLOSE C2;
95: end if;
96: INSERT INTO PER_ABSENCE_ATTENDANCE_TYPES(
97: absence_attendance_type_id,
98: business_group_id,
99: input_value_id,
100: date_effective,

Line 213: FROM PER_ABSENCE_ATTENDANCE_TYPES

209: X_Attribute20 VARCHAR2
210: ) IS
211: CURSOR C IS
212: SELECT *
213: FROM PER_ABSENCE_ATTENDANCE_TYPES
214: WHERE rowid = X_Rowid
215: FOR UPDATE of Absence_Attendance_Type_Id NOWAIT;
216: Recinfo C%ROWTYPE;
217: --

Line 431: UPDATE PER_ABSENCE_ATTENDANCE_TYPES

427: if X_Name <> X_Old_Name then
428: hrdyndbi.delete_absence_dict(X_ABSENCE_ATTENDANCE_TYPE_ID);
429: end if;
430: --
431: UPDATE PER_ABSENCE_ATTENDANCE_TYPES
432: SET
433: absence_attendance_type_id = X_Absence_Attendance_Type_Id,
434: business_group_id = X_Business_Group_Id,
435: input_value_id = X_Input_Value_Id,

Line 490: DELETE FROM PER_ABSENCE_ATTENDANCE_TYPES

486: hr_utility.set_location('per_abt_pkg.delete_row',2);
487: hrdyndbi.delete_absence_dict(X_Absence_attendance_type_id);
488: --
489: hr_utility.set_location('per_abt_pkg.delete_row',3);
490: DELETE FROM PER_ABSENCE_ATTENDANCE_TYPES
491: WHERE rowid = X_Rowid;
492: --
493: if (SQL%NOTFOUND) then
494: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 508: from per_absence_attendance_types

504: ,p_name varchar2) is
505: --
506: cursor c is
507: select ''
508: from per_absence_attendance_types
509: where upper(p_name) = upper(name)
510: and business_group_id + 0 = p_business_group_id
511: and (rowidtochar(rowid) <> p_rowid or p_rowid is null);
512: abt_rec c%rowtype;

Line 604: from per_absence_attendance_types abt

600: IPV_REC2 c%rowtype;
601: --
602: cursor c1(l_input_value_id NUMBER) is
603: select ''
604: from per_absence_attendance_types abt
605: where abt.input_value_id = l_input_value_id
606: and p_rowid is not null
607: and chartorowid(p_rowid) <> abt.rowid;
608: --