eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ASO_BI_POPULATE_FACTS dependencies on ASO_BI_CURRENCY_RATES

Line 31: MERGE INTO ASO_BI_CURRENCY_RATES RATES

27: l_func_rate_type := fnd_profile.value('BIS_TREASURY_RATE_TYPE');
28:
29: IF p_run_type = 'INIT' THEN -- initial
30:
31: MERGE INTO ASO_BI_CURRENCY_RATES RATES
32: USING (SELECT txn_currency,
33: exchange_date,
34: FII_CURRENCY.get_rate(txn_currency,
35: g_prim_currency,

Line 91: MERGE INTO ASO_BI_CURRENCY_RATES RATES

87: trans.func_currency_code,
88: trans.org_id
89: );
90: ELSE -- incremental
91: MERGE INTO ASO_BI_CURRENCY_RATES RATES
92: USING (SELECT txn_currency,
93: exchange_date,
94: FII_CURRENCY.get_rate(txn_currency,
95: g_prim_currency,

Line 153: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_CURRENCY_RATES');

149: );
150: END IF;
151: COMMIT;
152: BIS_COLLECTION_UTILITIES.put_line('Currency Rates Table Populated Successfully!');
153: ASO_BI_UTIL_PVT.Analyze_Table('ASO_BI_CURRENCY_RATES');
154: BIS_COLLECTION_UTILITIES.put_line('Currency Rates Table Analyzed');
155: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
156: BIS_COLLECTION_UTILITIES.Debug('End of Populate Currency Rates');
157: END IF;

Line 185: FROM ASO_BI_CURRENCY_RATES

181: SELECT txn_currency from_currency,
182: g_prim_currency to_currency,
183: exchange_date,
184: prim_conversion_rate
185: FROM ASO_BI_CURRENCY_RATES
186: WHERE (prim_conversion_rate < 0
187: OR prim_conversion_rate IS NULL)
188: ORDER BY exchange_date,txn_currency ;
189:

Line 201: FROM ASO_BI_CURRENCY_RATES

197: prim_conversion_rate,
198: g_sec_currency to_sec_currency,
199: sec_conversion_rate,
200: exchange_date
201: FROM ASO_BI_CURRENCY_RATES
202: WHERE( (sec_conversion_rate < 0 OR sec_conversion_rate IS NULL)
203: OR (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL))
204: ORDER BY exchange_date,txn_currency;
205: BEGIN

Line 210: FROM ASO_BI_CURRENCY_RATES

206:
207: l_msg_name := 'BIS_DBI_CURR_NO_LOAD';
208: IF p_currency_type = 'P' THEN --check missing primary currency rates
209: SELECT COUNT(*) INTO l_cnt_miss_rate
210: FROM ASO_BI_CURRENCY_RATES
211: WHERE (prim_conversion_rate < 0
212: OR prim_conversion_rate IS NULL) and rownum < 2;
213:
214: If(l_cnt_miss_rate > 0 ) Then

Line 242: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

238: p_to_currency => rate_record.to_currency,
239: p_date => rate_record.exchange_date);
240: END IF;
241: END LOOP;
242: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
243: RETURN -1;
244: End If;
245: Return 1;
246: Else -- check missing primary/secondary currency rates

Line 248: FROM ASO_BI_CURRENCY_RATES

244: End If;
245: Return 1;
246: Else -- check missing primary/secondary currency rates
247: SELECT COUNT(*) INTO l_cnt_miss_rate
248: FROM ASO_BI_CURRENCY_RATES
249: WHERE ((sec_conversion_rate < 0 OR sec_conversion_rate IS NULL)
250: OR (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)) and rownum < 2;
251:
252: If(l_cnt_miss_rate > 0 ) Then

Line 301: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

297: p_date => rate_record.exchange_date);
298: END IF;
299: END IF;
300: END LOOP;
301: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
302: RETURN -1;
303: End If;
304: Return 1;
305: End If;

Line 330: FROM aso_bi_currency_rates

326: prim_conversion_rate to_prim_rate,
327: func_currency_code to_func_currency,
328: func_conversion_rate to_func_rate,
329: exchange_date
330: FROM aso_bi_currency_rates
331: WHERE (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)
332: OR
333: (func_conversion_rate < 0 OR func_conversion_rate IS NULL)
334: ORDER BY exchange_date,txn_currency;

Line 345: FROM ASO_BI_CURRENCY_RATES

341: func_conversion_rate to_func_rate,
342: g_sec_currency to_sec_currency,
343: sec_conversion_rate to_sec_rate,
344: exchange_date
345: FROM ASO_BI_CURRENCY_RATES
346: WHERE ((prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)
347: OR (func_conversion_rate < 0 OR func_conversion_rate IS NULL)
348: OR (sec_conversion_rate < 0 OR sec_conversion_rate IS NULL))
349: ORDER BY exchange_date,txn_currency;

Line 357: SELECT COUNT(*) INTO l_cnt_miss_rate FROM ASO_BI_CURRENCY_RATES

353:
354: l_msg_name := 'BIS_DBI_CURR_NO_LOAD';
355:
356: IF p_currency_type = 'PF' THEN
357: SELECT COUNT(*) INTO l_cnt_miss_rate FROM ASO_BI_CURRENCY_RATES
358: WHERE ((prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)
359: OR (func_conversion_rate<0 OR func_conversion_rate IS NULL)) and rownum < 2;
360: ELSE
361: SELECT COUNT(*) INTO l_cnt_miss_rate FROM ASO_BI_CURRENCY_RATES

Line 361: SELECT COUNT(*) INTO l_cnt_miss_rate FROM ASO_BI_CURRENCY_RATES

