[Home] [Help]
PACKAGE: APPS.GL_ALLOC_BATCHES_PKG
Source
1 PACKAGE gl_alloc_batches_pkg AUTHID CURRENT_USER AS
2 /* $Header: glimabas.pls 120.5.12010000.2 2009/07/13 06:24:28 sommukhe ship $ */
3 --
4 -- Package
5 -- gl_alloc_batches_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_alloc_batches
8 -- History
9 -- 10-07-93 D. J. Ogg Created
10
11 --
12 -- Procedure
13 -- check_unique
14 -- Purpose
15 -- Checks to make sure that the name of the batch
16 -- is unique.
17 -- History
18 -- 10-01-93 D. J. Ogg Created
19 -- Arguments
20 -- batch_name The name of the batch
21 -- row_id The current rowid
22 -- Example
23 -- gl_alloc_batches_pkg.check_unique('Testing', 'ABD02334');
24 -- Notes
25 --
26 PROCEDURE check_unique(batch_name VARCHAR2, row_id VARCHAR2,
27 coa_id NUMBER);
28
29 --
30 -- Procedure
31 -- get_unique_id
32 -- Purpose
33 -- Gets a unique allocation batch id
34 -- History
35 -- 11-09-93 D. J. Ogg Created
36 -- Arguments
37 -- none
38 -- Example
39 -- abid := gl_alloc_batches_pkg.get_unique_id;
40 -- Notes
41 --
42 FUNCTION get_unique_id RETURN NUMBER;
43
44 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
45 X_Allocation_Batch_Id IN OUT NOCOPY NUMBER,
46 X_Name VARCHAR2,
47 X_Chart_Of_Accounts_Id NUMBER,
48 X_Actual_Flag VARCHAR2,
49 X_Security_Flag VARCHAR2,
50 X_Last_Update_Date DATE,
51 X_Last_Updated_By NUMBER,
52 X_Creation_Date DATE,
53 X_Created_By NUMBER,
54 X_Last_Update_Login NUMBER,
55 X_Description VARCHAR2,
56 X_Validation_Status VARCHAR2,
57 X_Validation_Request_Id NUMBER
58 );
59
60
61 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
62 X_Allocation_Batch_Id NUMBER,
63 X_Name VARCHAR2,
64 X_Chart_Of_Accounts_Id NUMBER,
65 X_Actual_Flag VARCHAR2,
66 X_Security_Flag VARCHAR2,
67 X_Description VARCHAR2,
68 X_Validation_Status VARCHAR2,
69 X_Validation_Request_Id NUMBER
70 );
71
72 PROCEDURE Update_Row(X_Rowid VARCHAR2,
73 X_Allocation_Batch_Id NUMBER,
74 X_Name VARCHAR2,
75 X_Chart_Of_Accounts_Id NUMBER,
76 X_Actual_Flag VARCHAR2,
77 X_Security_Flag VARCHAR2,
78 X_Last_Update_Date DATE,
79 X_Last_Updated_By NUMBER,
80 X_Last_Update_Login NUMBER,
81 X_Description VARCHAR2,
82 X_Validation_Status VARCHAR2,
83 X_Validation_Request_Id NUMBER
84 );
85
86
87 PROCEDURE Delete_Row(Allocation_Batch_Id NUMBER, X_Rowid VARCHAR2);
88
89
90 --
91 -- Procedure
92 -- Autocopy
93 -- Purpose
94 -- Copy the mass allocation formulas and formula lines
95 -- from the given source batch to target batch.
96 -- History
97 -- 18-MAR-1997 Mehmet Demirkol Created.
98 -- Arguments
99 -- x_src_batch_id Source allocation batch id.
100 -- x_trg_batch_id Target allocation batch id.
101 -- x_Last_Updated_By Who Information
102 -- X_Last_Update_Login
103 -- Example
104 -- gl_alloc_batches_pkg.Autocopy(
105 --
106 PROCEDURE Autocopy( X_Src_Batch_Id NUMBER,
107 X_Trg_Batch_Id NUMBER,
108 X_Last_Updated_By NUMBER,
109 X_Last_Update_Login NUMBER);
110
111 --
112 -- Procedure
113 -- Check_Batch
114 -- Purpose
115 -- Check that the batch is not used in any AutoAllocation set
116 -- History
117 -- 14-AUG-2003 K Chang Created.
118 -- Arguments
119 -- x_allocation_batch_id Source allocation batch id.
120 -- Example
121 -- gl_alloc_batches_pkg.check_batch(
122 --
123 PROCEDURE Check_Batch( X_Alloc_Batch_Id NUMBER);
124
125
126 END gl_alloc_batches_pkg;