[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;