PACKAGE: APPS.IGS_CA_DA_CAT_PKG

Source

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