PACKAGE: APPS.IGS_FI_ENCMB_TYPE_PKG

Source

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