DBA Data[Home] [Help]

PACKAGE: APPS.PER_ABS_ATTENDANCE_REASONS_PKG

Source


1 PACKAGE PER_ABS_ATTENDANCE_REASONS_PKG AUTHID CURRENT_USER as
2 /* $Header: peaar01t.pkh 115.0 99/07/17 18:23:05 porting ship $ */
3 /*===========================================================================+
4  |               Copyright (c) 1993 Oracle Corporation                       |
5  |                  Redwood Shores, California, USA                          |
6  |                       All rights reserved.                                |
7  +===========================================================================*/
8 PROCEDURE Insert_Row(X_Rowid                         IN OUT VARCHAR2,
9                      X_Abs_Attendance_Reason_Id             IN OUT NUMBER,
10                      X_Business_Group_Id                    NUMBER,
11                      X_Absence_Attendance_Type_Id           NUMBER,
12                      X_Name                                 VARCHAR2,
13                      X_Last_Update_Date                     DATE,
14                      X_Last_Updated_By                      NUMBER,
15                      X_Last_Update_Login                    NUMBER,
16                      X_Created_By                           NUMBER,
17                      X_Creation_Date                        DATE
18                      );
19 --
20 PROCEDURE Lock_Row(X_Rowid                                  VARCHAR2,
21                    X_Abs_Attendance_Reason_Id               NUMBER,
22                    X_Business_Group_Id                      NUMBER,
23                    X_Absence_Attendance_Type_Id             NUMBER,
24                    X_Name                                   VARCHAR2
25                    );
26 --
27 PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
28                      X_Abs_Attendance_Reason_Id            NUMBER,
29                      X_Business_Group_Id                   NUMBER,
30                      X_Absence_Attendance_Type_Id          NUMBER,
31                      X_Name                                VARCHAR2,
32                      X_Last_Update_Date                    DATE,
33                      X_Last_Updated_By                     NUMBER,
34                      X_Last_Update_Login                   NUMBER
35                      );
36 --
37 PROCEDURE Delete_Row(X_Rowid VARCHAR2
38                     ,X_Abs_Attendance_Reason_Id NUMBER);
39 --
40 PROCEDURE Get_Name(X_CODE Varchar2
41                   ,X_MEANING IN OUT Varchar2);
42 --
43 PROCEDURE abr_del_validation(p_abs_attendance_reason_id NUMBER);
44 --
45 PROCEDURE check_unique_reason(p_rowid VARCHAR2
46                              ,p_name VARCHAR2
47                              ,p_absence_attendance_type_id NUMBER);
48 --
49 END PER_ABS_ATTENDANCE_REASONS_PKG;