PACKAGE: APPS.IGS_FI_FEE_TRG_GRP_PKG

Source

1 package IGS_FI_FEE_TRG_GRP_PKG AUTHID CURRENT_USER AS
2     /* $Header: IGSSI36S.pls 115.4 2003/02/12 10:14:30 shtatiko ship $*/
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_FEE_CAT in VARCHAR2,
6   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
7   X_FEE_CAL_TYPE in VARCHAR2,
8   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
9   X_FEE_TYPE in VARCHAR2,
10   X_DESCRIPTION in VARCHAR2,
11   X_LOGICAL_DELETE_DT in DATE,
12   X_COMMENTS in VARCHAR2,
13   X_MODE in VARCHAR2 default 'R'
14   );
15 procedure LOCK_ROW (
16   X_ROWID in VARCHAR2,
17   X_FEE_CAT in VARCHAR2,
18   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
19   X_FEE_CAL_TYPE in VARCHAR2,
20   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
21   X_FEE_TYPE in VARCHAR2,
22   X_DESCRIPTION in VARCHAR2,
23   X_LOGICAL_DELETE_DT in DATE,
24   X_COMMENTS in VARCHAR2
25 );
26 procedure UPDATE_ROW (
27   X_ROWID in VARCHAR2,
28   X_FEE_CAT in VARCHAR2,
29   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
30   X_FEE_CAL_TYPE in VARCHAR2,
31   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
32   X_FEE_TYPE in VARCHAR2,
33   X_DESCRIPTION in VARCHAR2,
34   X_LOGICAL_DELETE_DT in DATE,
35   X_COMMENTS in VARCHAR2,
36   X_MODE in VARCHAR2 default 'R'
37   );
38 procedure ADD_ROW (
39   X_ROWID in out NOCOPY VARCHAR2,
40   X_FEE_CAT in VARCHAR2,
41   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
42   X_FEE_CAL_TYPE in VARCHAR2,
43   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
44   X_FEE_TYPE in VARCHAR2,
45   X_DESCRIPTION in VARCHAR2,
46   X_LOGICAL_DELETE_DT in DATE,
47   X_COMMENTS in VARCHAR2,
48   X_MODE in VARCHAR2 default 'R'
49   );
50 procedure DELETE_ROW (
51   X_ROWID in VARCHAR2
52 );
53 
54   FUNCTION Get_PK_For_Validation (
55     x_fee_cat IN VARCHAR2,
56     x_fee_cal_type IN VARCHAR2,
57     x_fee_ci_sequence_number IN NUMBER,
58     x_fee_type IN VARCHAR2,
59     x_fee_trigger_group_number IN NUMBER
60     ) RETURN BOOLEAN;
61 
62  PROCEDURE Check_Constraints (
63 	 Column_Name	IN	VARCHAR2	DEFAULT NULL,
64 	 Column_Value 	IN	VARCHAR2	DEFAULT NULL
65  );
66    PROCEDURE Before_DML (
67       p_action IN VARCHAR2,
68       x_rowid IN  VARCHAR2 DEFAULT NULL,
69       x_fee_trigger_group_number IN NUMBER DEFAULT NULL,
70       x_description IN VARCHAR2 DEFAULT NULL,
71       x_logical_delete_dt IN DATE DEFAULT NULL,
72       x_comments IN VARCHAR2 DEFAULT NULL,
73       x_fee_cat IN VARCHAR2 DEFAULT NULL,
74       x_fee_cal_type IN VARCHAR2 DEFAULT NULL,
75       x_fee_ci_sequence_number IN NUMBER DEFAULT NULL,
76       x_fee_type IN VARCHAR2 DEFAULT NULL,
77       x_creation_date IN DATE DEFAULT NULL,
78       x_created_by IN NUMBER DEFAULT NULL,
79       x_last_update_date IN DATE DEFAULT NULL,
80       x_last_updated_by IN NUMBER DEFAULT NULL,
81       x_last_update_login IN NUMBER DEFAULT NULL
82    ) ;
83 end IGS_FI_FEE_TRG_GRP_PKG;