[Home] [Help]
PACKAGE: APPS.GL_CONS_HISTORY_PKG
Source
1 PACKAGE GL_CONS_HISTORY_PKG AUTHID CURRENT_USER as
2 /* $Header: glicohis.pls 120.14 2005/05/05 01:05:15 kvora ship $ */
3 --+
4 --+ Package
5 --+ gl_consolidation_history_pkg
6 --+ Purpose
7 --+ Package procedures for Consolidation RUN form,
8 --+ Submit block
9 --+ History
10 --+ 20-APR-94 E Wilson Created
11 --+
12
13 --+
14 --+ Procedure
15 --+ Check_Calendar
16 --+ Purpose
17 --+ Compare the calendar types of the parent ledger and the
18 --+ subsidiary ledger
19 --+ Arguments
20 --+ to_ledger_id
21 --+ from_ledger_id
22 --+ Example
23 --+ GL_CONSOLIDATION_HISTORY_PKG.Check_Calendar(
24 --+ :SUBMIT.to_ledger_id,
25 --+ :SUBMIT.from_ledger_id)
26 --+ Notes
27 --+
28 PROCEDURE Check_Calendar(X_To_Ledger_Id NUMBER,
29 X_From_Ledger_Id NUMBER);
30
31 --+
32 --+ Procedure
33 --+ Get_New_Id
34 --+ Purpose
35 --+ Get next value from GL_CONSOLIDATION_HISTORY_S
36 --+ Arguments
37 --+ next_val Return next value in sequence
38 --+ Example
39 --+ GL_CONSOLIDATION_HISTORY_PKG.Get_New_Id(:SUBMIT.consolidation_run_id)
40 --+ Notes
41 --+
42 PROCEDURE Get_New_Id(next_val IN OUT NOCOPY NUMBER);
43
44 /* Name: first_period_of_quarter
45 * Desc: Returns the first non-adjusting period of the specified quarter
46 */
47 PROCEDURE first_period_of_quarter(
48 LedgerId NUMBER,
49 QuarterNum NUMBER,
50 QuarterYear NUMBER,
51 PeriodName IN OUT NOCOPY VARCHAR2,
52 StartDate IN OUT NOCOPY DATE,
53 ClosingStatus IN OUT NOCOPY VARCHAR2
54 );
55
56 /* Name: first_period_of_year
57 * Desc: Returns the first non-adjusting period of the specified year
58 */
59 PROCEDURE first_period_of_year(
60 LedgerId NUMBER,
61 PeriodYear NUMBER,
62 PeriodName IN OUT NOCOPY VARCHAR2,
63 StartDate IN OUT NOCOPY DATE,
64 ClosingStatus IN OUT NOCOPY VARCHAR2
65 );
66
67 /* Name: insert_average_record
68 * Desc: Copy the standard consolidation record for average consolidation.
69 */
70 PROCEDURE insert_average_record(
71 SourceRunId NUMBER,
72 TargetRunId NUMBER,
73 AverageToPeriodName VARCHAR2,
74 AvgAmountType VARCHAR2,
75 FromDateEntered DATE
76 );
77
78 /* Name: insert_row
79 * Desc: Table handler for insertion.
80 */
81 PROCEDURE Insert_Row(
82 X_Usage_Code VARCHAR2,
83 X_Rowid IN OUT NOCOPY VARCHAR2,
84 X_Consolidation_Run_Id NUMBER,
85 X_StdRunId IN OUT NOCOPY NUMBER,
86 X_AvgRunId IN OUT NOCOPY NUMBER,
87 X_Consolidation_Id NUMBER,
88 X_Last_Update_Date DATE,
89 X_Last_Updated_By NUMBER,
90 X_From_Period_Name VARCHAR2,
91 X_Standard_To_Period_Name VARCHAR2,
92 X_To_Period_Name IN OUT NOCOPY VARCHAR2,
93 X_To_Currency_Code VARCHAR2,
94 X_Method_Flag VARCHAR2,
95 X_Run_Easylink_Flag VARCHAR2,
96 X_Run_Posting_Flag VARCHAR2,
97 X_Actual_Flag VARCHAR2,
98 X_From_Budget_Name VARCHAR2,
99 X_To_Budget_Name VARCHAR2,
100 X_From_Budget_Version_Id NUMBER,
101 X_To_Budget_Version_Id NUMBER,
102 X_Amount_Type_Code VARCHAR2,
103 X_Amount_Type VARCHAR2,
104 X_StdAmountType VARCHAR2,
105 X_AvgAmountType VARCHAR2,
106 X_From_Date_Entered DATE,
107 X_From_Date IN OUT NOCOPY DATE,
108 X_Average_To_Period_Name VARCHAR2,
109 X_Target_Resp_Name VARCHAR2,
110 X_Target_User_Name VARCHAR2,
111 X_Target_DB_Name VARCHAR2
112 );
113
114 --+
115 --+ Procedure
116 --+ Insert_Cons_Set_Row
117 --+ Purpose
118 --+ Handle the pre-update logic for each selected consolidation in the
119 --+ Transfer Consolidation Set form.
120 --+ Example
121 --+ GL_CONS_HISTORY_PKG.Insert_Cons_Set_Row(
122 --+ arg1,
123 --+ arg2, ....... )
124 --+ Notes
125 --+
126
127 PROCEDURE Insert_Cons_Set_Row(
128 X_Usage_Code VARCHAR2,
129 X_Rowid VARCHAR2,
130 X_Std_Amounttype VARCHAR2,
131 X_Avg_Amounttype VARCHAR2,
132 X_Consolidation_Id NUMBER,
133 X_Consolidation_Set_Id NUMBER,
134 X_Last_Updated_By NUMBER,
135 X_From_Period_Name VARCHAR2,
136 X_Standard_To_Period_Name VARCHAR2,
137 X_Average_To_Period_Name VARCHAR2,
138 X_Average_To_Start_Date DATE,
139 X_To_Currency_Code VARCHAR2,
140 X_Method_Flag VARCHAR2,
141 X_Run_Journal_Import_Flag VARCHAR2,
142 X_Audit_Mode_Flag VARCHAR2,
143 X_Summary_Journals_Flag VARCHAR2,
144 X_Run_Posting_Flag VARCHAR2,
145 X_Actual_Flag VARCHAR2,
146 X_Consolidation_Name VARCHAR2,
147 X_From_Date_Entered DATE,
148 X_From_Ledger_Id NUMBER,
149 X_To_Ledger_Id NUMBER,
150 X_Check_Batches IN OUT NOCOPY VARCHAR2,
151 X_num_conc_requests IN OUT NOCOPY NUMBER,
152 X_Target_Resp_Name VARCHAR2,
153 X_Target_User_Name VARCHAR2,
154 X_Target_DB_Name VARCHAR2,
155 X_first_request_Id IN OUT NOCOPY number,
156 X_last_request_Id IN OUT NOCOPY number,
157 X_access_set_id NUMBER
158 );
159
160
161
162 --+
163 --+ Procedure
164 --+ Insert_For_Budgetyear
165 --+ Purpose
166 --+ Inserts a year worth of rows for budget consolidations for a year
167 --+ for the Consolidation Workbench functionality
168 --+ Example
169 --+ GL_CONS_HISTORY_PKG.Insert_For_Budgetyear(
170 --+ arg1,
171 --+ arg2, ....... )
172 --+ Notes
173 --+
174
175 PROCEDURE Insert_For_Budgetyear(
176 X_Consolidation_Run_Id NUMBER,
177 X_Consolidation_Id NUMBER,
178 X_Last_Update_Date DATE,
179 X_Last_Updated_By NUMBER,
180 X_From_Period_Name VARCHAR2,
181 X_To_Period_Name VARCHAR2,
182 X_To_Currency_Code VARCHAR2,
183 X_Method_Flag VARCHAR2,
184 X_Run_Easylink_Flag VARCHAR2,
185 X_Run_Posting_Flag VARCHAR2,
186 X_Actual_Flag VARCHAR2,
187 X_From_Budget_Name VARCHAR2,
188 X_To_Budget_Name VARCHAR2,
189 X_From_Budget_Version_Id NUMBER,
190 X_To_Budget_Version_Id NUMBER,
191 X_Consolidation_Set_Id NUMBER,
192 X_Status VARCHAR2,
193 X_Request_Id NUMBER,
194 X_Amount_Type_Code VARCHAR2,
195 X_ledger_id NUMBER,
196 X_Period_Year NUMBER,
197 X_Target_Resp_Name VARCHAR2,
198 X_Target_User_Name VARCHAR2,
199 X_Target_DB_Name VARCHAR2);
200
201 --+
202 --+ Procedure
203 --+ Insert_Status_ReqId
204 --+ Purpose
205 --+ Inserts the status and request id columns in GL_CONSOLIDATION_HISTORY
206 --+ for the Transfer Consolidation form.
207 --+ Example
208 --+ GL_CONS_HISTORY_PKG.Insert_Status_ReqId(
209 --+ arg1,
210 --+ arg2, ....... )
211 --+ Notes
212 --+
213
214 PROCEDURE Insert_Status_ReqId(
215 X_StdRunId NUMBER,
216 X_AvgRunId NUMBER,
217 X_StdReqId NUMBER,
218 X_AvgReqId NUMBER);
219
220
221 END GL_CONS_HISTORY_PKG;