PACKAGE: APPS.GL_BUDGET_BATCHES_PKG

Source

1 PACKAGE gl_budget_batches_pkg AUTHID CURRENT_USER 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;