PACKAGE: APPS.IGS_RE_CDT_ATT_HIST_PKG

Source

1 package  IGS_RE_CDT_ATT_HIST_PKG as
2 /* $Header: IGSRI03S.pls 120.0 2005/06/01 20:08:06 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSON_ID in NUMBER,
6   X_CA_SEQUENCE_NUMBER in NUMBER,
7   X_SEQUENCE_NUMBER in NUMBER,
8   X_HIST_START_DT in DATE,
9   X_HIST_END_DT in DATE,
10   X_ATTENDANCE_TYPE in VARCHAR2,
11   X_ATTENDANCE_PERCENTAGE in NUMBER,
12   X_MODE in VARCHAR2 default 'R' ,
13   X_ORG_ID IN NUMBER
14   );
15 procedure LOCK_ROW (
16   X_ROWID in VARCHAR2,
17   X_PERSON_ID in NUMBER,
18   X_CA_SEQUENCE_NUMBER in NUMBER,
19   X_SEQUENCE_NUMBER in NUMBER,
20   X_HIST_START_DT in DATE,
21   X_HIST_END_DT in DATE,
22   X_ATTENDANCE_TYPE in VARCHAR2,
23   X_ATTENDANCE_PERCENTAGE in NUMBER
24 );
25 procedure UPDATE_ROW (
26   X_ROWID in VARCHAR2,
27   X_PERSON_ID in NUMBER,
28   X_CA_SEQUENCE_NUMBER in NUMBER,
29   X_SEQUENCE_NUMBER in NUMBER,
30   X_HIST_START_DT in DATE,
31   X_HIST_END_DT in DATE,
32   X_ATTENDANCE_TYPE in VARCHAR2,
33   X_ATTENDANCE_PERCENTAGE in NUMBER,
34   X_MODE in VARCHAR2 default 'R'
35   );
36 procedure ADD_ROW (
37   X_ROWID in out NOCOPY VARCHAR2,
38   X_PERSON_ID in NUMBER,
39   X_CA_SEQUENCE_NUMBER in NUMBER,
40   X_SEQUENCE_NUMBER in NUMBER,
41   X_HIST_START_DT in DATE,
42   X_HIST_END_DT in DATE,
43   X_ATTENDANCE_TYPE in VARCHAR2,
44   X_ATTENDANCE_PERCENTAGE in NUMBER,
45   X_MODE in VARCHAR2 default 'R',
46   X_ORG_ID IN NUMBER
47   );
48 procedure DELETE_ROW (
49   X_ROWID in VARCHAR2,
50   x_mode IN VARCHAR2 DEFAULT 'R'
51   );
52 
53   FUNCTION Get_PK_For_Validation (
54     x_person_id IN NUMBER,
55     x_ca_sequence_number IN NUMBER,
56     x_sequence_number IN NUMBER
57     )
58    RETURN BOOLEAN;
59 
60   PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
61     x_attendance_type IN VARCHAR2
62     );
63 
64   PROCEDURE GET_FK_IGS_RE_CANDIDATURE (
65     x_person_id IN NUMBER,
66     x_sequence_number IN NUMBER
67     );
68 
69   PROCEDURE Check_Constraints (
70   Column_Name in VARCHAR2 DEFAULT NULL ,
71   Column_Value in VARCHAR2 DEFAULT NULL
72   );
73 
74   PROCEDURE Before_DML (
75     p_action IN VARCHAR2,
76     x_rowid IN VARCHAR2 DEFAULT NULL,
77     x_person_id IN NUMBER DEFAULT NULL,
78     x_ca_sequence_number IN NUMBER DEFAULT NULL,
79     x_sequence_number IN NUMBER DEFAULT NULL,
80     x_hist_start_dt IN DATE DEFAULT NULL,
81     x_hist_end_dt IN DATE DEFAULT NULL,
82     x_attendance_type IN VARCHAR2 DEFAULT NULL,
83     x_attendance_percentage IN NUMBER DEFAULT NULL,
84     x_creation_date IN DATE DEFAULT NULL,
85     x_created_by IN NUMBER DEFAULT NULL,
86     x_last_update_date IN DATE DEFAULT NULL,
87     x_last_updated_by IN NUMBER DEFAULT NULL,
88     x_last_update_login IN NUMBER DEFAULT NULL,
89     X_ORG_ID IN NUMBER DEFAULT NULL
90   ) ;
91 
92 
93 end IGS_RE_CDT_ATT_HIST_PKG;