1 package IGS_FI_FEE_AS_RT_PKG as
2 /* $Header: IGSSI20S.pls 120.0 2005/06/01 18:39:05 appldev noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_PERSON_ID in NUMBER,
7 X_COURSE_CD in VARCHAR2,
8 X_FEE_TYPE in VARCHAR2,
9 X_START_DT in DATE,
10 X_END_DT in DATE,
11 X_LOCATION_CD in VARCHAR2,
12 X_ATTENDANCE_TYPE in VARCHAR2,
13 X_ATTENDANCE_MODE in VARCHAR2,
14 X_CHG_RATE in NUMBER,
15 X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
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_COURSE_CD in VARCHAR2,
22 X_FEE_TYPE in VARCHAR2,
23 X_START_DT in DATE,
24 X_END_DT in DATE,
25 X_LOCATION_CD in VARCHAR2,
26 X_ATTENDANCE_TYPE in VARCHAR2,
27 X_ATTENDANCE_MODE in VARCHAR2,
28 X_CHG_RATE in NUMBER,
29 X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2
30 );
31 procedure UPDATE_ROW (
32 X_ROWID in VARCHAR2,
33 X_PERSON_ID in NUMBER,
34 X_COURSE_CD in VARCHAR2,
35 X_FEE_TYPE in VARCHAR2,
36 X_START_DT in DATE,
37 X_END_DT in DATE,
38 X_LOCATION_CD in VARCHAR2,
39 X_ATTENDANCE_TYPE in VARCHAR2,
40 X_ATTENDANCE_MODE in VARCHAR2,
41 X_CHG_RATE in NUMBER,
42 X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
43 X_MODE in VARCHAR2 default 'R'
44 );
45 procedure ADD_ROW (
46 X_ROWID in OUT NOCOPY VARCHAR2,
47 X_PERSON_ID in NUMBER,
48 X_COURSE_CD in VARCHAR2,
49 X_FEE_TYPE in VARCHAR2,
50 X_START_DT in DATE,
51 X_END_DT in DATE,
52 X_LOCATION_CD in VARCHAR2,
53 X_ATTENDANCE_TYPE in VARCHAR2,
54 X_ATTENDANCE_MODE in VARCHAR2,
55 X_CHG_RATE in NUMBER,
56 X_LOWER_NRML_RATE_OVRD_IND in VARCHAR2,
57 X_MODE in VARCHAR2 default 'R'
58 );
59 procedure DELETE_ROW (
60 X_ROWID in VARCHAR2,
61 x_mode IN VARCHAR2 DEFAULT 'R'
62 );
63 Function GET_PK_For_Validation (
64 x_person_id IN NUMBER,
65 x_course_cd IN VARCHAR2,
66 x_fee_type IN VARCHAR2,
67 x_start_dt IN DATE
68 )
69 return Boolean;
70 Procedure Check_Constraints (
71 Column_name IN VARCHAR2 DEFAULT NULL,
72 COLUMN_VALUE IN VARCHAR2 DEFAULT NULL
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_course_cd IN VARCHAR2 DEFAULT NULL,
79 x_fee_type IN VARCHAR2 DEFAULT NULL,
80 x_start_dt IN DATE DEFAULT NULL,
81 x_end_dt IN DATE DEFAULT NULL,
82 x_location_cd IN VARCHAR2 DEFAULT NULL,
83 x_attendance_type IN VARCHAR2 DEFAULT NULL,
84 x_attendance_mode IN VARCHAR2 DEFAULT NULL,
85 x_chg_rate IN NUMBER DEFAULT NULL,
86 x_lower_nrml_rate_ovrd_ind IN VARCHAR2 DEFAULT NULL,
87 x_creation_date IN DATE DEFAULT NULL,
88 x_created_by IN NUMBER DEFAULT NULL,
89 x_last_update_date IN DATE DEFAULT NULL,
90 x_last_updated_by IN NUMBER DEFAULT NULL,
91 x_last_update_login IN NUMBER DEFAULT NULL
92 ) ;
93 PROCEDURE GET_FK_IGS_EN_ATD_MODE (
94 x_attendance_mode IN VARCHAR2
95 );
96 PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
97 x_attendance_type IN VARCHAR2
98 );
99 PROCEDURE GET_FK_IGS_AD_LOCATION (
100 x_location_cd IN VARCHAR2
101 );
102 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
103 x_person_id IN NUMBER,
104 x_course_cd IN VARCHAR2
105 );
106 end IGS_FI_FEE_AS_RT_PKG;