1 PACKAGE CE_SYSTEM_PARAMETERS1_PKG AUTHID CURRENT_USER as
2 /* $Header: cesysp1s.pls 120.7 2008/01/23 13:21:23 kbabu ship $ */
3 G_spec_revision VARCHAR2(1000) := '$Revision: 120.7 $';
4
5 FUNCTION spec_revision RETURN VARCHAR2;
6
7 FUNCTION body_revision RETURN VARCHAR2;
8
9 PROCEDURE SELECT_COLUMNS
10 (X_ROWID IN OUT NOCOPY VARCHAR2,
11 X_SET_OF_BOOKS_ID IN OUT NOCOPY NUMBER,
12 X_CASHBOOK_BEGIN_DATE IN OUT NOCOPY DATE,
13 X_SHOW_CLEARED_FLAG IN OUT NOCOPY VARCHAR2,
14 X_SHOW_VOID_PAYMENT_FLAG IN OUT NOCOPY VARCHAR2,
15 X_LINE_AUTOCREATION_FLAG IN OUT NOCOPY VARCHAR2,
16 X_INTERFACE_PURGE_FLAG IN OUT NOCOPY VARCHAR2,
17 X_INTERFACE_ARCHIVE_FLAG IN OUT NOCOPY VARCHAR2,
18 X_LINES_PER_COMMIT IN OUT NOCOPY NUMBER,
19 X_FUNCTIONAL_CURRENCY IN OUT NOCOPY VARCHAR2,
20 X_SOB_SHORT_NAME IN OUT NOCOPY VARCHAR2,
21 X_ACCOUNT_PERIOD_TYPE IN OUT NOCOPY VARCHAR2,
22 X_USER_EXCHANGE_RATE_TYPE IN OUT NOCOPY VARCHAR2,
23 X_CHART_OF_ACCOUNTS_ID IN OUT NOCOPY NUMBER,
24 X_CASHFLOW_EXCHANGE_RATE_TYPE IN OUT NOCOPY VARCHAR2,
25 X_AUTHORIZATION_BAT IN OUT NOCOPY VARCHAR2,
26 X_BSC_EXCHANGE_DATE_TYPE IN OUT NOCOPY VARCHAR2,
27 X_BAT_EXCHANGE_DATE_TYPE IN OUT NOCOPY VARCHAR2,
28 X_LEGAL_ENTITY_ID IN OUT NOCOPY NUMBER);
29
30
31 PROCEDURE BA_SELECT_COLUMNS
32 (X_ROWID IN OUT NOCOPY VARCHAR2,
33 X_AP_AMOUNT_TOLERANCE IN OUT NOCOPY NUMBER,
34 X_AP_PERCENT_TOLERANCE IN OUT NOCOPY NUMBER,
35 X_AR_AMOUNT_TOLERANCE IN OUT NOCOPY NUMBER,
36 X_AR_PERCENT_TOLERANCE IN OUT NOCOPY NUMBER,
37 X_CE_AMOUNT_TOLERANCE IN OUT NOCOPY NUMBER,
38 X_CE_PERCENT_TOLERANCE IN OUT NOCOPY NUMBER,
39 X_STMT_LN_FLOAT_HANDLING_FLAG IN OUT NOCOPY VARCHAR2,
40 X_AUTORECON_AP_MATCHING_ORDER IN OUT NOCOPY VARCHAR2,
41 X_AUTORECON_AR_MATCHING_ORDER IN OUT NOCOPY VARCHAR2,
42 X_RECON_FX_BANK_XRATE_TYPE IN OUT NOCOPY VARCHAR2,
43 X_RECON_FX_BANK_XDATE_TYPE IN OUT NOCOPY VARCHAR2,
44 X_RECON_ENABLE_OI_FLAG IN OUT NOCOPY VARCHAR2,
45 X_RECON_OI_FLOAT_STATUS IN OUT NOCOPY VARCHAR2,
46 X_RECON_OI_CLEARED_STATUS IN OUT NOCOPY VARCHAR2,
47 X_RECON_OI_MATCHING_CODE IN OUT NOCOPY VARCHAR2,
48 X_RECON_OI_AMOUNT_TOLERANCE IN OUT NOCOPY NUMBER,
49 X_RECON_OI_PERCENT_TOLERANCE IN OUT NOCOPY NUMBER,
50 X_MANUAL_RECON_AMOUNT_TOL IN OUT NOCOPY NUMBER,
51 X_MANUAL_RECON_PERCENT_TOL IN OUT NOCOPY NUMBER,
52 X_RECON_AP_FX_DIFF_HANDLING IN OUT NOCOPY VARCHAR2,
53 X_RECON_AR_FX_DIFF_HANDLING IN OUT NOCOPY VARCHAR2,
54 X_RECON_CE_FX_DIFF_HANDLING IN OUT NOCOPY VARCHAR2,
55 X_RECON_AP_TOL_DIFF_ACCT IN OUT NOCOPY VARCHAR2,
56 X_RECON_CE_TOL_DIFF_ACCT IN OUT NOCOPY VARCHAR2,
57 X_LEGAL_ENTITY_ID IN OUT NOCOPY NUMBER,
58 X_BANK_ACCOUNT_ID IN OUT NOCOPY NUMBER,
59 X_AUTORECON_AP_MATCHING_ORDER2 IN OUT NOCOPY VARCHAR2 -- FOR SEPA ER 6700007
60 );
61
62
63 PROCEDURE BAU_SELECT_COLUMNS
64 (X_ROWID IN OUT NOCOPY VARCHAR2,
65 X_RECEIVABLE_TRX_ID IN OUT NOCOPY NUMBER,
66 X_ORG_ID IN OUT NOCOPY NUMBER,
67 X_BANK_ACCOUNT_ID IN OUT NOCOPY NUMBER,
68 X_BANK_ACCT_USE_ID IN OUT NOCOPY NUMBER);
69
70 END CE_SYSTEM_PARAMETERS1_PKG;