1 PACKAGE FUN_GL_TRANSFER AUTHID CURRENT_USER AS
2 /* $Header: FUN_GL_XFER_S.pls 120.3.12010000.4 2009/03/23 10:47:53 makansal 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,
31 p_user_env_lang IN varchar2) RETURN boolean;
32
33
34 /*-----------------------------------------------------
35 * FUNCTION lock_transaction
36 * ----------------------------------------------------
37 * Lock the transaction.
38 * If p_status is not null, test if it's valid still.
39 * ---------------------------------------------------*/
40
41 FUNCTION lock_transaction (
42 p_trx_id IN number,
43 p_party_type IN varchar2) RETURN boolean;
44
45
46 /*-----------------------------------------------------
47 * FUNCTION has_conversion_rate
48 * ----------------------------------------------------
49 * Is there a conversion rate between the two
50 * currencies?
51 * ---------------------------------------------------*/
52
53 FUNCTION has_conversion_rate (
54 p_from_currency IN varchar2,
55 p_to_currency IN varchar2,
56 p_exchange_type IN varchar2,
57 p_exchange_date IN date) RETURN number;
58
59
60 /*-----------------------------------------------------
61 * FUNCTION get_period_status
62 * ----------------------------------------------------
63 * Returns the period closing status.
64 * ---------------------------------------------------*/
65
66 FUNCTION get_period_status (
67 p_app_id IN number,
68 p_date IN date,
69 p_ledger_id IN number) RETURN varchar2;
70
71
72 /*-----------------------------------------------------
73 * FUNCTION update_status
74 * ----------------------------------------------------
75 * Returns the new status.
76 * ---------------------------------------------------*/
77
78 FUNCTION update_status (
79 p_trx_id IN number,
80 p_status IN varchar2,
81 p_party_type IN varchar2) RETURN varchar2;
82
83
84
85 /*-----------------------------------------------------
86 * PROCEDURE transfer_single
87 * ----------------------------------------------------
88 * Transfer a single transaction to GL interface.
89 * It assumes that the caller has a lock on the
90 * transaction, and will do the commit.
91 * ---------------------------------------------------*/
92
93 PROCEDURE transfer_single (
94 p_batch_number IN varchar2,
95 p_trx_id IN number,
96 p_ledger_id IN number,
97 p_gl_date IN date,
98 p_currency IN varchar2,
99 p_category IN varchar2,
100 p_source IN varchar2,
101 p_desc IN varchar2,
102 p_conv_date IN date,
103 p_conv_type IN varchar2,
104 p_party_type IN varchar2,
105 p_user_env_lang IN varchar2);
106
107
108
109 /*-----------------------------------------------------
110 * PROCEDURE transfer_batch
111 * ----------------------------------------------------
112 * Not used anymore
113 * ---------------------------------------------------*/
114
115 PROCEDURE transfer_batch (
116 p_request_id IN number,
117 p_source IN varchar2,
118 p_category IN varchar2,
119 p_date_low IN date DEFAULT NULL,
120 p_date_high IN date DEFAULT NULL,
121 p_ledger_low IN varchar2 DEFAULT NULL,
122 p_ledger_high IN varchar2 DEFAULT NULL,
123 p_le_low IN varchar2 DEFAULT NULL,
124 p_le_high IN varchar2 DEFAULT NULL,
125 p_ic_org_low IN varchar2 DEFAULT NULL,
126 p_ic_org_high IN varchar2 DEFAULT NULL,
127 p_commit_freq IN number DEFAULT 100);
128
129 END;
130
[Home] [Help]