19: 23/11/94 70.4 rfine Suppressed index on business_group_id
20: 31/01/95 70.6 JRhodes Removed AOL WHO Columns
21: 21/07/95 70.7 aforte Replaced tokenised messages, ALL_MANDATORY_FIELD amills with hard coded messages ALL_MAN_HOU_FIELD
22: ALL_MAN_INC_FIELD and ALL_MAN_VAL_FIELD.
23: 04/03/97 70.8 JAlloun Changed all occurances of system.dual
24: to sys.dual for next release requirements.
25: ---------------------------------------------------------------------------*/
26: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
27: X_Absence_Attendance_Type_Id IN OUT NUMBER,
20: 31/01/95 70.6 JRhodes Removed AOL WHO Columns
21: 21/07/95 70.7 aforte Replaced tokenised messages, ALL_MANDATORY_FIELD amills with hard coded messages ALL_MAN_HOU_FIELD
22: ALL_MAN_INC_FIELD and ALL_MAN_VAL_FIELD.
23: 04/03/97 70.8 JAlloun Changed all occurances of system.dual
24: to sys.dual for next release requirements.
25: ---------------------------------------------------------------------------*/
26: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
27: X_Absence_Attendance_Type_Id IN OUT NUMBER,
28: X_Business_Group_Id NUMBER,
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: --
72: per_abt_pkg.check_unique_name(X_Rowid