PACKAGE: APPS.IGS_FI_FEE_TYPE_PKG

Source

1 package IGS_FI_FEE_TYPE_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSSI37S.pls 115.10 2003/06/13 14:05:27 shtatiko ship $*/
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_FEE_TYPE in VARCHAR2,
7   X_S_FEE_TYPE in VARCHAR2,
8   X_S_FEE_TRIGGER_CAT in VARCHAR2,
9   X_DESCRIPTION in VARCHAR2,
10   X_OPTIONAL_PAYMENT_IND in VARCHAR2,
11   X_CLOSED_IND in VARCHAR2,
12   X_COMMENTS in VARCHAR2,
13   X_MODE in VARCHAR2 DEFAULT 'R',
14   X_ORG_ID in NUMBER,
15   X_FEE_CLASS in VARCHAR2 DEFAULT NULL,          --Bug 2175865
16   X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2 DEFAULT 'N'
17   );
18 procedure LOCK_ROW (
19   X_ROWID in VARCHAR2,
20   X_FEE_TYPE in VARCHAR2,
21   X_S_FEE_TYPE in VARCHAR2,
22   X_S_FEE_TRIGGER_CAT in VARCHAR2,
23   X_DESCRIPTION in VARCHAR2,
24   X_OPTIONAL_PAYMENT_IND in VARCHAR2,
25   X_CLOSED_IND in VARCHAR2,
26   X_COMMENTS in VARCHAR2,
27   X_FEE_CLASS in VARCHAR2 DEFAULT NULL,          --Bug 2175865
28   X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2 DEFAULT 'N'
29 );
30 procedure UPDATE_ROW (
31   X_ROWID in VARCHAR2,
32   X_FEE_TYPE in VARCHAR2,
33   X_S_FEE_TYPE in VARCHAR2,
34   X_S_FEE_TRIGGER_CAT in VARCHAR2,
35   X_DESCRIPTION in VARCHAR2,
36   X_OPTIONAL_PAYMENT_IND in VARCHAR2,
37   X_CLOSED_IND in VARCHAR2,
38   X_COMMENTS in VARCHAR2,
39   X_MODE in VARCHAR2 DEFAULT 'R',
40   X_FEE_CLASS in VARCHAR2 DEFAULT NULL,          --Bug 2175865
41   X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2 DEFAULT 'N'
42   );
43 procedure ADD_ROW (
44   X_ROWID in out NOCOPY VARCHAR2,
45   X_FEE_TYPE in VARCHAR2,
46   X_S_FEE_TYPE in VARCHAR2,
47   X_S_FEE_TRIGGER_CAT in VARCHAR2,
48   X_DESCRIPTION in VARCHAR2,
49   X_OPTIONAL_PAYMENT_IND in VARCHAR2,
50   X_CLOSED_IND in VARCHAR2,
51   X_COMMENTS in VARCHAR2,
52   X_MODE in VARCHAR2 DEFAULT 'R',
53   X_ORG_ID in NUMBER,
54   X_FEE_CLASS in VARCHAR2 DEFAULT NULL,          --Bug 2175865
55   X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2 DEFAULT 'N'
56   );
57 
58 FUNCTION Get_PK_For_Validation (
59     x_fee_type IN VARCHAR2
60     ) RETURN BOOLEAN;
61 
62 
63 --As part of Bug 2175865 by vvutukur
64 PROCEDURE check_parent_existance;
65 
66 PROCEDURE Check_Constraints (
67 	 Column_Name	IN	VARCHAR2	DEFAULT NULL,
68 	 Column_Value 	IN	VARCHAR2	DEFAULT NULL
69  );
70 PROCEDURE Before_DML (
71     p_action IN VARCHAR2,
72     x_rowid IN  VARCHAR2 DEFAULT NULL,
73     x_fee_type IN VARCHAR2 DEFAULT NULL,
74     x_s_fee_type IN VARCHAR2 DEFAULT NULL,
75     x_s_fee_trigger_cat IN VARCHAR2 DEFAULT NULL,
76     x_description IN VARCHAR2 DEFAULT NULL,
77     x_optional_payment_ind IN VARCHAR2 DEFAULT NULL,
78     x_closed_ind IN VARCHAR2 DEFAULT NULL,
79     x_comments IN VARCHAR2 DEFAULT NULL,
80     x_org_id IN NUMBER DEFAULT NULL,
81     x_fee_class IN VARCHAR2 DEFAULT NULL,       --Bug 2175865
82     x_designated_payment_flag IN VARCHAR2 DEFAULT 'N',
83     x_creation_date IN DATE DEFAULT NULL,
84     x_created_by IN NUMBER DEFAULT NULL,
85     x_last_update_date IN DATE DEFAULT NULL,
86     x_last_updated_by IN NUMBER DEFAULT NULL,
87     x_last_update_login IN NUMBER DEFAULT NULL
88   ) ;
89 end IGS_FI_FEE_TYPE_PKG;