PACKAGE: APPS.IGS_PE_COURSE_EXCL_PKG

Source

1 package IGS_PE_COURSE_EXCL_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSNI13S.pls 115.3 2002/11/29 01:17:17 nsidana 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_CD in VARCHAR2,
14   X_PCE_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_CD in VARCHAR2,
27   X_PCE_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_CD in VARCHAR2,
39   X_PCE_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_CD in VARCHAR2,
52   X_PCE_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   FUNCTION Get_PK_For_Validation (
60     x_person_id IN NUMBER,
61     x_encumbrance_type IN VARCHAR2,
62     x_pen_start_dt IN DATE,
63     x_s_encmb_effect_type IN VARCHAR2,
64     x_pee_start_dt IN DATE,
65     x_pee_sequence_number IN NUMBER,
66     x_course_cd IN VARCHAR2,
67     x_pce_start_dt IN DATE
68     ) RETURN BOOLEAN ;
69 
70   PROCEDURE GET_FK_IGS_PS_COURSE (
71     x_course_cd IN VARCHAR2
72     );
73 
74   PROCEDURE GET_FK_IGS_PE_PERSENC_EFFCT (
75     x_person_id IN NUMBER,
76     x_encumbrance_type IN VARCHAR2,
77     x_pen_start_dt IN DATE,
78     x_s_encmb_effect_type IN VARCHAR2,
79     x_pee_start_dt IN DATE,
80     x_pee_sequence_number IN NUMBER
81     );
82  PROCEDURE Check_Constraints (
83  Column_Name	IN	VARCHAR2	DEFAULT NULL,
84  Column_Value 	IN	VARCHAR2	DEFAULT NULL
85  );
86 PROCEDURE Before_DML (
87     p_action IN VARCHAR2,
88     x_rowid IN VARCHAR2 DEFAULT NULL,
89     x_person_id IN NUMBER DEFAULT NULL,
90     x_encumbrance_type IN VARCHAR2 DEFAULT NULL,
91     x_pen_start_dt IN DATE DEFAULT NULL,
92     x_s_encmb_effect_type IN VARCHAR2 DEFAULT NULL,
93     x_pee_start_dt IN DATE DEFAULT NULL,
94     x_pee_sequence_number IN NUMBER DEFAULT NULL,
95     x_course_cd IN VARCHAR2 DEFAULT NULL,
96     x_pce_start_dt IN DATE DEFAULT NULL,
97     x_expiry_dt IN DATE DEFAULT NULL,
98     x_creation_date IN DATE DEFAULT NULL,
99     x_created_by IN NUMBER DEFAULT NULL,
100     x_last_update_date IN DATE DEFAULT NULL,
101     x_last_updated_by IN NUMBER DEFAULT NULL,
102     x_last_update_login IN NUMBER DEFAULT NULL
103   );
104 
105 end IGS_PE_COURSE_EXCL_PKG;