PACKAGE: APPS.IGS_FI_FEE_STR_STAT_PKG

Source

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