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_FUND_FACTS dependencies on BIM_R_FDSP_LOAD

Line 1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);

1539: END;
1540: /* Start inserting into 'bim_r_fdsp_daily_facts' */
1541: l_table_name :='bim_r_fdsp_daily_facts';
1542: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */

Line 1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';

1542: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */
1548: BEGIN
1549: INSERT /*+ append parallel(bfl,p_para_num) */
1550: INTO bim_r_fdsp_load bfl(

Line 1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */

1543: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
1544: fnd_file.put_line(fnd_file.log,fnd_message.get);
1545: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */
1548: BEGIN
1549: INSERT /*+ append parallel(bfl,p_para_num) */
1550: INTO bim_r_fdsp_load bfl(
1551: spend_transaction_id

Line 1550: INTO bim_r_fdsp_load bfl(

1546: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
1547: /* bim_r_fdsp_load is a intermediate table which holds commited amount, planned amount etc for all objects */
1548: BEGIN
1549: INSERT /*+ append parallel(bfl,p_para_num) */
1550: INTO bim_r_fdsp_load bfl(
1551: spend_transaction_id
1552: ,creation_date
1553: ,last_update_date
1554: ,created_by

Line 1685: END ; --end of insertion into bim_r_fdsp_load.

1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1683: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1684: FND_MSG_PUB.Add;
1685: END ; --end of insertion into bim_r_fdsp_load.
1686:
1687: -- dbms_output.put_line('inside fist inserting into fdsp daily');
1688: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
1689: fnd_message.set_token('table_name', l_table_name, FALSE);

Line 1775: bim_r_fdsp_load AU,

1771: AND DA.trdate between A.start_date_active
1772: and least(nvl(A.end_date_active,sysdate-1),p_end_datel)
1773: AND A.start_date_active between p_start_datel and p_end_datel
1774: ) AD,
1775: bim_r_fdsp_load AU,
1776: (SELECT
1777: D.business_unit_id business_unit_id,D.org_id org_id,
1778: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
1779: FROM ams_campaigns_all_b D

Line 1968: bim_r_fdsp_load AU,

1964: AU.object_id object_id,
1965: U.object_type object_type,
1966: AU.transaction_create_date transaction_create_date
1967: FROM ozf_funds_all_b AD,
1968: bim_r_fdsp_load AU,
1969: (SELECT
1970: D.business_unit_id business_unit_id,D.org_id org_id,
1971: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
1972: FROM ams_campaigns_all_b D

Line 3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */

3288: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3289: FND_MSG_PUB.Add;
3290: END;
3291:
3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */
3293: l_table_name :='bim_r_fdsp_daily_facts';
3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);

3291:
3292: /* Inserting into 'bim_r_fdsp_load' all the objects information */
3293: l_table_name :='bim_r_fdsp_daily_facts';
3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);
3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
3299: BEGIN

Line 3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';

3294: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
3295: fnd_message.set_token('table_name', 'bim_r_fdsp_load', FALSE);
3296: fnd_file.put_line(fnd_file.log,fnd_message.get);
3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
3299: BEGIN
3300: INSERT /*+ append parallel(bfl,p_para_num) */
3301: INTO bim_r_fdsp_load bfl(
3302: spend_transaction_id

Line 3301: INTO bim_r_fdsp_load bfl(

3297: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_fdsp_daily_facts_s CACHE 1000';
3298: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fdsp_load';
3299: BEGIN
3300: INSERT /*+ append parallel(bfl,p_para_num) */
3301: INTO bim_r_fdsp_load bfl(
3302: spend_transaction_id
3303: ,creation_date
3304: ,last_update_date
3305: ,created_by

Line 3435: END ; --end of insertion into bim_r_fdsp_load.

3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3433: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3434: FND_MSG_PUB.Add;
3435: END ; --end of insertion into bim_r_fdsp_load.
3436:
3437: --dbms_output.put_line('inside fist inserting into fdsp daily');
3438: /* First insert:Insert into 'bim_r_fdsp_daily_facts' the transactions happend between
3439: p_start_date and p_end_date */

Line 3517: bim_r_fdsp_load AU,

3513: AU.object_id object_id,
3514: U.object_type object_type,
3515: AU.transaction_create_date transaction_create_date
3516: FROM ozf_funds_all_b AD,
3517: bim_r_fdsp_load AU,
3518: (SELECT
3519: D.business_unit_id business_unit_id,D.org_id org_id,
3520: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
3521: FROM ams_campaigns_all_b D

Line 3712: bim_r_fdsp_load AU,

3708: AU.object_id object_id,
3709: U.object_type object_type,
3710: AU.transaction_create_date transaction_create_date
3711: FROM ozf_funds_all_b AD,
3712: bim_r_fdsp_load AU,
3713: (SELECT
3714: D.business_unit_id business_unit_id,D.org_id org_id,
3715: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
3716: FROM ams_campaigns_all_b D