357: SELECT COUNT(*) INTO l_cnt_miss_rate FROM ASO_BI_CURRENCY_RATES
358: WHERE ((prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)
359: OR (func_conversion_rate<0 OR func_conversion_rate IS NULL)) and rownum < 2;
360: ELSE
361: SELECT COUNT(*) INTO l_cnt_miss_rate FROM ASO_BI_CURRENCY_RATES
362: WHERE (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)
363: OR (func_conversion_rate<0 OR func_conversion_rate IS NULL)
364: OR (sec_conversion_rate <0 OR sec_conversion_rate IS NULL) and rownum < 2;
365: END IF;

Line 415: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

411: p_date => rate_record.exchange_date);
412: END IF;
413: END IF;
414: END LOOP;
415: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
416: RETURN -1;
417: ELSE --'PFS' check primary, functional and secondary missing currency
418: BIS_COLLECTION_UTILITIES.put_line_out('Missing Primary Currency/Functional/Secondary Currency Rates Found!');
419: BIS_COLLECTION_UTILITIES.put_line('Missing Primary Currency/Functional/Secondary Currency Rates Found!');

Line 474: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

470: p_date => rate_record.exchange_date);
471: END IF;
472: END IF;
473: END LOOP;
474: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
475: RETURN -1;
476: END IF;
477: End If;
478:

Line 734: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

730: retcode := -1;
731:
732: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
733:
734: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
735:
736: BIS_COLLECTION_UTILITIES.wrapup(
737: p_status => FALSE ,
738: p_message => sqlerrm,

Line 750: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

746: BIS_COLLECTION_UTILITIES.Debug('Error in Populate Facts:'||errbuf);
747: END IF;
748:
749: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_HDRS_STG');
750: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
751:
752: BIS_COLLECTION_UTILITIES.wrapup(
753: p_status => FALSE ,
754: p_message => sqlerrm,

Line 903: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

899: retcode := -1;
900:
901: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
902:
903: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
904:
905: BIS_COLLECTION_UTILITIES.wrapup(
906: p_status => FALSE ,
907: p_message => sqlerrm,

Line 919: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

915: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of Quote Hdr Fact:'
916: ||errbuf);
917: END IF;
918:
919: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
920:
921: BIS_COLLECTION_UTILITIES.wrapup(
922: p_status => FALSE ,
923: p_message => sqlerrm,

Line 1047: FROM ASO_BI_CURRENCY_RATES

1043: ASO_BI_LINE_FACT_PVT.Populate_Quote_Line_Ids;
1044:
1045: /* Populate Currency Rates Table*/
1046: SELECT COUNT(*) INTO l_curr_count
1047: FROM ASO_BI_CURRENCY_RATES
1048: WHERE rownum < 2;
1049: IF l_curr_count = 0 THEN
1050: Populate_Conversion_Rates(p_from_date => l_from_date,
1051: p_to_date => l_to_date,

Line 1125: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1121: ASO_BI_LINE_FACT_PVT.Populate_Line_Data;
1122: BIS_COLLECTION_UTILITIES.put_line('Quote Line Fact Table Populated');
1123:
1124: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1125: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1126:
1127: BIS_COLLECTION_UTILITIES.wrapup(
1128: p_status => TRUE ,
1129: p_count => 0,

Line 1140: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1136: retcode := -1;
1137:
1138: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
1139:
1140: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1141:
1142: BIS_COLLECTION_UTILITIES.wrapup(
1143: p_status => FALSE ,
1144: p_message => sqlerrm,

Line 1155: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1151: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
1152: BIS_COLLECTION_UTILITIES.Debug('Error in Populate Lines Fact:'||errbuf);
1153: END IF;
1154: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1155: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1156:
1157: BIS_COLLECTION_UTILITIES.wrapup(
1158: p_status => FALSE ,
1159: p_message => sqlerrm,

Line 1299: FROM ASO_BI_CURRENCY_RATES

1295: END IF;
1296:
1297: /* Populate Currency Rates Table*/
1298: SELECT COUNT(*) INTO l_curr_count
1299: FROM ASO_BI_CURRENCY_RATES
1300: WHERE rownum < 2;
1301: IF l_curr_count = 0 THEN
1302: Populate_Conversion_Rates(p_from_date => l_from_date,
1303: p_to_date => l_to_date,

Line 1340: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1336: ASO_BI_LINE_FACT_PVT.InitiLoad_QotLine;
1337: BIS_COLLECTION_UTILITIES.put_line('Quote Line Fact Table Populated');
1338:
1339: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1340: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1341:
1342: BIS_COLLECTION_UTILITIES.wrapup(
1343: p_status => TRUE ,
1344: p_count => 0,

Line 1355: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1351: WHEN G_PROFILE_NOT_SET THEN -- PROFILE NOT SET exception
1352: retcode := -1;
1353:
1354: BIS_COLLECTION_UTILITIES.put_line('Required Profiles are not set! ');
1355: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1356:
1357: BIS_COLLECTION_UTILITIES.wrapup(
1358: p_status => FALSE ,
1359: p_message => sqlerrm,

Line 1371: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');

1367: BIS_COLLECTION_UTILITIES.Debug('Error in Initial Load of Quote Line Fact:'
1368: ||errbuf);
1369: END IF;
1370: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_QUOTE_LINES_STG');
1371: ASO_BI_UTIL_PVT.Truncate_Table('ASO_BI_CURRENCY_RATES');
1372:
1373: BIS_COLLECTION_UTILITIES.wrapup(
1374: p_status => FALSE ,
1375: p_message => sqlerrm,