[Home] [Help]
PACKAGE: APPS.GL_ALLOC_FORMULAS_PKG
Source
1 PACKAGE gl_alloc_formulas_pkg AUTHID CURRENT_USER AS
2 /* $Header: glimafms.pls 120.5.12010000.2 2009/07/13 06:22:33 sommukhe 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 X_Validation_Status VARCHAR2
76 );
77
78 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
79 X_Allocation_Formula_Id NUMBER,
80 X_Allocation_Batch_Id NUMBER,
81 X_Name VARCHAR2,
82 X_Run_Sequence NUMBER,
83 X_Je_Category_Name VARCHAR2,
84 X_Full_Allocation_Flag VARCHAR2,
85 X_Conversion_Method_Code VARCHAR2,
86 X_Currency_Conversion_Type VARCHAR2,
87 X_Description VARCHAR2,
88 X_Validation_Status VARCHAR2
89 );
90
91 PROCEDURE Update_Row(X_Rowid VARCHAR2,
92 X_Allocation_Formula_Id NUMBER,
93 X_Allocation_Batch_Id NUMBER,
94 X_Name VARCHAR2,
95 X_Run_Sequence NUMBER,
96 X_Je_Category_Name VARCHAR2,
97 X_Full_Allocation_Flag VARCHAR2,
98 X_Conversion_Method_Code VARCHAR2,
99 X_Currency_Conversion_Type VARCHAR2,
100 X_Last_Update_Date DATE,
101 X_Last_Updated_By NUMBER,
102 X_Last_Update_Login NUMBER,
103 X_Description VARCHAR2,
104 X_Actual_Flag VARCHAR2,
105 X_Transaction_Currency VARCHAR2,
106 Currency_Changed IN OUT NOCOPY VARCHAR2,
107 X_Validation_Status VARCHAR2
108 );
109
110 PROCEDURE Delete_Row(Allocation_Formula_id NUMBER, X_Rowid VARCHAR2);
111
112
113 END gl_alloc_formulas_pkg;