1 PACKAGE gl_budget_transfer_pkg AUTHID CURRENT_USER AS
2 /* $Header: glibdxfs.pls 120.4 2005/05/05 01:02:47 kvora ship $ */
3 --
4 -- Package
5 -- gl_budget_transfer_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_budget_transfer
8 -- History
9 -- 03-25-94 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- get_from_to_balance
14 -- Purpose
15 -- Gets the indicated budget transfer balance for the from and to
16 -- code_combinations for the given budget and currency
17 -- History
18 -- 03-25-93 D. J. Ogg Created
19 -- Arguments
20 -- balance_type PTD, QTD, YTD, or PJTD
21 -- xledger_id Ledger ID
22 -- xbc_enabled_flag Indicates whether or not budgetary
23 -- control is enabled.
24 -- xperiod_name Period to get balances for
25 -- xbudget_version_id ID of budget to get balances for
26 -- xcurrency_code Currency to get balances for
27 -- from_code_combination_id From code combination
28 -- to_code_combination_id To code combination
29 -- from_balance Holds the balance of the from
30 -- code combination
31 -- to_balance Holds the balance of the to
32 -- code combination
33 -- Example
34 -- get_from_to_balance('PTD', 2, 'Y', 'JAN-91', 1000, 'USD', 2000, 2230,
35 -- from_bal, to_bal);
36 PROCEDURE get_from_to_balance (balance_type VARCHAR2,
37 xledger_id NUMBER,
38 xbc_enabled_flag VARCHAR2,
39 xperiod_name VARCHAR2,
40 xbudget_version_id NUMBER,
41 xcurrency_code VARCHAR2,
42 from_code_combination_id NUMBER,
43 to_code_combination_id NUMBER,
44 from_balance IN OUT NOCOPY NUMBER,
45 to_balance IN OUT NOCOPY NUMBER);
46
47 --
48 -- Procedure
49 -- get_balance
50 -- Purpose
51 -- Gets the indicated budget transfer balance for the given
52 -- code_combination, budget, and currency
53 -- History
54 -- 05-09-93 D. J. Ogg Created
55 -- Arguments
56 -- balance_type PTD, QTD, YTD, or PJTD
57 -- xledger_id Ledger ID
58 -- xbc_enabled_flag Indicates whether or not budgetary
59 -- control is enabled.
60 -- xperiod_name Period to get balances for
61 -- xbudget_version_id ID of budget to get balances for
62 -- xcurrency_code Currency to get balances for
63 -- code_combination_id Code combination
64 -- Example
65 -- balance := get_balance('PTD', 2, 'Y', 'JAN-91', 1000, 'USD', 2000);
66 FUNCTION get_balance (balance_type VARCHAR2,
67 xledger_id NUMBER,
68 xbc_enabled_flag VARCHAR2,
69 xperiod_name VARCHAR2,
70 xbudget_version_id NUMBER,
71 xcurrency_code VARCHAR2,
72 code_combination_id NUMBER) RETURN NUMBER;
73
74 --
75 -- Procedure
76 -- get_from_to_bc_balance
77 -- Purpose
78 -- Gets the indicated budgetary control balance for the from and to
79 -- code_combinations for the given budget and currency
80 -- History
81 -- 03-25-93 D. J. Ogg Created
82 -- Arguments
83 -- balance_type PTD, QTD, YTD, or PJTD
84 -- xledger_id Ledger ID
85 -- xperiod_name Period to get balances for
86 -- xactual_flag Actual, Budget, or Encumbrance
87 -- xbudget_version_id ID of budget or encumbrance to get
88 -- balances for
89 -- xcurrency_code Currency to get balances for
90 -- from_code_combination_id From code combination
91 -- to_code_combination_id To code combination
92 -- from_balance Holds the balance of the from
93 -- code combination
94 -- to_balance Holds the balance of the to
95 -- code combination
96 -- Example
97 -- get_from_to_bc_balance('PTD', 2, 'JAN-91', 1000, 'USD', 2000, 2230,
98 -- from_bal, to_bal);
99 PROCEDURE get_from_to_bc_balance (balance_type VARCHAR2,
100 xledger_id NUMBER,
101 xperiod_name VARCHAR2,
102 xactual_flag VARCHAR2,
103 xbudget_version_id NUMBER,
104 xcurrency_code VARCHAR2,
105 from_code_combination_id NUMBER,
106 to_code_combination_id NUMBER,
107 from_balance IN OUT NOCOPY NUMBER,
108 to_balance IN OUT NOCOPY NUMBER);
109
110 --
111 -- Procedure
112 -- get_bc_balance
113 -- Purpose
114 -- Gets the balance in gl_bc_packets for the given code combination
115 -- History
116 -- 03-28-93 D. J. Ogg Created
117 -- Arguments
118 -- balance_type PTD, QTD, YTD, or PJTD
119 -- xledger_id Ledger ID
120 -- xperiod_name Period to get balances for
121 -- xactual_flag Actual Flag
122 -- xbudget_version_id ID of budget or encumbrance to
123 -- get balances for
124 -- xcurrency_code Currency to get balances for
125 -- xcode_combination_id Code combination
126 -- Example
127 -- get_bc_balance('YTD', 2, 'JAN-91', 'A', -1, 'USD', 2034);
128 FUNCTION get_bc_balance (balance_type VARCHAR2,
129 xledger_id NUMBER,
130 xperiod_name VARCHAR2,
131 xactual_flag VARCHAR2,
132 xbudget_version_id NUMBER,
133 xcurrency_code VARCHAR2,
134 xcode_combination_id NUMBER) RETURN NUMBER;
135
136 --
137 -- Procedure
138 -- get_posted_balance
139 -- Purpose
140 -- Gets the balance in gl_balances for the given code combination
141 -- History
142 -- 03-28-93 D. J. Ogg Created
143 -- Arguments
144 -- balance_type PTD, QTD, YTD, or PJTD
145 -- xledger_id Ledger ID
146 -- xperiod_name Period to get balances for
147 -- xactual_flag Actual Flag
148 -- xbudget_version_id ID of budget or encumbrance to
149 -- get balances for
150 -- xcurrency_code Currency to get balances for
151 -- xcode_combination_id Code combination
152 -- Example
153 -- get_posted_balance('YTD', 2, 'JAN-91', 'A', -1, 'USD', 2034);
154 FUNCTION get_posted_balance (balance_type VARCHAR2,
155 xledger_id NUMBER,
156 xperiod_name VARCHAR2,
157 xactual_flag VARCHAR2,
158 xbudget_version_id NUMBER,
159 xcurrency_code VARCHAR2,
160 xcode_combination_id NUMBER) RETURN NUMBER;
161
162 END gl_budget_transfer_pkg;