APPS.FII_AR_REVENUE_B_C dependencies on BIS_COLLECTION_UTILITIES

Line 1618: bis_collection_utilities.writeMissingRateHeader;

1614: -- if g_debug_flag = 'Y' then
1615: fii_util.put_line(' ');
1616: fii_util.put_line('There are some missing prim exchange rates.');
1617: -- end if;
1618: bis_collection_utilities.writeMissingRateHeader;
1619:
1620:
1621: IF g_program_type = 'L' THEN
1622:

Line 1626: bis_collection_utilities.writeMissingRate(

1622:
1623: FOR rate_record in c3
1624: LOOP
1625: null;
1626: bis_collection_utilities.writeMissingRate(
1627: l_prim_rate_type_name,
1628: rate_record.functional_currency,
1629: l_prim_currency_code,
1630: rate_record.trx_date);

Line 1638: bis_collection_utilities.writeMissingRate(

1634:
1635: FOR rate_record in c1
1636: LOOP
1637: null;
1638: bis_collection_utilities.writeMissingRate(
1639: l_prim_rate_type_name,
1640: rate_record.transaction_currency,
1641: l_prim_currency_code,
1642: rate_record.exchange_date);

Line 1654: bis_collection_utilities.writeMissingRateHeader;

1650: fii_util.put_line(' ');
1651: fii_util.put_line('There are some missing sec conversion rates.');
1652: -- end if;
1653:
1654: bis_collection_utilities.writeMissingRateHeader;
1655:
1656: IF g_program_type = 'L' THEN
1657:
1658: FOR rate_record in c4

Line 1661: bis_collection_utilities.writeMissingRate(

1657:
1658: FOR rate_record in c4
1659: LOOP
1660: null;
1661: bis_collection_utilities.writeMissingRate(
1662: l_sec_rate_type_name,
1663: rate_record.functional_currency,
1664: l_sec_currency_code,
1665: rate_record.trx_date);

Line 1673: bis_collection_utilities.writeMissingRate(

1669:
1670: FOR rate_record in c2
1671: LOOP
1672: null;
1673: bis_collection_utilities.writeMissingRate(
1674: l_sec_rate_type_name,
1675: rate_record.transaction_currency,
1676: l_sec_currency_code,
1677: rate_record.exchange_date);

Line 3830: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_REVENUE_B_I')) THEN

3826: fii_util.initialize('FII_AR_REV_SUM.log','FII_AR_REV_SUM.out',l_dir, 'FII_AR_REVENUE_B_L');
3827: END IF;
3828:
3829: IF g_program_type = 'I' THEN
3830: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_REVENUE_B_I')) THEN
3831: raise_application_error(-20000,errbuf);
3832: return;
3833: END IF;
3834: ELSIF g_program_type = 'L' THEN

Line 3835: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_REVENUE_B_L')) THEN

3831: raise_application_error(-20000,errbuf);
3832: return;
3833: END IF;
3834: ELSIF g_program_type = 'L' THEN
3835: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_REVENUE_B_L')) THEN
3836: raise_application_error(-20000,errbuf);
3837: return;
3838: END IF;
3839: END IF;

Line 3843: fii_util.put_line('Altering session enable parallel DML after BIS_COLLECTION_UTILITIES.setup call, bug 4127183.');

3839: END IF;
3840:
3841: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
3842:
3843: fii_util.put_line('Altering session enable parallel DML after BIS_COLLECTION_UTILITIES.setup call, bug 4127183.');
3844:
3845: --------------------------------------------
3846: -- Initalization
3847: --------------------------------------------

Line 3909: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_I');

3905: -- DEBUG
3906: TRUNCATE_TABLE('FII_AR_REVENUE_STG');
3907: TRUNCATE_TABLE('FII_AR_REVENUE_B');
3908: TRUNCATE_TABLE('FII_AR_REV_ACCTS');
3909: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_I');
3910: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_L');
3911: COMMIT;
3912: END IF;
3913:

Line 3910: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_L');

3906: TRUNCATE_TABLE('FII_AR_REVENUE_STG');
3907: TRUNCATE_TABLE('FII_AR_REVENUE_B');
3908: TRUNCATE_TABLE('FII_AR_REV_ACCTS');
3909: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_I');
3910: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_REVENUE_B_L');
3911: COMMIT;
3912: END IF;
3913:
3914: -------------------------------------------------------------

Line 3949: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AR_REVENUE_B_I',

3945: -----------------------------------------------------------------
3946: -- When running in Incremental mode, the values of the parameters
3947: -- are derived
3948: -----------------------------------------------------------------
3949: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AR_REVENUE_B_I',
3950: l_last_start_date1,
3951: l_last_end_date,
3952: l_last_period_from,
3953: l_last_period_to1);

Line 4004: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AR_REVENUE_B_L',

4000: -- The LOAD may be run on 7-Mar-2003 but the the records may be collected
4001: -- upto 31-DEC-2002. To get the records from 31-DEC-2002 we use the least
4002: -- of l_last_start_date2, l_last_period_to2
4003: -- --------------------------------------------------------------------------
4004: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AR_REVENUE_B_L',
4005: l_last_start_date2,
4006: l_last_end_date,
4007: l_last_period_from,
4008: l_last_period_to2);

Line 4747: BIS_COLLECTION_UTILITIES.wrapup(

4743: -- Calling BIS API to record the range we collect. Only do this
4744: -- when we have a successful collection
4745: ----------------------------------------------------------------
4746:
4747: BIS_COLLECTION_UTILITIES.wrapup(
4748: p_status => TRUE,
4749: p_period_from => g_gl_from_date,
4750: p_period_to => g_gl_to_date);
4751: