[Home] [Help]
PACKAGE: APPS.GL_BUDGETS_PKG
Source
1 PACKAGE gl_budgets_pkg AS
2 /* $Header: glibddfs.pls 120.4 2005/05/05 01:01:24 kvora ship $ */
3 --
4 -- Package
5 -- gl_budgets
6 -- Purpose
7 -- To implement various data checking needed for the
8 -- gl_budgets table
9 -- History
10 -- 10-14-93 D. J. Ogg Created
11 --
12
13 --
14 -- Procedure
15 -- check_unique
16 -- Purpose
17 -- Checks to make sure the given budget_name is
18 -- unique within gl_budgets.
19 -- History
20 -- 10-14-93 D. J. Ogg Created
21 -- Arguments
22 -- name The budget name to be checked
23 -- rowid The ID of the row to be checked
24 -- Example
25 -- gl_budgets.check_unique('DBUDGET', 'ABD0123');
26 -- Notes
27 --
28 PROCEDURE check_unique(name VARCHAR2,
29 row_id VARCHAR2);
30
31 --
32 -- Procedure
33 -- get_unique_id
34 -- Purpose
35 -- Gets a unique budget version id for a new budget.
36 -- History
37 -- 10-14-93 D. J. Ogg Created
38 -- Arguments
39 -- none
40 -- Example
41 -- bid := gl_budgets_pkg.get_unique_id;
42 -- Notes
43 --
44 FUNCTION get_unique_id RETURN NUMBER;
45
46
47 --
48 -- Procedure
49 -- is_budget_journals_not_req
50 -- Purpose
51 -- Find the existence of any budget which does not require budget
52 -- journals. If it is found return TRUE else return FALSE.
53 -- History
54 -- 12.01.93 E. Rumanang Created
55 -- Arguments
56 -- x_ledger_id ledger_id to be checked.
57 -- Example
58 -- gl_budgets_pkg.is_budget_journals_not_req( 123 );
59 -- Notes
60 --
61 FUNCTION is_budget_journals_not_req(
62 x_ledger_id NUMBER ) RETURN BOOLEAN;
63
64
65 --
66 -- Procedure
67 -- select_row
68 -- Purpose
69 -- Gets the row from gl_budgets associated with
70 -- the given budget.
71 -- History
72 -- 09-SEP-94 E. Rumanang Created.
73 -- Arguments
74 -- recinfo gl_budgets
75 -- Example
76 -- select_row.recinfo;
77 -- Notes
78 --
79 PROCEDURE select_row( recinfo IN OUT NOCOPY gl_budgets%ROWTYPE );
80
81
82
83 --
84 -- Procedure
85 -- select_columns
86 -- Purpose
87 -- Gets the values of some columns from gl_budgets associated with
88 -- the given budget.
89 -- History
90 -- 09-SEP-94 E. Rumanang Created.
91 -- Arguments
92 -- x_ledger_id
93 -- x_budget_name
94 -- x_ledger_id
95 -- x_budget_type
96 -- x_status
97 -- x_required_bj_flag
98 -- x_latest_opened_year
99 -- x_first_valid_period_name
100 -- x_last_valid_period_name
101 --
102 PROCEDURE select_columns(
103 x_budget_name VARCHAR2,
104 x_ledger_id NUMBER,
105 x_budget_type IN OUT NOCOPY VARCHAR2,
106 x_status IN OUT NOCOPY VARCHAR2,
107 x_required_bj_flag IN OUT NOCOPY VARCHAR2,
108 x_latest_opened_year IN OUT NOCOPY NUMBER,
109 x_first_valid_period_name IN OUT NOCOPY VARCHAR2,
110 x_last_valid_period_name IN OUT NOCOPY VARCHAR2 );
111
112
113
114 PROCEDURE Insert_Row(
115 X_Rowid IN OUT NOCOPY VARCHAR2,
116 X_Budget_Type VARCHAR2,
117 X_Budget_Name VARCHAR2,
118 X_Ledger_id NUMBER,
119 X_Status VARCHAR2,
120 X_Date_Created DATE,
121 X_Require_Budget_Journals_Flag VARCHAR2,
122 X_Current_Version_Id NUMBER DEFAULT NULL,
123 X_Latest_Opened_Year NUMBER DEFAULT NULL,
124 X_First_Valid_Period_Name VARCHAR2 DEFAULT NULL,
125 X_Last_Valid_Period_Name VARCHAR2 DEFAULT NULL,
126 X_Description VARCHAR2 DEFAULT NULL,
127 X_Date_Closed DATE DEFAULT NULL,
128 X_Attribute1 VARCHAR2 DEFAULT NULL,
129 X_Attribute2 VARCHAR2 DEFAULT NULL,
130 X_Attribute3 VARCHAR2 DEFAULT NULL,
131 X_Attribute4 VARCHAR2 DEFAULT NULL,
132 X_Attribute5 VARCHAR2 DEFAULT NULL,
133 X_Attribute6 VARCHAR2 DEFAULT NULL,
134 X_Attribute7 VARCHAR2 DEFAULT NULL,
135 X_Attribute8 VARCHAR2 DEFAULT NULL,
136 X_Context VARCHAR2 DEFAULT NULL,
137 X_User_Id NUMBER,
138 X_Login_Id NUMBER,
139 X_Date DATE,
140 X_Budget_Version_Id NUMBER,
141 X_Master_Budget_Version_Id NUMBER DEFAULT NULL
142 );
143
144 PROCEDURE Lock_Row(
145 X_Rowid VARCHAR2,
146 X_Budget_Type VARCHAR2,
147 X_Budget_Name VARCHAR2,
148 X_Ledger_id NUMBER,
149 X_Last_Update_Date DATE,
150 X_Last_Updated_By NUMBER,
151 X_Status VARCHAR2,
152 X_Date_Created DATE,
153 X_Require_Budget_Journals_Flag VARCHAR2,
154 X_Creation_Date DATE DEFAULT NULL,
155 X_Created_By NUMBER DEFAULT NULL,
156 X_Last_Update_Login NUMBER DEFAULT NULL,
157 X_Current_Version_Id NUMBER DEFAULT NULL,
158 X_Latest_Opened_Year NUMBER DEFAULT NULL,
159 X_First_Valid_Period_Name VARCHAR2 DEFAULT NULL,
160 X_Last_Valid_Period_Name VARCHAR2 DEFAULT NULL,
161 X_Description VARCHAR2 DEFAULT NULL,
162 X_Date_Closed DATE DEFAULT NULL,
163 X_Attribute1 VARCHAR2 DEFAULT NULL,
164 X_Attribute2 VARCHAR2 DEFAULT NULL,
165 X_Attribute3 VARCHAR2 DEFAULT NULL,
166 X_Attribute4 VARCHAR2 DEFAULT NULL,
167 X_Attribute5 VARCHAR2 DEFAULT NULL,
168 X_Attribute6 VARCHAR2 DEFAULT NULL,
169 X_Attribute7 VARCHAR2 DEFAULT NULL,
170 X_Attribute8 VARCHAR2 DEFAULT NULL,
171 X_Context VARCHAR2 DEFAULT NULL
172 );
173
174 PROCEDURE Update_Row(
175 X_Rowid VARCHAR2,
176 X_Budget_Type VARCHAR2,
177 X_Budget_Name VARCHAR2,
178 X_Ledger_id NUMBER,
179 X_Status VARCHAR2,
180 X_Date_Created DATE,
181 X_Require_Budget_Journals_Flag VARCHAR2,
182 X_Current_Version_Id NUMBER DEFAULT NULL,
183 X_Latest_Opened_Year NUMBER DEFAULT NULL,
184 X_First_Valid_Period_Name VARCHAR2 DEFAULT NULL,
185 X_Last_Valid_Period_Name VARCHAR2 DEFAULT NULL,
186 X_Description VARCHAR2 DEFAULT NULL,
187 X_Date_Closed DATE DEFAULT NULL,
188 X_Attribute1 VARCHAR2 DEFAULT NULL,
189 X_Attribute2 VARCHAR2 DEFAULT NULL,
190 X_Attribute3 VARCHAR2 DEFAULT NULL,
191 X_Attribute4 VARCHAR2 DEFAULT NULL,
192 X_Attribute5 VARCHAR2 DEFAULT NULL,
193 X_Attribute6 VARCHAR2 DEFAULT NULL,
194 X_Attribute7 VARCHAR2 DEFAULT NULL,
195 X_Attribute8 VARCHAR2 DEFAULT NULL,
196 X_Context VARCHAR2 DEFAULT NULL,
197 X_User_Id NUMBER,
198 X_Login_Id NUMBER,
199 X_Date DATE,
200 X_Budget_Version_Id NUMBER,
201 X_Master_Budget_Version_Id NUMBER DEFAULT NULL
202 );
203
204 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
205
206 END gl_budgets_pkg;