PACKAGE: APPS.CE_CASHFLOW_HIST_PKG

Source

1 PACKAGE CE_CASHFLOW_HIST_PKG AUTHID CURRENT_USER as
2 /* $Header: cebtaths.pls 120.2 2005/08/03 05:21:31 jikumar noship $ */
3 
4 
5   G_spec_revision 	VARCHAR2(1000) := '$Revision: 120.2 $';
6 
7   FUNCTION spec_revision RETURN VARCHAR2;
8 
9   FUNCTION body_revision RETURN VARCHAR2;
10 
11 PROCEDURE INSERT_ROW (
12 			X_ROWID				 	IN OUT NOCOPY VARCHAR2,
13 			X_EVENT_ID				NUMBER,
14 			X_CASHFLOW_ID			NUMBER,
15 			X_EVENT_TYPE			VARCHAR2,
16 			X_ACCOUNTING_DATE		DATE,
17 			X_STATUS_CODE			VARCHAR2,
18 			X_CURR_RECORD_FLAG		VARCHAR2,
19 			X_CLEARED_DATE			DATE,
20 			X_CLEARED_AMOUNT		NUMBER,
21 			X_CLEARED_EXCH_RATE		NUMBER,
22 			X_CLEARED_EXCH_DATE		DATE,
23 			X_CLEARED_EXCH_TYPE		VARCHAR2,
24 			X_CLEARING_CHRG_AMT		NUMBER,
25 			X_CLEARING_ERR_AMT		NUMBER,
26 			X_REV_IND_FLAG			VARCHAR2,
27 			X_REV_FIRST_DIST_ID		NUMBER,
28 			X_REV_SECOND_DIST_NUM	VARCHAR2,
29 			X_CREATED_BY			NUMBER,
30 			X_CREATION_DATE			DATE,
31 			X_LAST_UPDATED_BY		NUMBER,
32 			X_LAST_UPDATE_DATE		DATE,
33 			X_LAST_UPDATE_LOGIN		NUMBER
34 			 );
35 
36 
37 
38 PROCEDURE UPDATE_ROW (
39 			X_ROWID					VARCHAR2,
40 			X_CASHFLOW_ID			NUMBER,
41 			X_EVENT_ID				NUMBER,
42 			X_EVENT_TYPE			VARCHAR2,
43 			X_ACCOUNTING_DATE		DATE,
44 			X_STATUS_CODE			VARCHAR2,
45 			X_CURR_RECORD_FLAG		VARCHAR2,
46 			X_CLEARED_DATE			DATE,
47 			X_CLEARED_AMOUNT		NUMBER,
48 			X_CLEARED_EXCH_RATE		NUMBER,
49 			X_CLEARED_EXCH_DATE		DATE,
50 			X_CLEARED_EXCH_TYPE		VARCHAR2,
51 			X_CLEARING_CHRG_AMT		NUMBER,
52 			X_CLEARING_ERR_AMT		NUMBER,
53 			X_REV_IND_FLAG			VARCHAR2,
54 			X_REV_FIRST_DIST_ID		NUMBER,
55 			X_REV_SECOND_DIST_NUM	VARCHAR2,
56 			X_LAST_UPDATED_BY		NUMBER,
57 			X_LAST_UPDATE_DATE		DATE,
58 			X_LAST_UPDATE_LOGIN		NUMBER,
59 			X_OBJECT_VERSION_NUMBER	NUMBER  );
60 
61 PROCEDURE Delete_Row( X_Row_id VARCHAR2 );
62 
63 END CE_CASHFLOW_HIST_PKG;