1 PACKAGE FUN_GL_TRANSFER AS
2 /* $Header: FUN_GL_XFER_S.pls 120.3.12010000.3 2008/11/02 18:23:12 ychandra ship $ */
3
4 -- Raised when the transaction is in the wrong status.
5 corrupted_transaction_status EXCEPTION;
6
7 -- Raise when the party_type is unknown in batch transfer.
8 trx_no_party_type_error EXCEPTION;
9
10 FUNCTION get_conversion_type(
11 p_conversion_type IN varchar2) RETURN varchar2;
12
13
14 /*-----------------------------------------------------
15 * FUNCTION lock_and_transfer
16 * ----------------------------------------------------
17 * Acquires lock and transfer.
18 * ---------------------------------------------------*/
19
20 FUNCTION lock_and_transfer (
21 p_trx_id IN number,
22 p_ledger_id IN number,
23 p_gl_date IN date,
24 p_currency IN varchar2,
25 p_category IN varchar2,
26 p_source IN varchar2,
27 p_desc IN varchar2,
28 p_conv_date IN date,
29 p_conv_type IN varchar2,
30 p_party_type IN varchar2) RETURN boolean;
31
32
33 /*-----------------------------------------------------
34 * FUNCTION lock_transaction
35 * ----------------------------------------------------
36 * Lock the transaction.
37 * If p_status is not null, test if it's valid still.
38 * ---------------------------------------------------*/
39
40 FUNCTION lock_transaction (
41 p_trx_id IN number,
42 p_party_type IN varchar2) RETURN boolean;
43
44
45 /*-----------------------------------------------------
46 * FUNCTION has_conversion_rate
47 * ----------------------------------------------------
48 * Is there a conversion rate between the two
49 * currencies?
50 * ---------------------------------------------------*/
51
52 FUNCTION has_conversion_rate (
53 p_from_currency IN varchar2,
54 p_to_currency IN varchar2,
55 p_exchange_type IN varchar2,
56 p_exchange_date IN date) RETURN number;
57
58
59 /*-----------------------------------------------------
60 * FUNCTION get_period_status
61 * ----------------------------------------------------
62 * Returns the period closing status.
63 * ---------------------------------------------------*/
64
65 FUNCTION get_period_status (
66 p_app_id IN number,
67 p_date IN date,
68 p_ledger_id IN number) RETURN varchar2;
69
70
71 /*-----------------------------------------------------
72 * FUNCTION update_status
73 * ----------------------------------------------------
74 * Returns the new status.
75 * ---------------------------------------------------*/
76
77 FUNCTION update_status (
78 p_trx_id IN number,
79 p_status IN varchar2,
80 p_party_type IN varchar2) RETURN varchar2;
81
82
83
84 /*-----------------------------------------------------
85 * PROCEDURE transfer_single
86 * ----------------------------------------------------
87 * Transfer a single transaction to GL interface.
88 * It assumes that the caller has a lock on the
89 * transaction, and will do the commit.
90 * ---------------------------------------------------*/
91
92 PROCEDURE transfer_single (
93 p_batch_number IN varchar2,
94 p_trx_id IN number,
95 p_ledger_id IN number,
96 p_gl_date IN date,
97 p_currency IN varchar2,
98 p_category IN varchar2,
99 p_source IN varchar2,
100 p_desc IN varchar2,
101 p_conv_date IN date,
102 p_conv_type IN varchar2,
103 p_party_type IN varchar2);
104
105
106
107 /*-----------------------------------------------------
108 * PROCEDURE transfer_batch
109 * ----------------------------------------------------
110 * Not used anymore
111 * ---------------------------------------------------*/
112
113 PROCEDURE transfer_batch (
114 p_request_id IN number,
115 p_source IN varchar2,
116 p_category IN varchar2,
117 p_date_low IN date DEFAULT NULL,
118 p_date_high IN date DEFAULT NULL,
119 p_ledger_low IN varchar2 DEFAULT NULL,
120 p_ledger_high IN varchar2 DEFAULT NULL,
121 p_le_low IN varchar2 DEFAULT NULL,
122 p_le_high IN varchar2 DEFAULT NULL,
123 p_ic_org_low IN varchar2 DEFAULT NULL,
124 p_ic_org_high IN varchar2 DEFAULT NULL,
125 p_commit_freq IN number DEFAULT 100);
126
127 END;
128