[Home] [Help]
PACKAGE: APPS.GL_CONS_ACCOUNTS_PKG
Source
1 PACKAGE GL_CONS_ACCOUNTS_PKG as
2 /* $Header: glicoacs.pls 120.3 2005/05/05 01:04:00 kvora ship $ */
3 --
4 -- Package
5 -- gl_consolidation_accounts_pkg
6 -- Purpose
7 -- Package procedures for Consolidation RUN form,
8 -- Accounts block
9 -- History
10 -- 20-APR-94 E Wilson Created
11 --
12
13 --
14 -- Procedure
15 -- Insert_Consolidation_Accounts
16 -- Purpose
17 -- Insert records into GL_CONSOLIDATION_ACCOUNTS for new consolidation
18 -- Arguments
19 -- consolidation_run_id
20 -- consolidation_id
21 -- from_ledger_id Subsidiary ledger id
22 -- Example
23 -- GL_CONSOLIDATION_ACCOUNTS_PKG.Insert_Consolidation_Accounts(
24 -- :SUBMIT.consolidation_run_id,
25 -- :SUBMIT.consolidation_id,
26 -- :SUBMIT.from_ledger_id)
27 -- Notes
28 --
29 FUNCTION Insert_Consolidation_Accounts(
30 X_Consolidation_Run_Id NUMBER,
31 X_Consolidation_Id NUMBER,
32 X_From_Ledger_Id NUMBER) RETURN BOOLEAN;
33
34 --
35 -- Procedure
36 -- Check_Unique_Element_Sequence
37 -- Purpose
38 -- Verify element_sequence is unique for consolidation_id
39 -- consolidation_run_id combination
40 -- Arguments
41 -- rowid gl_consolidation_accounts rowid
42 -- consolidation_id
43 -- consolidation_run_id
44 -- element_sequence account ranges line number
45 -- Example
46 -- GL_CONSOLIDATION_ACCOUNTS_PKG.Check_Unique_Element_Sequence(
47 -- :ACCOUNTS.rowid
48 -- :SUBMIT.consolidation_id,
49 -- :SUBMIT.consolidation_run_id,
50 -- :ACCOUNTS.element_sequence)
51 -- Notes
52 --
53 PROCEDURE Check_Unique_Element_Sequence(
54 X_Rowid VARCHAR2,
55 X_Consolidation_Id NUMBER,
56 X_Consolidation_Run_Id NUMBER,
57 X_Element_Sequence NUMBER);
58
59 --
60 -- Procedure
61 -- Check_Account_Ranges_Overlap
62 -- Purpose
63 -- Verify that Account Ranges do not overlap
64 -- Arguments
65 -- rowid gl_consolidation_accounts rowid
66 -- consolidation_id
67 -- consolidation_run_id
68 -- segment1_low..segment30_low account low
69 -- segment1_high..segment30_high account high
70 --
71 PROCEDURE Check_Account_Ranges_Overlap(
72 X_Rowid VARCHAR2,
73 X_Consolidation_Id NUMBER,
74 X_Consolidation_Run_Id NUMBER,
75 X_Segment1_Low VARCHAR2,
76 X_Segment1_High VARCHAR2,
77 X_Segment2_Low VARCHAR2,
78 X_Segment2_High VARCHAR2,
79 X_Segment3_Low VARCHAR2,
80 X_Segment3_High VARCHAR2,
81 X_Segment4_Low VARCHAR2,
82 X_Segment4_High VARCHAR2,
83 X_Segment5_Low VARCHAR2,
84 X_Segment5_High VARCHAR2,
85 X_Segment6_Low VARCHAR2,
86 X_Segment6_High VARCHAR2,
87 X_Segment7_Low VARCHAR2,
88 X_Segment7_High VARCHAR2,
89 X_Segment8_Low VARCHAR2,
90 X_Segment8_High VARCHAR2,
91 X_Segment9_Low VARCHAR2,
92 X_Segment9_High VARCHAR2,
93 X_Segment10_Low VARCHAR2,
94 X_Segment10_High VARCHAR2,
95 X_Segment11_Low VARCHAR2,
96 X_Segment11_High VARCHAR2,
97 X_Segment12_Low VARCHAR2,
98 X_Segment12_High VARCHAR2,
99 X_Segment13_Low VARCHAR2,
100 X_Segment13_High VARCHAR2,
101 X_Segment14_Low VARCHAR2,
102 X_Segment14_High VARCHAR2,
103 X_Segment15_Low VARCHAR2,
104 X_Segment15_High VARCHAR2,
105 X_Segment16_Low VARCHAR2,
106 X_Segment16_High VARCHAR2,
107 X_Segment17_Low VARCHAR2,
108 X_Segment17_High VARCHAR2,
109 X_Segment18_Low VARCHAR2,
110 X_Segment18_High VARCHAR2,
111 X_Segment19_Low VARCHAR2,
112 X_Segment19_High VARCHAR2,
113 X_Segment20_Low VARCHAR2,
114 X_Segment20_High VARCHAR2,
115 X_Segment21_Low VARCHAR2,
116 X_Segment21_High VARCHAR2,
117 X_Segment22_Low VARCHAR2,
118 X_Segment22_High VARCHAR2,
119 X_Segment23_Low VARCHAR2,
120 X_Segment23_High VARCHAR2,
121 X_Segment24_Low VARCHAR2,
122 X_Segment24_High VARCHAR2,
123 X_Segment25_Low VARCHAR2,
124 X_Segment25_High VARCHAR2,
125 X_Segment26_Low VARCHAR2,
126 X_Segment26_High VARCHAR2,
127 X_Segment27_Low VARCHAR2,
128 X_Segment27_High VARCHAR2,
129 X_Segment28_Low VARCHAR2,
130 X_Segment28_High VARCHAR2,
131 X_Segment29_Low VARCHAR2,
132 X_Segment29_High VARCHAR2,
133 X_Segment30_Low VARCHAR2,
134 X_Segment30_High VARCHAR2
135 );
136
137 --
138 -- Procedure
139 -- Count_Ranges
140 -- Purpose
141 -- Count the number of existing ranges for a consolidation run
142 -- Arguments
143 -- consolidation_id
144 -- consolidation_run_id
145 -- Example
146 -- GL_CONSOLIDATION_ACCOUNTS_PKG.Ccount_Ranges(
147 -- :SUBMIT.consolidation_id,
148 -- :SUBMIT.consolidation_run_id)
149 -- Notes
150 --
151 FUNCTION Count_Ranges(
152 X_Consolidation_Id NUMBER,
153 X_Consolidation_Run_Id NUMBER) RETURN BOOLEAN;
154
155 /* Name: copy_ranges
156 * Desc: Copies the ranges for the source run id to the target run id.
157 */
158 PROCEDURE copy_ranges(
159 ConsolidationId NUMBER,
160 SourceRunId NUMBER,
161 TargetRunId NUMBER);
162
163
164 --
165 -- Procedure
166 -- Delete_Account_Range
167 -- Purpose
168 -- Delete the existing ranges for a consolidation run
169 -- Arguments
170 -- consolidation_id
171 -- std_consolidation_run_id
172 -- avg_consolidation_run_id
173 -- Example
174 -- GL_CONS_ACCOUNTS_PKG.Delete_Account_Range(
175 -- :SUBMIT.consolidation_id,
176 -- :SUBMIT.std_consolidation_run_id,
177 -- :SUBMIT.avg_consolidation_run_id)
178 -- Notes
179 --
180 PROCEDURE Delete_Account_Range(
181 ConsolidationId NUMBER,
182 StdRunId NUMBER,
183 AvgRunId NUMBER);
184
185
186 END GL_CONS_ACCOUNTS_PKG;