18: /* another currency */
19:
20: /* */
21:
22: /* p_api_version Standard IN param */
23:
24: /* p_commit Standard IN param */
25:
26: /* p_init_msg_list Standard IN param */
20: /* */
21:
22: /* p_api_version Standard IN param */
23:
24: /* p_commit Standard IN param */
25:
26: /* p_init_msg_list Standard IN param */
27:
28: /* p_validation_level Standard IN param */
22: /* p_api_version Standard IN param */
23:
24: /* p_commit Standard IN param */
25:
26: /* p_init_msg_list Standard IN param */
27:
28: /* p_validation_level Standard IN param */
29:
30: /* p_from_currency Required Currency code to convert from */
24: /* p_commit Standard IN param */
25:
26: /* p_init_msg_list Standard IN param */
27:
28: /* p_validation_level Standard IN param */
29:
30: /* p_from_currency Required Currency code to convert from */
31:
32: /* p_to_currency Required Currency code to convert to */
36: /* p_amount Required Amount to convert */
37:
38: /* x_conv_amount Converted amount */
39:
40: /* x_return_status Standard OUT param */
41:
42: /* x_msg_count Standard OUT param */
43:
44: /* x_msg_data Standard OUT param */
38: /* x_conv_amount Converted amount */
39:
40: /* x_return_status Standard OUT param */
41:
42: /* x_msg_count Standard OUT param */
43:
44: /* x_msg_data Standard OUT param */
45:
46: /* */
40: /* x_return_status Standard OUT param */
41:
42: /* x_msg_count Standard OUT param */
43:
44: /* x_msg_data Standard OUT param */
45:
46: /* */
47:
48: /*----------------------------------------------------------------*/
81: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_util.Convert_CurrencyAmount';
82:
83: BEGIN
84:
85: -- Standard Start of API savepoint
86:
87: SAVEPOINT Convert_CurrencyAmount_Utl;
88:
89: -- Standard call to check for call compatibility.
85: -- Standard Start of API savepoint
86:
87: SAVEPOINT Convert_CurrencyAmount_Utl;
88:
89: -- Standard call to check for call compatibility.
90:
91: IF NOT FND_API.Compatible_API_Call(l_api_version,
92: p_api_version,
93: l_api_name,
175: --
176: -- End API Body
177: --
178:
179: -- Standard check of p_commit.
180:
181: IF FND_API.To_Boolean(p_commit)
182: THEN
183: COMMIT WORK;
182: THEN
183: COMMIT WORK;
184: END IF;
185:
186: -- Standard call to get message count and IF count is get message info.
187:
188: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
189: EXCEPTION
190: WHEN FND_API.G_EXC_ERROR THEN
263: /* Difference will be in currency of compare amts */
264:
265: /* */
266:
267: /* p_api_version Standard IN param */
268:
269: /* p_commit Standard IN param */
270:
271: /* p_init_msg_list Standard IN param */
265: /* */
266:
267: /* p_api_version Standard IN param */
268:
269: /* p_commit Standard IN param */
270:
271: /* p_init_msg_list Standard IN param */
272:
273: /* p_validation_level Standard IN param */
267: /* p_api_version Standard IN param */
268:
269: /* p_commit Standard IN param */
270:
271: /* p_init_msg_list Standard IN param */
272:
273: /* p_validation_level Standard IN param */
274:
275: /* p_mle_totals_basis required Totals to use as basis */
269: /* p_commit Standard IN param */
270:
271: /* p_init_msg_list Standard IN param */
272:
273: /* p_validation_level Standard IN param */
274:
275: /* p_mle_totals_basis required Totals to use as basis */
276:
277: /* p_mle_totals_compare required Totals to compare to basis */
279: /* x_diff Basis - Compare */
280:
281: /* x_pct_diff (Basis - Compare)*100/Basis */
282:
283: /* x_return_status Standard OUT param */
284:
285: /* x_msg_count Standard OUT param */
286:
287: /* x_msg_data Standard OUT param */
281: /* x_pct_diff (Basis - Compare)*100/Basis */
282:
283: /* x_return_status Standard OUT param */
284:
285: /* x_msg_count Standard OUT param */
286:
287: /* x_msg_data Standard OUT param */
288:
289: /* */
283: /* x_return_status Standard OUT param */
284:
285: /* x_msg_count Standard OUT param */
286:
287: /* x_msg_data Standard OUT param */
288:
289: /* */
290:
291: /*----------------------------------------------------------------*/
316: l_mod_name varchar2(2000) := 'csd.plsql.csd_cost_analysis_util.Compare_MLETotals';
317:
318: BEGIN
319:
320: -- Standard Start of API savepoint
321:
322: SAVEPOINT Compare_MLETotals_Utl;
323:
324: -- Standard call to check for call compatibility.
320: -- Standard Start of API savepoint
321:
322: SAVEPOINT Compare_MLETotals_Utl;
323:
324: -- Standard call to check for call compatibility.
325:
326: IF NOT FND_API.Compatible_API_Call(l_api_version,
327: p_api_version,
328: l_api_name,
431:
432: -- End API Body
433: --
434:
435: -- Standard check of p_commit.
436:
437: IF FND_API.To_Boolean(p_commit)
438: THEN
439: COMMIT WORK;
438: THEN
439: COMMIT WORK;
440: END IF;
441:
442: -- Standard call to get message count and IF count is get message info.
443:
444: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
445: EXCEPTION
446: WHEN FND_API.G_EXC_ERROR THEN