DBA Data[Home] [Help]

APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on BIS_COLLECTION_UTILITIES

Line 619: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

615:
616: IF (l_miss_rates_prim > 0) OR
617: (l_miss_rates_sec > 0) THEN
618:
619: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
620:
621: IF p_program_type = 'L' THEN
622:
623: FOR rate_record in prim_MissingRate_L

Line 625: BIS_COLLECTION_UTILITIES.writeMissingRate(

621: IF p_program_type = 'L' THEN
622:
623: FOR rate_record in prim_MissingRate_L
624: LOOP
625: BIS_COLLECTION_UTILITIES.writeMissingRate(
626: g_prim_rate_type_name,
627: rate_record.from_currency,
628: g_prim_currency,
629: rate_record.actg_dt);

Line 634: BIS_COLLECTION_UTILITIES.writeMissingRate(

630: END LOOP;
631:
632: FOR rate_record in sec_MissingRate_L
633: LOOP
634: BIS_COLLECTION_UTILITIES.writeMissingRate(
635: g_sec_rate_type_name,
636: rate_record.from_currency,
637: g_sec_currency,
638: rate_record.actg_dt);

Line 645: BIS_COLLECTION_UTILITIES.writeMissingRate(

641: ELSE
642:
643: FOR rate_record in prim_MissingRate
644: LOOP
645: BIS_COLLECTION_UTILITIES.writeMissingRate(
646: g_prim_rate_type_name,
647: rate_record.from_currency,
648: g_prim_currency,
649: rate_record.actg_dt);

Line 654: BIS_COLLECTION_UTILITIES.writeMissingRate(

650: END LOOP;
651:
652: FOR rate_record in sec_MissingRate
653: LOOP
654: BIS_COLLECTION_UTILITIES.writeMissingRate(
655: g_sec_rate_type_name,
656: rate_record.from_currency,
657: g_sec_currency,
658: rate_record.actg_dt);

Line 1564: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';

1560: END IF;
1561:
1562: -- Load and Increment programs should record the dates seperately
1563: -- so that the dates are derived correctly for incremental mode.
1564: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
1565: IF p_program_type = 'L' THEN
1566: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_DISTRIBUTIONS_B_L')) THEN
1567: raise_application_error(-20000,errbuf);
1568: return;

Line 1566: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_DISTRIBUTIONS_B_L')) THEN

1562: -- Load and Increment programs should record the dates seperately
1563: -- so that the dates are derived correctly for incremental mode.
1564: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
1565: IF p_program_type = 'L' THEN
1566: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_DISTRIBUTIONS_B_L')) THEN
1567: raise_application_error(-20000,errbuf);
1568: return;
1569: END IF;
1570: ELSE

Line 1571: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_DISTRIBUTIONS_B_I')) THEN

1567: raise_application_error(-20000,errbuf);
1568: return;
1569: END IF;
1570: ELSE
1571: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_DISTRIBUTIONS_B_I')) THEN
1572: raise_application_error(-20000,errbuf);
1573: return;
1574: END IF;
1575: END IF;

Line 1723: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;

1719: FII_UTIL.put_line(g_state);
1720: fii_util.put_line('');
1721: END IF;
1722:
1723: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
1724:
1725: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
1726: l_start_date_t, l_end_date_t,
1727: l_period_from, l_period_to);

Line 1725: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',

1721: END IF;
1722:
1723: g_timestamp1 := BIS_COLLECTION_UTILITIES.G_Start_Date;
1724:
1725: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
1726: l_start_date_t, l_end_date_t,
1727: l_period_from, l_period_to);
1728:
1729: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',

Line 1729: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',

1725: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L',
1726: l_start_date_t, l_end_date_t,
1727: l_period_from, l_period_to);
1728:
1729: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_I',
1730: l_start_date_temp, l_end_date_t,
1731: l_period_from, l_period_to);
1732:
1733: g_timestamp2 := GREATEST(NVL(l_start_date_t, BIS_COMMON_PARAMETERS.Get_Global_Start_Date),

Line 1739: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',

1735: g_timestamp4 := g_timestamp2;
1736:
1737: IF g_oper_imp_prof_flag = 'Y' THEN
1738:
1739: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',
1740: l_start_date_t, l_end_date_t,
1741: l_period_from, l_period_to);
1742:
1743: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INC',

Line 1743: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INC',

1739: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INIT',
1740: l_start_date_t, l_end_date_t,
1741: l_period_from, l_period_to);
1742:
1743: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_SUM_INC',
1744: l_start_date_temp, l_end_date_t,
1745: l_period_from, l_period_to);
1746:
1747: g_timestamp3 := GREATEST(NVL(l_start_date_t, BIS_COMMON_PARAMETERS.Get_Global_Start_Date),

Line 1807: BIS_COLLECTION_UTILITIES.wrapup(

1803: ----------------------------------------------------------------
1804: -- Calling BIS API to record the range we collect. Only do this
1805: -- when we have a successful collection
1806: ----------------------------------------------------------------
1807: BIS_COLLECTION_UTILITIES.wrapup(
1808: p_status => TRUE,
1809: p_period_from => g_start_date,
1810: p_period_to => g_end_date);
1811:

Line 2108: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';

2104: ----------------------------------------------------------------
2105: -- Calling BIS API to record the range we collect. Only do this
2106: -- when we have a successful collection
2107: ----------------------------------------------------------------
2108: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
2109: BIS_COLLECTION_UTILITIES.wrapup(
2110: p_status => TRUE,
2111: p_period_from => g_start_date,
2112: p_period_to => g_end_date);

Line 2109: BIS_COLLECTION_UTILITIES.wrapup(

2105: -- Calling BIS API to record the range we collect. Only do this
2106: -- when we have a successful collection
2107: ----------------------------------------------------------------
2108: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
2109: BIS_COLLECTION_UTILITIES.wrapup(
2110: p_status => TRUE,
2111: p_period_from => g_start_date,
2112: p_period_to => g_end_date);
2113:

Line 2195: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L', l_last_start_date,

2191: -- from EDWCORE
2192: -- -----------------------------------------------
2193: CHILD_SETUP('FII_AP_INV_DISTRIBUTIONS_B_SUBWORKER'||p_worker_no);
2194:
2195: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_DISTRIBUTIONS_B_L', l_last_start_date,
2196: l_last_end_date, l_last_period_from,
2197: l_last_period_to);
2198: g_start_date := nvl(l_last_period_from, bis_common_parameters.get_global_start_date);
2199: