[Home] [Help]
PACKAGE: APPS.CE_BAT_API
Source
1 PACKAGE CE_BAT_API AUTHID CURRENT_USER AS
2 /* $Header: cebtapis.pls 120.7.12010000.3 2009/05/18 09:58:59 vnetan ship $ */
3 --
4
5 G_spec_revision VARCHAR2(1000) := '$Revision: 120.7.12010000.3 $';
6
7 FUNCTION spec_revision RETURN VARCHAR2;
8 FUNCTION body_revision RETURN VARCHAR2;
9
10
11 PROCEDURE create_transfer(
12 p_called_by_1 VARCHAR2,
13 p_source_ba_id NUMBER,
14 p_destination_ba_id NUMBER,
15 p_statement_line_id NUMBER,
16 p_cashpool_id NUMBER,
17 p_transfer_amount NUMBER,
18 p_payment_details_from VARCHAR2,
19 p_as_of_date DATE,
20 p_cashflows_created_flag OUT NOCOPY VARCHAR2,
21 p_result OUT NOCOPY varchar2,
22 p_msg_count OUT NOCOPY NUMBER,
23 p_trxn_reference_number OUT NOCOPY NUMBER);
24
25 PROCEDURE check_duplicate(
26 p_called_by VARCHAR2,
27 p_source_ba_id NUMBER,
28 p_destination_ba_id NUMBER,
29 p_statement_line_id NUMBER,
30 p_transfer_amount NUMBER,
31 p_transfer_date DATE,
32 p_pay_trxn_number OUT NOCOPY NUMBER,
33 p_result OUT NOCOPY varchar2);
34
35 PROCEDURE validate_transfer(
36 p_called_by VARCHAR2,
37 p_trxn_reference_number NUMBER,
38 p_source_le_id NUMBER,
39 p_destination_le_id NUMBER,
40 p_source_ba_currency_code VARCHAR2,
41 p_destination_ba_currency_code VARCHAR2,
42 p_transfer_currency_code VARCHAR2,
43 p_transfer_date DATE,
44 p_source_ba_asset_ccid NUMBER,
45 p_destination_ba_asset_ccid NUMBER,
46 p_destination_bank_account_id NUMBER,
47 p_authorize_flag VARCHAR2,
48 p_settle_flag VARCHAR2,
49 p_ccid OUT NOCOPY NUMBER,
50 p_reciprocal_ccid OUT NOCOPY NUMBER,
51 p_result OUT NOCOPY varchar2);
52
53 PROCEDURE initiate_transfer(
54 p_called_by VARCHAR2,
55 p_source_ba_id NUMBER,
56 p_destination_ba_id NUMBER,
57 p_cashpool_id NUMBER,
58 p_statement_line_id NUMBER,
59 p_transfer_amount NUMBER,
60 p_as_of_date DATE,
61 p_payment_details_from VARCHAR2,
62 p_result OUT NOCOPY varchar2);
63
64 PROCEDURE check_user_security(
65 p_source_le_id NUMBER,
66 p_destination_le_id NUMBER,
67 p_result OUT NOCOPY varchar2);
68
69 PROCEDURE authorize_transfer(
70 p_called_by VARCHAR2,
71 p_trxn_reference_number NUMBER,
72 p_settle_flag VARCHAR2,
73 p_pay_proc_req_code NUMBER,
74 p_result OUT NOCOPY varchar2);
75
76 PROCEDURE reject_transfer(
77 p_pay_trxn_number NUMBER,
78 p_result OUT NOCOPY varchar2);
79
80 PROCEDURE cancel_transfer(
81 p_pay_trxn_number NUMBER,
82 p_result OUT NOCOPY VARCHAR2);
83
84 PROCEDURE populate_transfer(
85 p_pay_trxn_number OUT NOCOPY NUMBER);
86
87 PROCEDURE settle_transfer(
88 p_called_by VARCHAR2,
89 p_pay_trxn_number NUMBER,
90 /* Bug 7559093 */
91 p_payment_reference_number VARCHAR2,
92 p_cashflow_id1 NUMBER,
93 p_cashflow_id2 NUMBER);
94
95 PROCEDURE iby_validations(p_bank_account_id NUMBER,
96 p_trxn_reference_number NUMBER,
97 p_result OUT NOCOPY VARCHAR2);
98
99 PROCEDURE check_create_ext_bank_acct (p_bank_account_id NUMBER,
100 p_ext_bank_account_id OUT NOCOPY NUMBER,
101 p_return_status OUT NOCOPY VARCHAR2);
102
103 PROCEDURE call_iby_validate(p_trxn_reference_number NUMBER,
104 p_doc_payable_id OUT NOCOPY NUMBER,
105 p_return_status OUT NOCOPY VARCHAR2);
106
107 PROCEDURE cancel_cashflow (p_cashflow_id NUMBER,
108 p_result OUT NOCOPY VARCHAR2);
109
110 PROCEDURE create_update_cashflows(p_trxn_reference_number NUMBER,
111 p_mode OUT NOCOPY VARCHAR2,
112 p_cashflow_id1 OUT NOCOPY NUMBER,
113 p_cashflow_id2 OUT NOCOPY NUMBER);
114
115 /*bug 6046852*/
116 PROCEDURE validate_foreign_currency(
117 p_source_le_id NUMBER,
118 p_destination_le_id NUMBER,
119 p_source_ba_id VARCHAR2,
120 p_destination_ba_id VARCHAR2,
121 p_pmt_currency VARCHAR2, --for bug 6455698
122 p_error_code OUT NOCOPY VARCHAR2 --for bug 6455698
123 );
124
125 -- bug 8459147
126 PROCEDURE check_gl_period(
127 p_date DATE,
128 p_source_le_id NUMBER,
129 p_destination_le_id NUMBER,
130 x_period_status OUT NOCOPY VARCHAR2);
131
132 END CE_BAT_API;