[Home] [Help]
PACKAGE: APPS.GL_ALLOC_FORMULAS_PKG
Source
1 PACKAGE gl_alloc_formulas_pkg AS
2 /* $Header: glimafms.pls 120.5 2005/05/05 01:17:03 kvora ship $ */
3 --
4 -- Package
5 -- gl_alloc_formulas_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for gl_alloc_formulas
8 -- History
9 -- 10-07-93 D. J. Ogg Created
10 --
11 -- Procedure
12 -- check_unique
13 -- Purpose
14 -- Checks to make sure that the name of the formula
15 -- is unique within that batch.
16 -- History
17 -- 10-01-93 D. J. Ogg Created
18 -- Arguments
19 -- batch_id The ID of the containing batch
20 -- formula_name The name of the formula
21 -- row_id The current rowid
22 -- Example
23 -- gl_alloc_formulas_pkg.check_unique(123, 'Testing', 'ABD02334');
24 -- Notes
25 --
26 PROCEDURE check_unique(batch_id NUMBER, formula_name VARCHAR2,
27 row_id VARCHAR2);
28
29 --
30 -- Procedure
31 -- get_unique_id
32 -- Purpose
33 -- Gets a unique allocation formula id
34 -- History
35 -- 11-09-93 D. J. Ogg Created
36 -- Arguments
37 -- none
38 -- Example
39 -- abid := gl_alloc_formulas_pkg.get_unique_id;
40 -- Notes
41 --
42 FUNCTION get_unique_id RETURN NUMBER;
43
44 --
45 -- Procedure
46 -- delete_rows
47 -- Purpose
48 -- Deletes all of the formulas in a batch
49 -- History
50 -- 09-JUN-94 D. J. Ogg Created
51 -- Arguments
52 -- batch_id The ID of the batch to delete
53 -- Example
54 -- gl_alloc_formulas_pkg.delete_rows(5);
55 -- Notes
56 --
57 PROCEDURE delete_rows(batch_id NUMBER);
58
59 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
60 X_Allocation_Formula_Id IN OUT NOCOPY NUMBER,
61 X_Allocation_Batch_Id IN OUT NOCOPY NUMBER,
62 X_Name VARCHAR2,
63 X_Run_Sequence NUMBER,
64 X_Je_Category_Name VARCHAR2,
65 X_Full_Allocation_Flag VARCHAR2,
66 X_Conversion_Method_Code VARCHAR2,
67 X_Currency_Conversion_Type VARCHAR2,
68 X_Last_Update_Date DATE,
69 X_Last_Updated_By NUMBER,
70 X_Creation_Date DATE,
71 X_Created_By NUMBER,
72 X_Last_Update_Login NUMBER,
73 X_Description VARCHAR2,
74 X_Actual_Flag VARCHAR2
75 );
76
77 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
78 X_Allocation_Formula_Id NUMBER,
79 X_Allocation_Batch_Id NUMBER,
80 X_Name VARCHAR2,
81 X_Run_Sequence NUMBER,
82 X_Je_Category_Name VARCHAR2,
83 X_Full_Allocation_Flag VARCHAR2,
84 X_Conversion_Method_Code VARCHAR2,
85 X_Currency_Conversion_Type VARCHAR2,
86 X_Description VARCHAR2
87 );
88
89 PROCEDURE Update_Row(X_Rowid VARCHAR2,
90 X_Allocation_Formula_Id NUMBER,
91 X_Allocation_Batch_Id NUMBER,
92 X_Name VARCHAR2,
93 X_Run_Sequence NUMBER,
94 X_Je_Category_Name VARCHAR2,
95 X_Full_Allocation_Flag VARCHAR2,
96 X_Conversion_Method_Code VARCHAR2,
97 X_Currency_Conversion_Type VARCHAR2,
98 X_Last_Update_Date DATE,
99 X_Last_Updated_By NUMBER,
100 X_Last_Update_Login NUMBER,
101 X_Description VARCHAR2,
102 X_Actual_Flag VARCHAR2,
103 X_Transaction_Currency VARCHAR2,
104 Currency_Changed IN OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE Delete_Row(Allocation_Formula_id NUMBER, X_Rowid VARCHAR2);
108
109
110 END gl_alloc_formulas_pkg;