[Home] [Help]
PACKAGE: APPS.GL_BUDGET_BATCHES_PKG
Source
1 PACKAGE gl_budget_batches_pkg AS
2 /* $Header: glibdbts.pls 120.6 2005/05/05 01:01:05 kvora ship $ */
3 --
4 -- Package
5 -- gl_budget_batches_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_budget_batches
8 -- History
9 -- 10-18-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- insert_budget
14 -- Purpose
15 -- Used to insert records into gl_budget_batches
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_ledger_id Ledger budget belongs to
22 -- x_last_updated_by User ID of last person to
23 -- update the budget
24 -- Example
25 -- gl_budget_batches_pkg.insert_budget(1000, 2, 0)
26 -- Notes
27 --
28 PROCEDURE insert_budget(
29 x_budget_version_id NUMBER,
30 x_ledger_id NUMBER,
31 x_last_updated_by NUMBER);
32
33 --
34 -- Procedure
35 -- insert_recurring
36 -- Purpose
37 -- Used to insert records into gl_budget_batches for the new created
38 -- recurring formula budget.
39 -- History
40 -- 20-FEB-1994 ERumanan Created.
41 -- Arguments
42 -- x_recurring_batch_id Recurring Batch ID of the new budget formula
43 -- x_last_updated_by User ID of last person to
44 -- update the budget
45 -- Example
46 -- gl_budget_batches_pkg.insert_recurring( 100, 0 )
47 -- Notes
48 --
49 PROCEDURE insert_recurring(
50 x_recurring_batch_id NUMBER,
51 x_last_updated_by NUMBER );
52
53
54 --
55 -- Procedure
56 -- delete_recurring
57 -- Purpose
58 -- Used to delete records from gl_budget_batches for the deleted
59 -- recurring formula budget.
60 -- History
61 -- 20-FEB-1994 ERumanan Created.
62 -- Arguments
63 -- x_recurring_batch_id Recurring Batch ID of the new budget formula
64 -- Example
65 -- gl_budget_batches_pkg.delete_recurring( 100 )
66 -- Notes
67 --
68 PROCEDURE delete_recurring( x_recurring_batch_id NUMBER );
69
70
71 --
72 -- Procedure
73 -- select_row
74 -- Purpose
75 -- Gets the row from gl_budget_batches.
76 -- History
77 -- 26-MAR-94 ERumanan Created.
78 -- Arguments
79 -- recinfo
80 -- gl_budget_batches
81 -- Example
82 -- select_row.recinfo;
83 -- Notes
84 --
85 PROCEDURE select_row( recinfo IN OUT NOCOPY gl_budget_batches%ROWTYPE );
86
87
88 --
89 -- Procedure
90 -- select_columns
91 -- Purpose
92 -- Gets the values for some columns.
93 -- History
94 -- 26-MAR-94 ERumanan Created.
95 -- Arguments
96 -- x_budget_version_id
97 -- x_recurring_batch_id
98 -- x_last_executed_date
99 -- x_last_executed_start_period
100 -- x_last_executed_end_period
101 -- x_status
102 -- Example
103 -- gl_budget_batches_pkg.select_columns( :block.x_budget_version_id,
104 -- :block.x_recurring_batch_id,
105 -- :block.x_last_executed_date,
106 -- :block.x_last_executed_start_period,
107 -- :block.x_last_executed_end_period,
108 -- :block.x_status );
109 -- Notes
110 --
111 PROCEDURE select_columns(
112 x_budget_version_id NUMBER,
113 x_recurring_batch_id NUMBER,
114 x_last_executed_date IN OUT NOCOPY DATE,
115 x_last_executed_start_period IN OUT NOCOPY VARCHAR2,
116 x_last_executed_end_period IN OUT NOCOPY VARCHAR2,
117 x_status IN OUT NOCOPY VARCHAR2 );
118
119
120
121 END gl_budget_batches_pkg;