APPS.FII_AP_INV_B_C dependencies on BIS_COLLECTION_UTILITIES

Line 868: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

864:
865: IF (l_miss_rates_prim > 0) OR
866: (l_miss_rates_sec > 0) THEN
867:
868: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
869:
870: IF p_program_type = 'L' THEN
871:
872: FOR rate_record in prim_MissingRate_L

Line 874: BIS_COLLECTION_UTILITIES.writeMissingRate(

870: IF p_program_type = 'L' THEN
871:
872: FOR rate_record in prim_MissingRate_L
873: LOOP
874: BIS_COLLECTION_UTILITIES.writeMissingRate(
875: g_prim_rate_type_name,
876: rate_record.from_currency,
877: g_prim_currency,
878: rate_record.actg_dt);

Line 883: BIS_COLLECTION_UTILITIES.writeMissingRate(

879: END LOOP;
880:
881: FOR rate_record in sec_MissingRate_L
882: LOOP
883: BIS_COLLECTION_UTILITIES.writeMissingRate(
884: g_sec_rate_type_name,
885: rate_record.from_currency,
886: g_sec_currency,
887: rate_record.actg_dt);

Line 894: BIS_COLLECTION_UTILITIES.writeMissingRate(

890: ELSE
891:
892: FOR rate_record in prim_MissingRate
893: LOOP
894: BIS_COLLECTION_UTILITIES.writeMissingRate(
895: g_prim_rate_type_name,
896: rate_record.from_currency,
897: g_prim_currency,
898: rate_record.actg_dt);

Line 903: BIS_COLLECTION_UTILITIES.writeMissingRate(

899: END LOOP;
900:
901: FOR rate_record in sec_MissingRate
902: LOOP
903: BIS_COLLECTION_UTILITIES.writeMissingRate(
904: g_sec_rate_type_name,
905: rate_record.from_currency,
906: g_sec_currency,
907: rate_record.actg_dt);

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

1896: END IF;
1897:
1898: -- Load and Increment programs should record the dates seperately
1899: -- so that the dates are derived correctly for incremental mode.
1900: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
1901: IF p_program_type = 'L' THEN
1902: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_L')) THEN
1903: raise_application_error(-20000,errbuf);
1904: return;

Line 1902: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_L')) THEN

1898: -- Load and Increment programs should record the dates seperately
1899: -- so that the dates are derived correctly for incremental mode.
1900: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
1901: IF p_program_type = 'L' THEN
1902: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_L')) THEN
1903: raise_application_error(-20000,errbuf);
1904: return;
1905: END IF;
1906: ELSE

Line 1907: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_I')) THEN

1903: raise_application_error(-20000,errbuf);
1904: return;
1905: END IF;
1906: ELSE
1907: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_I')) THEN
1908: raise_application_error(-20000,errbuf);
1909: return;
1910: END IF;
1911: END IF;

Line 2131: BIS_COLLECTION_UTILITIES.wrapup(

2127: ----------------------------------------------------------------
2128: -- Calling BIS API to record the range we collect. Only do this
2129: -- when we have a successful collection
2130: ----------------------------------------------------------------
2131: BIS_COLLECTION_UTILITIES.wrapup(
2132: p_status => TRUE,
2133: p_period_from => g_start_date,
2134: p_period_to => g_end_date);
2135: g_retcode := 0;

Line 2366: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,

2362: SELECT MAX(Last_Update_Date) INTO l_last_sup_merge
2363: FROM AP_Duplicate_Vendors_All
2364: WHERE Process_Flag = 'Y';
2365:
2366: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,
2367: l_last_end_date, l_last_period_from,
2368: l_last_period_to);
2369: l_timestamp := nvl(l_last_start_date, bis_common_parameters.get_global_start_date);
2370:

Line 2371: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_I', l_last_start_date,

2367: l_last_end_date, l_last_period_from,
2368: l_last_period_to);
2369: l_timestamp := nvl(l_last_start_date, bis_common_parameters.get_global_start_date);
2370:
2371: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_I', l_last_start_date,
2372: l_last_end_date, l_last_period_from,
2373: l_last_period_to);
2374: l_timestamp := greatest(l_timestamp, nvl(l_last_start_date, bis_common_parameters.get_global_start_date));
2375:

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

2412: ----------------------------------------------------------------
2413: -- Calling BIS API to record the range we collect. Only do this
2414: -- when we have a successful collection
2415: ----------------------------------------------------------------
2416: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
2417: BIS_COLLECTION_UTILITIES.wrapup(
2418: p_status => TRUE,
2419: p_period_from => g_start_date,
2420: p_period_to => g_end_date);

Line 2417: BIS_COLLECTION_UTILITIES.wrapup(

2413: -- Calling BIS API to record the range we collect. Only do this
2414: -- when we have a successful collection
2415: ----------------------------------------------------------------
2416: g_state := 'Calling BIS_COLLECTION_UTILITIES.wrapup';
2417: BIS_COLLECTION_UTILITIES.wrapup(
2418: p_status => TRUE,
2419: p_period_from => g_start_date,
2420: p_period_to => g_end_date);
2421:

Line 2529: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,

2525: -- from EDWCORE
2526: -- -----------------------------------------------
2527: CHILD_SETUP('FII_AP_INV_B_C_SUBWORKER'||p_worker_no);
2528:
2529: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,
2530: l_last_end_date, l_last_period_from,
2531: l_last_period_to);
2532: g_start_date := nvl(l_last_period_from, bis_common_parameters.get_global_start_date);
2533: