PACKAGE: APPS.CE_BAT_API

Source

1 PACKAGE CE_BAT_API AS
2 /* $Header: cebtapis.pls 120.7.12010000.2 2008/11/13 12:47:20 talapati ship $ */
3 --
4 
5 G_spec_revision 	VARCHAR2(1000) := '$Revision: 120.7.12010000.2 $';
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 
126 
127 END CE_BAT_API;