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.

APPS.BIM_MARKET_FACTS_PKG dependencies on BIM_I_MARKETING_FACTS_STG

Line 424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';

420: EXCEPTION when others then
421: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: error:'||sqlerrm(sqlcode));
422: --dbms_output.put_line('error first:'||sqlerrm(sqlcode));
423: END;
424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
425: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
426: l_table_name :='bim_i_marketing_facts';
427: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting table bim_i_marketing_facts_stg');
428: /*fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

Line 427: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting table bim_i_marketing_facts_stg');

423: END;
424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
425: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
426: l_table_name :='bim_i_marketing_facts';
427: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting table bim_i_marketing_facts_stg');
428: /*fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
429: fnd_message.set_token('TABLE_NAME',l_table_name, FALSE);
430: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
431: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');

Line 433: INTO BIM_I_MARKETING_FACTS_STG CDF (

429: fnd_message.set_token('TABLE_NAME',l_table_name, FALSE);
430: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
431: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');
432: INSERT /*+ append parallel */
433: INTO BIM_I_MARKETING_FACTS_STG CDF (
434: --MKT_DAILY_TRANSACTION_ID ,
435: CREATION_DATE ,
436: LAST_UPDATE_DATE ,
437: CREATED_BY ,

Line 1973: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert into bim_i_marketing_facts_stg');

1969: ,conversion_rate_s) inner ;
1970:
1971: commit;
1972:
1973: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert into bim_i_marketing_facts_stg');
1974: -------------------------NEW CODE --------------
1975: INSERT /*+ append parallel */
1976: INTO BIM_I_MARKETING_FACTS_STG CDF (
1977: --MKT_DAILY_TRANSACTION_ID ,

Line 1976: INTO BIM_I_MARKETING_FACTS_STG CDF (

1972:
1973: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert into bim_i_marketing_facts_stg');
1974: -------------------------NEW CODE --------------
1975: INSERT /*+ append parallel */
1976: INTO BIM_I_MARKETING_FACTS_STG CDF (
1977: --MKT_DAILY_TRANSACTION_ID ,
1978: CREATION_DATE ,
1979: LAST_UPDATE_DATE ,
1980: CREATED_BY ,

Line 2548: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert into bim_i_marketing_facts_stg');

2544: ,conversion_rate_s
2545: ) inner ;
2546: ---------------------END NEW CODE------------------------
2547: commit;
2548: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert into bim_i_marketing_facts_stg');
2549: INSERT /*+ append parallel */
2550: INTO BIM_I_MARKETING_FACTS_STG CDF (
2551: --MKT_DAILY_TRANSACTION_ID ,
2552: CREATION_DATE ,

Line 2550: INTO BIM_I_MARKETING_FACTS_STG CDF (

2546: ---------------------END NEW CODE------------------------
2547: commit;
2548: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert into bim_i_marketing_facts_stg');
2549: INSERT /*+ append parallel */
2550: INTO BIM_I_MARKETING_FACTS_STG CDF (
2551: --MKT_DAILY_TRANSACTION_ID ,
2552: CREATION_DATE ,
2553: LAST_UPDATE_DATE ,
2554: CREATED_BY ,

Line 2826: from bim_i_marketing_facts_stg);

2822: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2823: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
2824: FROM (select distinct from_currency from_currency,
2825: transaction_create_date transaction_create_date
2826: from bim_i_marketing_facts_stg);
2827: commit;
2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');
2829: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2830: if (l_check_missing_rate = -1) then

Line 2832: l_stmt := 'TRUNCATE table '||L_SCHEMA||'.BIM_I_MARKETING_FACTS_STG';

2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');
2829: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2830: if (l_check_missing_rate = -1) then
2831: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
2832: l_stmt := 'TRUNCATE table '||L_SCHEMA||'.BIM_I_MARKETING_FACTS_STG';
2833: EXECUTE IMMEDIATE l_stmt;
2834: commit;
2835: x_return_status := FND_API.G_RET_STS_ERROR;
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2966: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt

2962: ,BUDGET_APPROVED*sec_conversion_rate
2963: ,CONVERSION_RATE_S
2964: ,metric1*rt.prim_conversion_rate
2965: ,metric1*sec_conversion_rate
2966: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt
2967: where a.from_currency = rt.tc_code(+)
2968: and a.transaction_create_date= rt.trx_date(+);
2969: commit;
2970:

Line 3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';

3131: when others then
3132: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Error in first insert:'||sqlerrm(sqlcode));
3133: --dbms_output.put_line('error inserting:'||sqlerrm(sqlcode));
3134: END;
3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
3136: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
3137:
3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');
3139: --BEGIN

Line 3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');

3134: END;
3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
3136: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
3137:
3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');
3139: --BEGIN
3140: --dbms_output.put_line('right b4 inserting'||sqlerrm(sqlcode));
3141: INSERT
3142: INTO BIM_I_MARKETING_FACTS_STG CDF

Line 3142: INTO BIM_I_MARKETING_FACTS_STG CDF

3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');
3139: --BEGIN
3140: --dbms_output.put_line('right b4 inserting'||sqlerrm(sqlcode));
3141: INSERT
3142: INTO BIM_I_MARKETING_FACTS_STG CDF
3143: ( -- MKT_DAILY_TRANSACTION_ID ,
3144: CREATION_DATE ,
3145: LAST_UPDATE_DATE ,
3146: CREATED_BY ,

Line 4593: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert BIM_I_MARKETING_FACTS_STG');

4589: ,conversion_rate
4590: ,from_currency
4591: ,conversion_rate_s) inner;
4592:
4593: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert BIM_I_MARKETING_FACTS_STG');
4594: ------------------------------NEW CODE----------------------
4595: INSERT INTO bim_i_marketing_facts_STG
4596: ( --MKT_DAILY_TRANSACTION_ID ,
4597: CREATION_DATE ,

Line 4595: INSERT INTO bim_i_marketing_facts_STG

4591: ,conversion_rate_s) inner;
4592:
4593: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert BIM_I_MARKETING_FACTS_STG');
4594: ------------------------------NEW CODE----------------------
4595: INSERT INTO bim_i_marketing_facts_STG
4596: ( --MKT_DAILY_TRANSACTION_ID ,
4597: CREATION_DATE ,
4598: LAST_UPDATE_DATE ,
4599: CREATED_BY ,

Line 5218: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert BIM_I_MARKETING_FACTS_STG');

5214:
5215: --dbms_output.put_line('inserted :'||SQL%ROWCOUNT);
5216: COMMIT;
5217:
5218: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert BIM_I_MARKETING_FACTS_STG');
5219: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_CODE' ,l_conc_start_date,l_conc_end_date,l_sc_s_date,l_sc_e_date);
5220:
5221: INSERT INTO BIM_I_MARKETING_FACTS_STG CDF (
5222: --MKT_DAILY_TRANSACTION_ID ,

Line 5221: INSERT INTO BIM_I_MARKETING_FACTS_STG CDF (

5217:
5218: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert BIM_I_MARKETING_FACTS_STG');
5219: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_CODE' ,l_conc_start_date,l_conc_end_date,l_sc_s_date,l_sc_e_date);
5220:
5221: INSERT INTO BIM_I_MARKETING_FACTS_STG CDF (
5222: --MKT_DAILY_TRANSACTION_ID ,
5223: CREATION_DATE ,
5224: LAST_UPDATE_DATE ,
5225: CREATED_BY ,

Line 5360: from bim_i_marketing_facts_stg);

5356: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
5357: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
5358: FROM (select distinct from_currency from_currency,
5359: transaction_create_date transaction_create_date
5360: from bim_i_marketing_facts_stg);
5361:
5362: l_check_missing_rate := Check_Missing_Rates (p_start_date);
5363: if (l_check_missing_rate = -1) then
5364: DELETE from bim_i_marketing_facts_stg where transaction_create_date>= p_start_date;

Line 5364: DELETE from bim_i_marketing_facts_stg where transaction_create_date>= p_start_date;

5360: from bim_i_marketing_facts_stg);
5361:
5362: l_check_missing_rate := Check_Missing_Rates (p_start_date);
5363: if (l_check_missing_rate = -1) then
5364: DELETE from bim_i_marketing_facts_stg where transaction_create_date>= p_start_date;
5365: commit;
5366: x_return_status := FND_API.G_RET_STS_ERROR;
5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5368: end if;

Line 5497: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt

5493: ,BUDGET_APPROVED*sec_conversion_rate
5494: ,CONVERSION_RATE_S
5495: ,metric1*rt.prim_conversion_rate
5496: ,metric1*sec_conversion_rate
5497: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt
5498: where a.from_currency = rt.tc_code(+)
5499: and a.transaction_create_date= rt.trx_date(+);
5500:
5501: --Insert schedules