[Home] [Help]
PACKAGE: APPS.GL_BUDGET_ASSIGNMENT_PKG
Source
1 PACKAGE gl_budget_assignment_pkg AS
2 /* $Header: glibdass.pls 120.6 2005/08/25 22:55:34 djogg ship $ */
3 --
4 -- Package
5 -- gl_budget_assignment_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_alloc_batches
8 -- History
9 -- 12-03-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- check_unique
14 -- Purpose
15 -- Checks to make sure that the code_combination_id/currency code
16 -- /range_id combo is unique within that ledger
17 -- History
18 -- 12-03-93 D. J. Ogg Created
19 -- Arguments
20 -- lgr_id The ID of the ledger
21 -- ccid Code Combination ID
22 -- curr_code Currency code
23 -- rng_id Range Id
24 -- row_id The current rowid
25 -- Example
26 -- gl_budget_assignment_pkg.check_unique(2, 1012, 'USD', 501, 'ABD02334');
27 -- Notes
28 --
29 PROCEDURE check_unique(lgr_id NUMBER, ccid NUMBER, curr_code VARCHAR2,
30 rng_id NUMBER, row_id VARCHAR2);
31
32 --
33 -- Procedure
34 -- delete_range_assignments
35 -- Purpose
36 -- Deletes all of the assignments assigned by a given range
37 -- History
38 -- 12-10-93 D. J. Ogg Created
39 -- Arguments
40 -- range_id The ID of the Accounting Flexfield Ranges
41 -- Example
42 -- gl_budget_assignment_pkg.delete_range_assignment(1012);
43 -- Notes
44 --
45 PROCEDURE delete_range_assignments(xrange_id NUMBER);
46
47 --
48 -- Procedure
49 -- delete_assignment
50 -- Purpose
51 -- Deletes a given assignment
52 -- History
53 -- 12-17-93 D. J. Ogg Created
54 -- Arguments
55 -- lgr_id The ledger containing the assignment
56 -- ccid The code combination id of the assignment
57 -- curr_code The currency code of the assignment
58 -- rng_id The range id
59 -- Example
60 -- gl_budget_assignment_pkg.delete_assignment(2, 1023, 'USD', 501);
61 -- Notes
62 --
63 PROCEDURE delete_assignment(lgr_id NUMBER, ccid NUMBER,
64 curr_code VARCHAR2, rng_id NUMBER);
65
66
67 --
68 -- Procedure
69 -- is_budget_calculated
70 -- Purpose
71 -- Find out whether the budget type is calculated or entered.
72 -- Return TRUE for calculated type, FALSE for entered type.
73 -- History
74 -- 13-MAR-94 ERumanan Created
75 -- Arguments
76 -- xlgr_id The ledger containing the assignment
77 -- xccid The code combination id of the assignment
78 -- xcurr_code The currency code of the assignment
79 -- Example
80 -- gl_budget_assignment_pkg.is_budget_calculated(2, 1023, 'USD');
81 -- Notes
82 --
83 FUNCTION is_budget_calculated( xlgr_id NUMBER,
84 xccid NUMBER,
85 xcurr_code VARCHAR2 ) RETURN BOOLEAN;
86
87 --
88 -- Procedure
89 -- is_acct_stat_enterable
90 -- Purpose
91 -- Determine whether you can budget stat amounts to a particular account.
92 -- Return TRUE if so, FALSE otherwise.
93 -- History
94 -- 23-AUG-94 R Ng Created
95 -- Arguments
96 -- xsob_id Ledger ID
97 -- xccid Code Combination ID
98 -- Example
99 -- gl_budget_assignment_pkg.is_acct_stat_enterable(2, 1023);
100 -- Notes
101 --
102 FUNCTION is_acct_stat_enterable( xlgr_id NUMBER,
103 xccid NUMBER ) RETURN BOOLEAN;
104
105
106 --
107 -- Procedure
108 -- select_columns
109 -- Purpose
110 -- Used to select the budget_entity_id, budget_entity_name,
111 -- and entry_code.
112 -- History
113 -- 21-MAR-94 DJOGG Created
114 -- Arguments
115 -- xlgr_id The ledger containing the assignment
116 -- xccid The code combination id of the assignment
117 -- xcurr_code The currency code of the assignment
118 -- xentity_id The ID of the budget entity the code combination is
119 -- assigned to
120 -- xentry_code The entry method for the assignment
121 -- Example
122 -- gl_budget_assignment_pkg.select_columns(2, 1023, 'USD', eid, ename,
123 -- ecode);
124 -- Notes
125 --
126 PROCEDURE select_columns( xlgr_id NUMBER,
127 xccid NUMBER,
128 xcurr_code VARCHAR2,
129 xentity_id IN OUT NOCOPY NUMBER,
130 xentry_code IN OUT NOCOPY VARCHAR2);
131
132
133 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
134
135 X_Ledger_Id NUMBER,
136 X_Budget_Entity_Id NUMBER,
137 X_Code_Combination_Id NUMBER,
138 X_Currency_Code VARCHAR2,
139 X_Entry_Code VARCHAR2,
140 X_Ordering_Value VARCHAR2,
141 X_Last_Update_Date DATE,
142 X_Last_Updated_By NUMBER,
143 X_Creation_Date DATE,
144 X_Created_By NUMBER,
145 X_Last_Update_Login NUMBER,
146 X_Attribute1 VARCHAR2,
147 X_Attribute2 VARCHAR2,
148 X_Attribute3 VARCHAR2,
149 X_Attribute4 VARCHAR2,
150 X_Attribute5 VARCHAR2,
151 X_Attribute6 VARCHAR2,
152 X_Attribute7 VARCHAR2,
153 X_Attribute8 VARCHAR2,
154 X_Context VARCHAR2,
155 X_Range_Id NUMBER
156 );
157
158 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
159 X_Ledger_Id NUMBER,
160 X_Budget_Entity_Id NUMBER,
161 X_Code_Combination_Id NUMBER,
162 X_Currency_Code VARCHAR2,
163 X_Entry_Code VARCHAR2,
164 X_Ordering_Value VARCHAR2,
165 X_Attribute1 VARCHAR2,
166 X_Attribute2 VARCHAR2,
167 X_Attribute3 VARCHAR2,
168 X_Attribute4 VARCHAR2,
169 X_Attribute5 VARCHAR2,
170 X_Attribute6 VARCHAR2,
171 X_Attribute7 VARCHAR2,
172 X_Attribute8 VARCHAR2,
173 X_Context VARCHAR2,
174 X_Range_Id NUMBER
175 );
176
177 PROCEDURE Update_Row(X_Rowid VARCHAR2,
178 X_Ledger_Id NUMBER,
179 X_Budget_Entity_Id NUMBER,
180 X_Code_Combination_Id NUMBER,
181 X_Currency_Code VARCHAR2,
182 X_Entry_Code VARCHAR2,
183 X_Ordering_Value VARCHAR2,
184 X_Last_Update_Date DATE,
185 X_Last_Updated_By NUMBER,
186 X_Last_Update_Login NUMBER,
187 X_Attribute1 VARCHAR2,
188 X_Attribute2 VARCHAR2,
189 X_Attribute3 VARCHAR2,
190 X_Attribute4 VARCHAR2,
191 X_Attribute5 VARCHAR2,
192 X_Attribute6 VARCHAR2,
193 X_Attribute7 VARCHAR2,
194 X_Attribute8 VARCHAR2,
195 X_Context VARCHAR2,
196 X_Range_Id NUMBER
197 );
198
199 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
200
201 END gl_budget_assignment_pkg;