PACKAGE: APPS.GL_ALLOC_BATCHES_PKG

Source

1 PACKAGE gl_alloc_batches_pkg AS
2 /* $Header: glimabas.pls 120.5 2005/05/05 01:11:34 kvora 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                       );
57 
58 
59   PROCEDURE Lock_Row(X_Rowid                            VARCHAR2,
60                      X_Allocation_Batch_Id              NUMBER,
61                      X_Name                             VARCHAR2,
62                      X_Chart_Of_Accounts_Id             NUMBER,
63                      X_Actual_Flag                      VARCHAR2,
64                      X_Security_Flag                    VARCHAR2,
65                      X_Description                      VARCHAR2
66                     );
67 
68   PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
69                        X_Allocation_Batch_Id            NUMBER,
70                        X_Name                           VARCHAR2,
71                        X_Chart_Of_Accounts_Id           NUMBER,
72                        X_Actual_Flag                    VARCHAR2,
73                        X_Security_Flag                  VARCHAR2,
74                        X_Last_Update_Date               DATE,
75                        X_Last_Updated_By                NUMBER,
76                        X_Last_Update_Login              NUMBER,
77                        X_Description                    VARCHAR2
78                       );
79 
80 
81   PROCEDURE Delete_Row(Allocation_Batch_Id NUMBER, X_Rowid VARCHAR2);
82 
83 
84   --
85   -- Procedure
86   --   Autocopy
87   -- Purpose
88   --   Copy the mass allocation formulas and formula lines
89   --   from the given source batch to target batch.
90   -- History
91   --   18-MAR-1997  Mehmet Demirkol   Created.
92   -- Arguments
93   --   x_src_batch_id	Source allocation batch id.
94   --   x_trg_batch_id   Target allocation batch id.
95   --   x_Last_Updated_By Who Information
96   --   X_Last_Update_Login
97   -- Example
98   --   gl_alloc_batches_pkg.Autocopy(
99   --
100      PROCEDURE Autocopy(    X_Src_Batch_Id      NUMBER,
101                             X_Trg_Batch_Id 	NUMBER,
102                             X_Last_Updated_By   NUMBER,
103                             X_Last_Update_Login NUMBER);
104 
105    --
106   -- Procedure
107   --   Check_Batch
108   -- Purpose
109   --   Check that the batch is not used in any AutoAllocation set
110   -- History
111   --   14-AUG-2003  K Chang   Created.
112   -- Arguments
113   --   x_allocation_batch_id	Source allocation batch id.
114   -- Example
115   --   gl_alloc_batches_pkg.check_batch(
116   --
117      PROCEDURE Check_Batch( X_Alloc_Batch_Id      NUMBER);
118 
119 
120 END gl_alloc_batches_pkg;