1 PACKAGE AP_PMT_CALLOUT_PKG AUTHID CURRENT_USER AS
2 /*$Header: apcnfrms.pls 120.7.12010000.3 2009/02/13 12:19:38 sanjagar ship $ */
3
4 FUNCTION get_user_rate
5 ( p_base_currency_code in varchar2,
6 p_payment_currency_code in varchar2,
7 p_checkrun_id in number) return number;
8
9
10 FUNCTION get_base_amount
11 ( p_base_currency_code in varchar2,
12 p_payment_currency_code in varchar2,
13 p_checkrun_id in number,
14 p_exchange_rate_type in varchar2,
15 p_base_currency_mac in number,
16 p_payment_amount in number,
17 p_base_currency_precision in number,
18 p_exchange_date in date) return number;
19
20
21
22 PROCEDURE documents_payable_rejected
23 ( p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2,
25 p_commit IN VARCHAR2,
26 x_return_status OUT nocopy VARCHAR2,
27 x_msg_count OUT nocopy NUMBER,
28 x_msg_data OUT nocopy VARCHAR2,
29 p_rejected_docs_group_id IN NUMBER);
30
31
32 PROCEDURE payments_completed
33 ( p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2,
35 p_commit IN VARCHAR2,
36 x_return_status OUT nocopy VARCHAR2,
37 x_msg_count OUT nocopy NUMBER,
38 x_msg_data OUT nocopy VARCHAR2,
39 p_completed_pmts_group_id IN NUMBER);
40
41 PROCEDURE payments_cleared
42 ( p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2,
44 p_commit IN VARCHAR2,
45 x_return_status OUT nocopy VARCHAR2,
46 x_msg_count OUT nocopy NUMBER,
47 x_msg_data OUT nocopy VARCHAR2,
48 p_group IN NUMBER);
49
50 PROCEDURE payments_uncleared
51 ( p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2,
53 p_commit IN VARCHAR2,
54 x_return_status OUT nocopy VARCHAR2,
55 x_msg_count OUT nocopy NUMBER,
56 x_msg_data OUT nocopy VARCHAR2,
57 p_group IN NUMBER);
58
59 PROCEDURE payment_voided
60 ( p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_payment_id IN NUMBER,
64 p_void_date IN DATE,
65 -- p_accounting_date IN DATE, /* Bug 4775938 */
66 x_return_status OUT nocopy VARCHAR2,
67 x_msg_count OUT nocopy NUMBER,
68 x_msg_data OUT nocopy VARCHAR2);
69
70 PROCEDURE ap_JapanBankChargeHook(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2,
73 p_commit IN VARCHAR2,
74 x_return_status OUT nocopy VARCHAR2,
75 x_msg_count OUT nocopy NUMBER,
76 x_msg_data OUT nocopy VARCHAR2);
77
78
79 /* Bug 6756063: Added the following procedures to sync
80 up the status of the Payment in Payables and IBY when
81 Stop has been initiated and released. */
82
83 PROCEDURE payment_stop_initiated
84 ( p_payment_id IN NUMBER,
85 p_stopped_date IN DATE, --Bug 6957071
86 p_stopped_by IN NUMBER, --Bug 6957071
87 x_return_status OUT nocopy VARCHAR2,
88 x_msg_count OUT nocopy NUMBER,
89 x_msg_data OUT nocopy VARCHAR2);
90
91 PROCEDURE payment_stop_released
92 ( p_payment_id IN NUMBER,
93 x_return_status OUT nocopy VARCHAR2,
94 x_msg_count OUT nocopy NUMBER,
95 x_msg_data OUT nocopy VARCHAR2);
96
97 /* End of fix for bug 6756063 */
98
99 /* Bug7530046 Added a new procedure to implement the hook that IBY calls
100 to decide whether voiding of a payment is allowed or not. */
101
102 PROCEDURE void_payment_allowed
103 ( p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_payment_id IN NUMBER,
107 x_return_flag OUT nocopy VARCHAR2,
108 x_return_status OUT nocopy VARCHAR2,
109 x_msg_count OUT nocopy NUMBER,
110 x_msg_data OUT nocopy VARCHAR2);
111
112
113 END AP_PMT_CALLOUT_PKG;