[Home] [Help]
PACKAGE: APPS.GL_HISTORICAL_RATES_PKG
Source
1 PACKAGE GL_HISTORICAL_RATES_PKG as
2 /* $Header: glirthts.pls 120.5 2005/06/19 16:55:37 mgowda ship $ */
3
4 TYPE SegmentArray IS TABLE OF VARCHAR2(200)
5 INDEX BY BINARY_INTEGER;
6 --
7 -- Procedure
8 -- check_unique
9 -- Purpose
10 -- Make sure the new row is unique.
11 -- History
12 -- 14-APR-94 ERumanan Created.
13 -- Arguments
14 -- x_rowid
15 -- x_ledger_id
16 -- x_code_combination_id
17 -- x_period_name
18 -- x_target_currency
19 -- x_usage_code
20 -- Example
21 -- GL_HISTORICAL_RATES_PKG.check_unique( '12345', 1, 10000, 'JAN-94', 'USD', 'S' );
22 -- Notes
23 --
24 PROCEDURE check_unique( x_rowid VARCHAR2,
25 x_ledger_id NUMBER,
26 x_code_combination_id NUMBER,
27 x_period_name VARCHAR2,
28 x_target_currency VARCHAR2,
29 x_usage_code VARCHAR2);
30
31
32
33
34 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
35 X_Ledger_Id NUMBER,
36 X_Period_Name VARCHAR2,
37 X_Period_Num NUMBER,
38 X_Period_Year NUMBER,
39 X_Code_Combination_Id NUMBER,
40 X_Target_Currency VARCHAR2,
41 X_Update_Flag VARCHAR2,
42 X_Last_Update_Date DATE,
43 X_Last_Updated_By NUMBER,
44 X_Creation_Date DATE,
45 X_Created_By NUMBER,
46 X_Last_Update_Login NUMBER,
47 X_Rate_Type VARCHAR2,
48 X_Translated_Rate NUMBER,
49 X_Translated_Amount NUMBER,
50 X_Account_Type VARCHAR2,
51 X_Attribute1 VARCHAR2,
52 X_Attribute2 VARCHAR2,
53 X_Attribute3 VARCHAR2,
54 X_Attribute4 VARCHAR2,
55 X_Attribute5 VARCHAR2,
56 X_Context VARCHAR2,
57 X_Usage_Code VARCHAR2,
58 X_Chart_of_Accounts_Id NUMBER
59 );
60
61 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
62 X_Ledger_Id NUMBER,
63 X_Period_Name VARCHAR2,
64 X_Period_Num NUMBER,
65 X_Period_Year NUMBER,
66 X_Code_Combination_Id NUMBER,
67 X_Target_Currency VARCHAR2,
68 X_Update_Flag VARCHAR2,
69 X_Rate_Type VARCHAR2,
70 X_Translated_Rate NUMBER,
71 X_Translated_Amount NUMBER,
72 X_Account_Type VARCHAR2,
73 X_Attribute1 VARCHAR2,
74 X_Attribute2 VARCHAR2,
75 X_Attribute3 VARCHAR2,
76 X_Attribute4 VARCHAR2,
77 X_Attribute5 VARCHAR2,
78 X_Context VARCHAR2,
79 X_Usage_Code VARCHAR2
80 );
81
82 PROCEDURE Update_Row(X_Rowid VARCHAR2,
83 X_Ledger_Id NUMBER,
84 X_Period_Name VARCHAR2,
85 X_Period_Num NUMBER,
86 X_Period_Year NUMBER,
87 X_Code_Combination_Id NUMBER,
88 X_Target_Currency VARCHAR2,
89 X_Update_Flag VARCHAR2,
90 X_Last_Update_Date DATE,
91 X_Last_Updated_By NUMBER,
92 X_Last_Update_Login NUMBER,
93 X_Rate_Type VARCHAR2,
94 X_Translated_Rate NUMBER,
95 X_Translated_Amount NUMBER,
96 X_Account_Type VARCHAR2,
97 X_Attribute1 VARCHAR2,
98 X_Attribute2 VARCHAR2,
99 X_Attribute3 VARCHAR2,
100 X_Attribute4 VARCHAR2,
101 X_Attribute5 VARCHAR2,
102 X_Context VARCHAR2,
103 X_Usage_Code VARCHAR2,
104 X_Chart_of_Accounts_Id NUMBER
105 );
106
107 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
108
109
110
111 --
112 -- Procedure
113 -- valdiate_seg_2
114 -- Purpose
115 -- This is the PL/SQL API will be used in the download SQL of
116 -- Historical Rates Web ADI Spreadsheet.
117 -- History
118 -- 09-May-2003 Alan Wen Created.
119 -- Arguments
120 -- 2
121 -- Example
122 --
123 -- Notes
124 --
125
126 FUNCTION valdiate_seg_2(x_chart_of_accounts_id NUMBER,
127 x_concat_segments VARCHAR2)
128 RETURN NUMBER;
129
130 --
131 -- Procedure
132 -- valdiate_seg
133 -- Purpose
134 -- This is the PL/SQL API will be used in the download SQL of
135 -- Historical Rates Web ADI Spreadsheet.
136 -- History
137 -- 09-May-2003 Alan Wen Created.
138 -- Arguments
139 -- 2
140 -- Example
141 --
142 -- Notes
143 --
144
145 FUNCTION valdiate_seg(x_chart_of_accounts_id NUMBER,
146 x_combination_id NUMBER)
147 RETURN NUMBER;
148
149 --
150 -- Procedure
151 -- Insert_Row_WebADI_Wrapper
152 -- Purpose
153 -- This is the PL/SQL interface for the Web ADI spreadsheet interface
154 -- of Historical Rates. The spreadsheet upload data to this interface
155 -- and this interface will insert data to gl_historical_rates table.
156 -- History
157 -- 14-Jan-03 Alan Wen Created.
158 -- Arguments
159 -- 39
160 -- Example
161 --
162 -- Notes
163 --
164
165 PROCEDURE Insert_Row_WebADI_Wrapper(X_Ledger IN VARCHAR2,
166 X_Functional_Currency IN VARCHAR2, X_Target_Currency IN VARCHAR2,
167 X_PERIOD_NAME IN VARCHAR2, X_Value_Type IN VARCHAR2, X_Value IN NUMBER,
168 X_Rate_Type IN VARCHAR2, X_Usage_Code IN VARCHAR2,
169 X_Segment1 IN VARCHAR2, X_Segment2 IN VARCHAR2, X_Segment3 IN VARCHAR2,
170 X_Segment4 IN VARCHAR2, X_Segment5 IN VARCHAR2, X_Segment6 IN VARCHAR2,
171 X_Segment7 IN VARCHAR2, X_Segment8 IN VARCHAR2, X_Segment9 IN VARCHAR2,
172 X_Segment10 IN VARCHAR2, X_Segment11 IN VARCHAR2,
173 X_Segment12 IN VARCHAR2, X_Segment13 IN VARCHAR2,
174 X_Segment14 IN VARCHAR2, X_Segment15 IN VARCHAR2,
175 X_Segment16 IN VARCHAR2, X_Segment17 IN VARCHAR2,
176 X_Segment18 IN VARCHAR2, X_Segment19 IN VARCHAR2,
177 X_Segment20 IN VARCHAR2, X_Segment21 IN VARCHAR2,
178 X_Segment22 IN VARCHAR2, X_Segment23 IN VARCHAR2,
179 X_Segment24 IN VARCHAR2, X_Segment25 IN VARCHAR2,
180 X_Segment26 IN VARCHAR2, X_Segment27 IN VARCHAR2,
181 X_Segment28 IN VARCHAR2, X_Segment29 IN VARCHAR2,
182 X_Segment30 IN VARCHAR2);
183
184 --
185 -- Procedure
186 -- get_bal_seg
187 -- Purpose
188 -- Given COA, the function returns the balance segment number
189 -- History
190 -- 14-Jan-03 Alan Wen Created.
191 -- Arguments
192 -- x_chart_of_accounts_id
193 -- Example
194 --
195 -- Notes
196 --
197
198 FUNCTION get_bal_seg(x_chart_of_accounts_id NUMBER)
199 RETURN NUMBER;
200
201 END GL_HISTORICAL_RATES_PKG;