[Home] [Help]
PACKAGE: APPS.CE_BAT_UTILS
Source
1 PACKAGE CE_BAT_UTILS AUTHID CURRENT_USER as
2 /* $Header: cebtutls.pls 120.10 2006/08/24 09:42:49 svali noship $ */
3
4
5 G_spec_revision VARCHAR2(1000) := '$Revision: 120.10 $';
6
7 G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;
8 G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9 G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10 G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11 G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12 G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13 G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14 G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15 G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16 G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17 G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18 G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19 G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20 G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21 G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22 G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23 G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24 G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;
25
26 G_payment_request_id CE_PAYMENT_TRANSACTIONS.payment_request_number%TYPE;
27
28
29 FUNCTION spec_revision RETURN VARCHAR2;
30
31 FUNCTION body_revision RETURN VARCHAR2;
32
33 PROCEDURE transfer_payment_transaction ( p_trxn_reference_number NUMBER,
34 p_multi_currency VARCHAR2,
35 p_mode OUT NOCOPY VARCHAR2,
36 p_cashflow_id1 OUT NOCOPY NUMBER,
37 p_cashflow_id2 OUT NOCOPY NUMBER);
38
39 FUNCTION get_exchange_rate_type(p_le_id number) RETURN VARCHAR2;
40
41 PROCEDURE get_exchange_rate_date(p_ledger_id number,
42 p_bank_account_id number,
43 p_legal_entity_id number,
44 p_exch_type IN OUT NOCOPY varchar2,
45 p_exchange_date OUT NOCOPY date,
46 p_exchange_rate OUT NOCOPY number);
47
48 FUNCTION get_exchange_date_type(p_le_id NUMBER) RETURN VARCHAR2;
49
50 FUNCTION get_ledger_id (l_le_id NUMBER) RETURN NUMBER;
51
52 FUNCTION get_accounting_status(p_cashflow_number NUMBER) RETURN VARCHAR2;
53
54 PROCEDURE call_payment_process_request (p_payment_request_id NUMBER,
55 p_request_id OUT NOCOPY NUMBER
56 );
57
58 FUNCTION get_bsv (p_cash_ccid NUMBER, p_ledger_id NUMBER) RETURN VARCHAR2;
59
60 PROCEDURE get_intercompany_ccid (p_from_le_id NUMBER,
61 p_to_le_id NUMBER,
62 p_from_cash_gl_ccid NUMBER,
63 p_to_cash_gl_ccid NUMBER,
64 p_transfer_date DATE,
65 p_acct_type VARCHAR2,
66 p_status OUT NOCOPY VARCHAR2,
67 p_msg_count OUT NOCOPY NUMBER,
68 p_msg_data OUT NOCOPY VARCHAR2,
69 p_ccid OUT NOCOPY NUMBER,
70 p_reciprocal_ccid OUT NOCOPY NUMBER,
71 p_result OUT NOCOPY VARCHAR2);
72
73 PROCEDURE get_bat_default_pmt_method
74 (p_payer_le_id NUMBER,
75 p_org_id NUMBER,
76 p_payee_party_id NUMBER,
77 p_payee_party_site_id NUMBER,
78 p_supplier_site_id NUMBER,
79 p_payment_currency VARCHAR2,
80 p_payment_amount NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2 ,
82 x_msg_data OUT NOCOPY VARCHAR2 ,
83 x_msg_count OUT NOCOPY NUMBER ,
84 x_def_pm_code OUT NOCOPY VARCHAR2 ,
85 x_def_pm_name OUT NOCOPY VARCHAR2 );
86
87
88 END CE_BAT_UTILS;
89