PACKAGE: APPS.IGS_FI_ENC_DFLT_EFT_PKG

Source

1 package IGS_FI_ENC_DFLT_EFT_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSSI16S.pls 115.5 2003/02/19 05:44:50 adhawan ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_ENCUMBRANCE_TYPE in VARCHAR2,
7   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
8   X_COMMENTS in VARCHAR2,
9   X_MODE in VARCHAR2 default 'R'
10   );
11 
12 procedure LOCK_ROW (
13   X_ROWID in VARCHAR2,
14   X_ENCUMBRANCE_TYPE in VARCHAR2,
15   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
16   X_COMMENTS in VARCHAR2
17 );
18 procedure UPDATE_ROW (
19   X_ROWID in VARCHAR2,
20   X_ENCUMBRANCE_TYPE in VARCHAR2,
21   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
22   X_COMMENTS in VARCHAR2,
23   X_MODE in VARCHAR2 default 'R'
24   );
25 procedure ADD_ROW (
26   X_ROWID in out NOCOPY VARCHAR2,
27   X_ENCUMBRANCE_TYPE in VARCHAR2,
28   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
29   X_COMMENTS in VARCHAR2,
30   X_MODE in VARCHAR2 default 'R'
31   );
32 procedure DELETE_ROW (
33    X_ROWID in VARCHAR2
34 );
35 
36 PROCEDURE GET_FK_IGS_FI_ENCMB_TYPE (
37     x_encumbrance_type IN VARCHAR2
38     );
39 
40 Function GET_PK_For_Validation (
41     x_encumbrance_type IN VARCHAR2,
42     x_s_encmb_effect_type IN VARCHAR2
43     )
44 return Boolean;
45 Procedure Check_Constraints (
46 	Column_name 	IN	VARCHAR2 DEFAULT NULL,
47 	COLUMN_VALUE	IN	VARCHAR2 DEFAULT NULL
48 );
49   PROCEDURE Before_DML (
50     p_action IN VARCHAR2,
51     x_rowid IN VARCHAR2 DEFAULT NULL,
52     x_encumbrance_type IN VARCHAR2 DEFAULT NULL,
53     x_s_encmb_effect_type IN VARCHAR2 DEFAULT NULL,
54     x_comments IN VARCHAR2 DEFAULT NULL,
55     x_creation_date IN DATE DEFAULT NULL,
56     x_created_by IN NUMBER DEFAULT NULL,
57     x_last_update_date IN DATE DEFAULT NULL,
58     x_last_updated_by IN NUMBER DEFAULT NULL,
59     x_last_update_login IN NUMBER DEFAULT NULL
60   ) ;
61 
62 end IGS_FI_ENC_DFLT_EFT_PKG;