PACKAGE: APPS.IGS_PE_CRS_GRP_EXCL_PKG

Source

1 package IGS_PE_CRS_GRP_EXCL_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSNI14S.pls 115.4 2003/02/20 10:19:10 shtatiko ship $ */
3 
4 
5 procedure INSERT_ROW (
6   X_ROWID in out NOCOPY VARCHAR2,
7   X_PERSON_ID in NUMBER,
8   X_ENCUMBRANCE_TYPE in VARCHAR2,
9   X_PEN_START_DT in DATE,
10   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
11   X_PEE_START_DT in DATE,
12   X_PEE_SEQUENCE_NUMBER in NUMBER,
13   X_COURSE_GROUP_CD in VARCHAR2,
14   X_PCGE_START_DT in DATE,
15   X_EXPIRY_DT in DATE,
16   X_MODE in VARCHAR2 default 'R'
17   );
18 procedure LOCK_ROW (
19   X_ROWID in VARCHAR2,
20   X_PERSON_ID in NUMBER,
21   X_ENCUMBRANCE_TYPE in VARCHAR2,
22   X_PEN_START_DT in DATE,
23   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
24   X_PEE_START_DT in DATE,
25   X_PEE_SEQUENCE_NUMBER in NUMBER,
26   X_COURSE_GROUP_CD in VARCHAR2,
27   X_PCGE_START_DT in DATE,
28   X_EXPIRY_DT in DATE
29 );
30 procedure UPDATE_ROW (
31   X_ROWID in VARCHAR2,
32   X_PERSON_ID in NUMBER,
33   X_ENCUMBRANCE_TYPE in VARCHAR2,
34   X_PEN_START_DT in DATE,
35   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
36   X_PEE_START_DT in DATE,
37   X_PEE_SEQUENCE_NUMBER in NUMBER,
38   X_COURSE_GROUP_CD in VARCHAR2,
39   X_PCGE_START_DT in DATE,
40   X_EXPIRY_DT in DATE,
41   X_MODE in VARCHAR2 default 'R'
42   );
43 procedure ADD_ROW (
44   X_ROWID in out NOCOPY VARCHAR2,
45   X_PERSON_ID in NUMBER,
46   X_ENCUMBRANCE_TYPE in VARCHAR2,
47   X_PEN_START_DT in DATE,
48   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
49   X_PEE_START_DT in DATE,
50   X_PEE_SEQUENCE_NUMBER in NUMBER,
51   X_COURSE_GROUP_CD in VARCHAR2,
52   X_PCGE_START_DT in DATE,
53   X_EXPIRY_DT in DATE,
54   X_MODE in VARCHAR2 default 'R'
55   );
56 procedure DELETE_ROW (
57   X_ROWID in VARCHAR2
58 );
59 
60   FUNCTION Get_PK_For_Validation (
61     x_person_id IN NUMBER,
62     x_encumbrance_type IN VARCHAR2,
63     x_pen_start_dt IN DATE,
64     x_s_encmb_effect_type IN VARCHAR2,
65     x_pee_start_dt IN DATE,
66     x_pee_sequence_number IN NUMBER,
67     x_course_group_cd IN VARCHAR2,
68     x_pcge_start_dt IN DATE
69     ) RETURN BOOLEAN ;
70 
71   PROCEDURE GET_FK_IGS_PE_PERSENC_EFFCT (
72     x_person_id IN NUMBER,
73     x_encumbrance_type IN VARCHAR2,
74     x_pen_start_dt IN DATE,
75     x_s_encmb_effect_type IN VARCHAR2,
76     x_pee_start_dt IN DATE,
77     x_pee_sequence_number IN NUMBER
78     );
79  PROCEDURE Check_Constraints (
80  Column_Name	IN	VARCHAR2	DEFAULT NULL,
81  Column_Value 	IN	VARCHAR2	DEFAULT NULL
82  );
83 PROCEDURE Before_DML (
84     p_action IN VARCHAR2,
85     x_rowid IN  VARCHAR2 DEFAULT NULL,
86     x_person_id IN NUMBER DEFAULT NULL,
87     x_encumbrance_type IN VARCHAR2 DEFAULT NULL,
88     x_pen_start_dt IN DATE DEFAULT NULL,
89     x_s_encmb_effect_type IN VARCHAR2 DEFAULT NULL,
90     x_pee_start_dt IN DATE DEFAULT NULL,
91     x_pee_sequence_number IN NUMBER DEFAULT NULL,
92     x_course_group_cd IN VARCHAR2 DEFAULT NULL,
93     x_pcge_start_dt IN DATE DEFAULT NULL,
94     x_expiry_dt IN DATE DEFAULT NULL,
95     x_creation_date IN DATE DEFAULT NULL,
96     x_created_by IN NUMBER DEFAULT NULL,
97     x_last_update_date IN DATE DEFAULT NULL,
98     x_last_updated_by IN NUMBER DEFAULT NULL,
99     x_last_update_login IN NUMBER DEFAULT NULL
100   );
101 
102 end IGS_PE_CRS_GRP_EXCL_PKG;