PACKAGE: APPS.IGS_FI_FEE_TYPE_HIST_PKG

Source

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