1 PACKAGE FUN_AP_TRANSFER AS
2 /* $Header: FUN_AP_XFER_S.pls 120.7 2006/07/04 15:49:44 bsilveir noship $ */
3
4 FUNCTION has_valid_conversion_rate (
5 p_from_currency IN varchar2,
6 p_to_currency IN varchar2,
7 p_exchange_type IN varchar2,
8 p_exchange_date IN date) RETURN NUMBER;
9
10 /*-----------------------------------------------------
11 * FUNCTION lock_and_transfer
12 * ----------------------------------------------------
13 * Acquires lock and transfer one trx.
14 *
15 * Returns TRUE iff it can obtain lock, see a valid
16 * status, and transfer the trx.
17 * ---------------------------------------------------*/
18
19 FUNCTION lock_and_transfer (
20 p_trx_id IN number,
21 p_batch_date IN date,
22 p_vendor_id IN number,
23 p_site_id IN number,
24 p_gl_date IN date,
25 p_currency IN varchar2,
26 p_exchg_rate IN varchar2,
27 p_source IN varchar2,
28 p_approval_date IN date,
29 p_to_org_id IN number,
30 p_invoice_num IN varchar2,
31 p_from_org_id IN NUMBER) RETURN boolean;
32
33
34 /*-----------------------------------------------------
35 * FUNCTION lock_transaction
36 * ----------------------------------------------------
37 * Lock the transaction, test if it's valid still.
38 * ---------------------------------------------------*/
39
40 FUNCTION lock_transaction (
41 p_trx_id IN number) RETURN boolean;
42
43
44 /*-----------------------------------------------------
45 * PROCEDURE update_status
46 * ----------------------------------------------------
47 * Returns the new status.
48 * ---------------------------------------------------*/
49
50 PROCEDURE update_status (
51 p_trx_id IN number);
52
53
54 /*-----------------------------------------------------
55 * PROCEDURE transfer_batch
56 * ----------------------------------------------------
57 * Transfer to AP interface in batch.
58 * ---------------------------------------------------*/
59
60 PROCEDURE transfer_batch (
61 errbuf OUT NOCOPY varchar2,
62 retcode OUT NOCOPY number,
63 p_org_id IN number DEFAULT NULL,
64 p_le_id IN number DEFAULT NULL ,
65 p_period_low IN varchar2 DEFAULT NULL,
66 p_period_high IN varchar2 DEFAULT NULL,
67 p_run_payables_import IN varchar2 DEFAULT 'N' );
68
69
70 /*-----------------------------------------------------
71 * PROCEDURE transfer_single
72 * ----------------------------------------------------
73 * Transfer a single transaction to AP interface.
74 * It assumes that the caller has a lock on the
75 * transaction, and the caller will do the commit.
76 * ---------------------------------------------------*/
77
78 PROCEDURE transfer_single (
79 p_trx_id IN number,
80 p_batch_date IN date,
81 p_vendor_id IN number,
82 p_vendor_site_id IN number,
83 p_currency IN varchar2,
84 p_conv_type IN varchar2,
85 p_source IN varchar2,
86 p_gl_date IN date,
87 p_approval_date IN date,
88 p_org_id IN number,
89 p_invoice_num IN varchar2,
90 p_from_org_id IN number,
91 p_payables_ccid OUT NOCOPY number);
92
93
94
95 END;
96