[Home] [Help]
PACKAGE: APPS.GL_CONSOLIDATION_PKG
Source
1 PACKAGE GL_CONSOLIDATION_PKG as
2 /* $Header: glicosts.pls 120.11 2005/05/05 01:06:24 kvora ship $ */
3 --
4 -- Package
5 -- gl_consolidation_pkg
6 -- Purpose
7 -- Package procedures for Consolidation Setup form,
8 -- Consolidation block
9 -- History
10 -- 01/03/94 E Wilson Created
11 --
12
13 --
14 -- Procedure
15 -- Insert_Row
16 -- Purpose
17 -- Insert new records into table GL_CONSOLIDATION
18 -- Arguments
19 -- <table columns>
20 -- Example
21 -- GL_CONSOLIDATION_PKG.Insert_Row(<table columns>)
22 -- Notes
23 --
24 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_Consolidation_Id IN OUT NOCOPY NUMBER,
26 X_Name VARCHAR2,
27 X_Coa_Mapping_Id NUMBER,
28 X_Last_Update_Date DATE,
29 X_Last_Updated_By NUMBER,
30 X_From_Ledger_Id NUMBER,
31 X_To_Ledger_Id NUMBER,
32 X_Creation_Date DATE,
33 X_Created_By NUMBER,
34 X_Last_Update_Login NUMBER,
35 X_Description VARCHAR2,
36 X_Method VARCHAR2,
37 X_From_Currency_Code VARCHAR2,
38 X_From_Location VARCHAR2,
39 X_From_Oracle_Id VARCHAR2,
40 X_Attribute1 VARCHAR2,
41 X_Attribute2 VARCHAR2,
42 X_Attribute3 VARCHAR2,
43 X_Attribute4 VARCHAR2,
44 X_Attribute5 VARCHAR2,
45 X_Context VARCHAR2,
46 X_Usage VARCHAR2,
47 X_Run_Journal_Import_Flag VARCHAR2,
48 X_Audit_Mode_Flag VARCHAR2,
49 X_Summarize_Lines_Flag VARCHAR2,
50 X_Run_Posting_Flag VARCHAR2,
51 X_Security_Flag VARCHAR2
52 );
53
54 --
55 -- Procedure
56 -- Lock_Row
57 -- Purpose
58 -- Lock records in table GL_CONSOLIDATION
59 -- Arguments
60 -- <table columns>
61 -- Example
62 -- GL_CONSOLIDATION_PKG.Lock_Row(<table columns>)
63 -- Notes
64 --
65 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
66 X_Consolidation_Id NUMBER,
67 X_Name VARCHAR2,
68 X_Coa_Mapping_Id NUMBER,
69 X_From_Ledger_Id NUMBER,
70 X_To_Ledger_Id NUMBER,
71 X_Description VARCHAR2,
72 X_Method VARCHAR2,
73 X_From_Currency_Code VARCHAR2,
74 X_From_Location VARCHAR2,
75 X_From_Oracle_Id VARCHAR2,
76 X_Attribute1 VARCHAR2,
77 X_Attribute2 VARCHAR2,
78 X_Attribute3 VARCHAR2,
79 X_Attribute4 VARCHAR2,
80 X_Attribute5 VARCHAR2,
81 X_Context VARCHAR2,
82 X_Usage VARCHAR2,
83 X_Security_Flag VARCHAR2
84 );
85
86 --
87 -- Procedure
88 -- Update_Row
89 -- Purpose
90 -- Update table GL_CONSOLIDATION
91 -- Arguments
92 -- <table columns>
93 -- Example
94 -- GL_CONSOLIDATION_PKG.Update_Row(<table columns>)
95 -- Notes
96 --
97 PROCEDURE Update_Row(X_Rowid VARCHAR2,
98 X_Consolidation_Id NUMBER,
99 X_Name VARCHAR2,
100 X_Coa_Mapping_Id NUMBER,
101 X_Last_Update_Date DATE,
102 X_Last_Updated_By NUMBER,
103 X_From_Ledger_Id NUMBER,
104 X_To_Ledger_Id NUMBER,
105 X_Last_Update_Login NUMBER,
106 X_Description VARCHAR2,
107 X_Method VARCHAR2,
108 X_From_Currency_Code VARCHAR2,
109 X_From_Location VARCHAR2,
110 X_From_Oracle_Id VARCHAR2,
111 X_Attribute1 VARCHAR2,
112 X_Attribute2 VARCHAR2,
113 X_Attribute3 VARCHAR2,
114 X_Attribute4 VARCHAR2,
115 X_Attribute5 VARCHAR2,
116 X_Context VARCHAR2,
117 X_Usage VARCHAR2,
118 X_Run_Journal_Import_Flag VARCHAR2,
119 X_Audit_Mode_Flag VARCHAR2,
120 X_Summarize_Lines_Flag VARCHAR2,
121 X_Run_Posting_Flag VARCHAR2,
122 X_Security_Flag VARCHAR2
123 );
124
125 --
126 -- Procedure
127 -- Delete_Row
128 -- Purpose
129 -- Delete records from table GL_CONSOLIDATION
130 -- Arguments
131 -- Row_Id Rowid of row to be deleted
132 -- Example
133 -- GL_CONSOLIDATION_PKG.Delete_Row(:CONSOLIDATION.Row_Id)
134 -- Notes
135 --
136 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Consolidation_Id NUMBER);
137
138 --
139 -- Procedure
140 -- Check_Unique_Name
141 -- Purpose
142 -- Check if Consolidation name is unique
143 -- Arguments
144 -- X_Rowid Rowid of record to be checked
145 -- Example
146 -- GL_CONSOLIDATION_PKG.Check_Unique_Name(:CONSOLIDATION.row_id,
147 -- :CONSOLIDATION.name)
148 -- Notes
149 --
150 PROCEDURE Check_Unique_Name(X_Rowid VARCHAR2,
151 X_Name VARCHAR2);
152
153 --
154 -- Procedure
155 -- Check_Unique
156 -- Purpose
157 -- Check uniqueness of unique id
158 -- Arguments
159 -- X_Rowid Rowid of record to be checked
160 -- X_Consolidation_Id Value of unique id
161 -- Example
162 -- GL_CONSOLIDATION_PKG.Check_Unique(:CONSOLIDATION.row_id,
163 -- :CONSOLIDATION.consolidation_id)
164 -- Notes
165 --
166 PROCEDURE Check_Unique(X_Rowid VARCHAR2,
167 X_Consolidation_Id NUMBER);
168
169 --
170 -- Procedure
171 -- Check_Mapping_Used_In_Sets
172 -- Purpose
173 -- Check at the time changing the consolidation method whether the
174 -- mapping is part of a mapping set.
175 -- Arguments
176 -- X_Consolidation_Id
177 -- X_Mapping_Used_In_Set
178 -- Example
179 -- Notes
180 --
181 PROCEDURE Check_Mapping_Used_In_Sets( X_Consolidation_Id NUMBER,
182 X_Mapping_Used_In_Set IN OUT NOCOPY VARCHAR2);
183 --
184 -- Procedure
185 -- Check_Mapping_Run
186 -- Purpose
187 -- Check whether the Mapping has been run atleast once.
188 -- Arguments
189 -- X_Consolidation_Id
190 -- Example
191 -- Notes
192 --
193 PROCEDURE Check_Mapping_Run( X_Consolidation_Id NUMBER,
194 X_Mapping_Has_Been_Run IN OUT NOCOPY VARCHAR2);
195
196 END GL_CONSOLIDATION_PKG;