DBA Data[Home] [Help]

PACKAGE: APPS.CE_CASHFLOW_PKG

Source


1 PACKAGE CE_CASHFLOW_PKG AUTHID CURRENT_USER AS
2 /* $Header: cecashps.pls 120.1.12010000.2 2009/11/24 11:26:52 bkkashya ship $ */
3 
4 --l_DEBUG varchar2(1);
5 PROCEDURE update_ce_cashflows(
6     	X_CASHFLOW_ID   		number,
7 	X_TRX_STATUS			varchar2,
8         X_actual_value_date  		date,
9         X_CLEARED_DATE          	date,
10         X_CLEARED_AMOUNT    		number,
11         X_CLEARED_ERROR_AMOUNT          number,
12         X_CLEARED_CHARGE_AMOUNT         number,
13         X_CLEARED_EXCHANGE_RATE_TYPE    varchar2,
14         X_CLEARED_EXCHANGE_RATE_DATE    date,
15         X_CLEARED_EXCHANGE_RATE         number,
16 	X_NEW_TRX_STATUS		varchar2,
17 	X_CLEARED_BY_FLAG		VARCHAR2,
18         X_LAST_UPDATE_DATE      	date,
19         X_LAST_UPDATED_BY       	number,
20         X_LAST_UPDATE_LOGIN     	number,
21 	X_STATEMENT_LINE_ID    		number,
22 	X_PASSIN_MODE			varchar2
23 	);
24 
25 PROCEDURE RAISE_ACCT_EVENT(
26 	 X_CASHFLOW_ID 			number,
27 	 X_ACCTG_EVENT 			varchar2,
28          X_ACCOUNTING_DATE 		date,
29  	 X_EVENT_STATUS_CODE		VARCHAR2,
30  	 X_EVENT_ID			IN OUT NOCOPY NUMBER);
31 
32 
33 PROCEDURE clear_cashflow (
34     	X_CASHFLOW_ID   		number,
35 	X_TRX_STATUS			varchar2,
36         X_actual_value_date  		date,
37         X_ACCOUNTING_DATE       	date,
38         X_CLEARED_DATE          	date,
39         X_CLEARED_AMOUNT    		number,
40         X_CLEARED_ERROR_AMOUNT          number,
41         X_CLEARED_CHARGE_AMOUNT         number,
42         X_CLEARED_EXCHANGE_RATE_TYPE    varchar2,
43         X_CLEARED_EXCHANGE_RATE_DATE    date,
44         X_CLEARED_EXCHANGE_RATE         number,
45 	X_PASSIN_MODE			varchar2,
46 	X_STATEMENT_LINE_ID		NUMBER,
47 	X_STATEMENT_LINE_TYPE		VARCHAR2
48         );
49 
50 PROCEDURE update_user_lines
51 (
52  X_WORKSHEET_HEADER_ID  IN NUMBER,
53  X_WORKSHEET_LINE_ID    IN NUMBER,
54  X_LINE_DESCRIPTION     IN VARCHAR2,
55  X_SOURCE_TYPE          IN VARCHAR2,
56  X_BANK_ACCOUNT_ID      IN NUMBER,
57  X_AS_OF_DATE           IN DATE,
58  X_AMOUNT               IN NUMBER
59 );
60 
61 END CE_CASHFLOW_PKG;