PACKAGE: APPS.CE_CASHFLOWS_PKG

Source

1 PACKAGE CE_CASHFLOWS_PKG AUTHID CURRENT_USER as
2 /* $Header: cebtcths.pls 120.0 2005/07/26 08:44:18 jikumar noship $ */
3 
4 
5   G_spec_revision 	VARCHAR2(1000) := '$Revision: 120.0 $';
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_CASHFLOW_ID					IN OUT NOCOPY NUMBER,
14 			X_CASHFLOW_LEDGER_ID 			NUMBER,
15 			X_CASHFLOW_LEGAL_ENTITY_ID		NUMBER,
16 			X_CASHFLOW_BANK_ACCOUNT_ID		NUMBER,
17 			X_CASHFLOW_DIRECTION			VARCHAR2,
18 			X_CASHFLOW_CURRENCY_CODE		VARCHAR2,
19 			X_CASHFLOW_DATE					DATE,
20 			X_CASHFLOW_AMOUNT				NUMBER,
21 			X_BASE_AMOUNT					NUMBER,
22 			X_DESCRIPTION					VARCHAR2,
23 			X_CASHFLOW_EXCHANGE_RATE		NUMBER,
24 			X_CASHFLOW_EXCHANGE_DATE		DATE,
25 			X_CASHFLOW_EXCHANGE_RATE_TYPE	VARCHAR2,
26 			X_TRXN_REFERENCE_NUMBER			NUMBER,
27 			X_BANK_TRXN_NUMBER				VARCHAR2,
28 			X_SOURCE_TRXN_TYPE				VARCHAR2,
29 			X_SOURCE_TRXN_SUBTYPE_CODE_ID	VARCHAR2,
30 			X_STATEMENT_LINE_ID				NUMBER,
31 			X_ACTUAL_VALUE_DATE				DATE,
32 			X_COUNTERPARTY_PARTY_ID			NUMBER,
33 			X_COUNTERPARTY_BANK_ACCOUNT_ID	NUMBER,
34 			X_OFFSET_CCID					NUMBER,
35 			X_CASHFLOW_STATUS_CODE			VARCHAR2,
36 			X_CLEARED_DATE					DATE,
37 			X_CLEARED_AMOUNT				NUMBER,
38 			X_CLEARED_EXCHANGE_RATE			NUMBER,
39 			X_CLEARED_EXCHANGE_DATE			DATE,
40 			X_CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2,
41 			X_CLEARING_CHARGES_AMOUNT		NUMBER,
42 			X_CLEARING_ERROR_AMOUNT			NUMBER,
43 			X_CLEARED_BY_FLAG				VARCHAR2,
44 			X_REFERENCE_TEXT				VARCHAR2,
45 			X_BANK_ACCOUNT_TEXT				VARCHAR2,
46 			X_CUSTOMER_TEXT					VARCHAR2,
47 			X_CREATED_BY					NUMBER,
48 			X_CREATION_DATE					DATE,
49 			X_LAST_UPDATED_BY				NUMBER,
50 			X_LAST_UPDATE_DATE				DATE,
51 			X_LAST_UPDATE_LOGIN				NUMBER
52 			);
53 
54 
55 
56 PROCEDURE UPDATE_ROW (
57 			X_ROWID							VARCHAR2,
58 			X_CASHFLOW_ID					NUMBER,
59 			X_CASHFLOW_LEDGER_ID			NUMBER,
60 			X_CASHFLOW_LEGAL_ENTITY_ID		NUMBER,
61 			X_CASHFLOW_BANK_ACCOUNT_ID		NUMBER,
62 			X_CASHFLOW_DIRECTION			VARCHAR2,
63 			X_CASHFLOW_CURRENCY_CODE		VARCHAR2,
64 			X_CASHFLOW_DATE					DATE,
65 			X_CASHFLOW_AMOUNT				NUMBER,
66 			X_BASE_AMOUNT					NUMBER,
67 			X_DESCRIPTION					VARCHAR2,
68 			X_CASHFLOW_EXCHANGE_RATE		NUMBER,
69 			X_CASHFLOW_EXCHANGE_DATE		DATE,
70 			X_CASHFLOW_EXCHANGE_RATE_TYPE	VARCHAR2,
71 			X_TRXN_REFERENCE_NUMBER			NUMBER,
72 			X_BANK_TRXN_NUMBER				NUMBER,
73 			X_SOURCE_TRXN_TYPE				VARCHAR2,
74 			X_SOURCE_TRXN_SUBTYPE_CODE_ID	VARCHAR2,
75 			X_STATEMENT_LINE_ID				NUMBER,
76 			X_ACTUAL_VALUE_DATE				DATE,
77 			X_COUNTERPARTY_PARTY_ID			NUMBER,
78 			X_COUNTERPARTY_BANK_ACCOUNT_ID	NUMBER,
79 			X_OFFSET_CCID					NUMBER,
80 			X_CASHFLOW_STATUS_CODE			VARCHAR2,
81 			X_CLEARED_DATE					DATE,
82 			X_CLEARED_AMOUNT				NUMBER,
83 			X_CLEARED_EXCHANGE_RATE			NUMBER,
84 			X_CLEARED_EXCHANGE_DATE			DATE,
85 			X_CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2,
86 			X_CLEARING_CHARGES_AMOUNT		NUMBER,
87 			X_CLEARING_ERROR_AMOUNT			NUMBER,
88 			X_CLEARED_BY_FLAG				VARCHAR2,
89 			X_REFERENCE_TEXT				VARCHAR2,
90 			X_BANK_ACCOUNT_TEXT				VARCHAR2,
91 			X_CUSTOMER_TEXT					VARCHAR2,
92 			X_LAST_UPDATED_BY				NUMBER,
93 			X_LAST_UPDATE_DATE				DATE,
94 			X_LAST_UPDATE_LOGIN				NUMBER,
95 			X_OBJECT_VERSION_NUMBER			NUMBER  );
96 
97 PROCEDURE Delete_Row( X_Row_id VARCHAR2 );
98 
99 END CE_CASHFLOWS_PKG;