1 PACKAGE gl_budget_versions_pkg AS
2 /* $Header: glibdves.pls 120.3 2005/05/05 01:02:31 kvora ship $ */
3 --
4 -- Package
5 -- gl_budget_versions_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_budget_versions
8 -- History
9 -- 10-18-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- insert_record
14 -- Purpose
15 -- Used to insert records into gl_budget_versions
16 -- for a new budget.
17 -- History
18 -- 10-18-93 D. J. Ogg Created
19 -- Arguments
20 -- x_budget_version_id Version ID of the new budget
21 -- x_budget_name Name of the new budget
22 -- x_status Status of the new budget
23 -- x_master_budget_ver_id Version ID of the master budget of the new
24 -- budget
25 -- x_last_updated_by User ID of last person to
26 -- update the budget
27 -- x_last_update_login Login ID of the last person
28 -- to update the budget
29 -- Example
30 -- gl_budget_versions_pkg.insert_record(
31 -- 1000, '3 Year Budget', 'O', null, 0, 0)
32 -- Notes
33 --
34 PROCEDURE insert_record(
35 x_budget_version_id NUMBER,
36 x_budget_name VARCHAR2,
37 x_status VARCHAR2,
38 x_master_budget_ver_id NUMBER,
39 x_last_updated_by NUMBER,
40 x_last_update_login NUMBER);
41
42 --
43 -- Procedure
44 -- update_record
45 -- Purpose
46 -- Updates the entry in gl_budget_versions associated with a given
47 -- budget.
48 -- History
49 -- 10-18-93 D. J. Ogg Created
50 -- Arguments
51 -- x_budget_version_id Version ID of the budget
52 -- x_budget_name Name of the budget
53 -- x_status Status of the budget
54 -- x_master_budget_ver_id Version ID of the master budget of the
55 -- budget
56 -- x_last_updated_by User ID of last person to
57 -- update the period
58 -- x_last_update_login Login ID of the last person
59 -- to update the period
60 -- Example
61 -- gl_budget_versions_pkg.update_record(
62 -- 1000, '3 Year Budget', 'O', null, 0, 0)
63 -- Notes
64 --
65 PROCEDURE update_record(
66 x_budget_version_id NUMBER,
67 x_budget_name VARCHAR2,
68 x_status VARCHAR2,
69 x_master_budget_ver_id NUMBER,
70 x_last_updated_by NUMBER,
71 x_last_update_login NUMBER);
72
73 --
74 -- Procedure
75 -- select_columns
76 -- Purpose
77 -- Gets the values of some columns from gl_budget_versions associated
78 -- with the given budget version id
79 -- History
80 -- 01-NOV-94 D. J. Ogg Created
81 -- Arguments
82 -- x_budget_version_id ID of the desired budget
83 -- x_budget_name Name of the budget
84 --
85 PROCEDURE select_columns(
86 x_budget_version_id NUMBER,
87 x_budget_name IN OUT NOCOPY VARCHAR2);
88
89 END gl_budget_versions_pkg;