PACKAGE: APPS.IGS_FI_FEE_CAT_MAP_PKG

Source

1 package IGS_FI_FEE_CAT_MAP_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSSI25S.pls 115.3 2002/11/29 03:44:34 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_FEE_CAT in VARCHAR2,
6   X_ADMISSION_CAT in VARCHAR2,
7   X_DFLT_CAT_IND in VARCHAR2,
8   X_MODE in VARCHAR2 default 'R'
9   );
10 procedure LOCK_ROW (
11   X_ROWID in VARCHAR2,
12   X_FEE_CAT in VARCHAR2,
13   X_ADMISSION_CAT in VARCHAR2,
14   X_DFLT_CAT_IND in VARCHAR2
15 );
16 procedure UPDATE_ROW (
17   X_ROWID in VARCHAR2,
18   X_FEE_CAT in VARCHAR2,
19   X_ADMISSION_CAT in VARCHAR2,
20   X_DFLT_CAT_IND in VARCHAR2,
21   X_MODE in VARCHAR2 default 'R'
22   );
23 procedure ADD_ROW (
24   X_ROWID in out NOCOPY VARCHAR2,
25   X_FEE_CAT in VARCHAR2,
26   X_ADMISSION_CAT in VARCHAR2,
27   X_DFLT_CAT_IND in VARCHAR2,
28   X_MODE in VARCHAR2 default 'R'
29   );
30 procedure DELETE_ROW (
31    X_ROWID in VARCHAR2
32 );
33   FUNCTION Get_PK_For_Validation (
34     x_fee_cat IN VARCHAR2,
35     x_admission_cat IN VARCHAR2
36     ) RETURN BOOLEAN;
37   PROCEDURE GET_FK_IGS_AD_CAT (
38     x_admission_cat IN VARCHAR2
39     );
40   PROCEDURE GET_FK_IGS_FI_FEE_CAT (
41     x_fee_cat IN VARCHAR2
42     );
43  PROCEDURE Check_Constraints (
44 	 Column_Name	IN	VARCHAR2	DEFAULT NULL,
45 	 Column_Value 	IN	VARCHAR2	DEFAULT NULL
46  );
47  PROCEDURE Before_DML (
48      p_action IN VARCHAR2,
49      x_rowid IN VARCHAR2 DEFAULT NULL,
50      x_fee_cat IN VARCHAR2 DEFAULT NULL,
51      x_admission_cat IN VARCHAR2 DEFAULT NULL,
52      x_dflt_cat_ind IN VARCHAR2 DEFAULT NULL,
53      x_creation_date IN DATE DEFAULT NULL,
54      x_created_by IN NUMBER DEFAULT NULL,
55      x_last_update_date IN DATE DEFAULT NULL,
56      x_last_updated_by IN NUMBER DEFAULT NULL,
57      x_last_update_login IN NUMBER DEFAULT NULL
58   );
59 end IGS_FI_FEE_CAT_MAP_PKG;