APPS.ENI_DBI_UCO_LOAD_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 115: if BIS_COLLECTION_UTILITIES.SETUP(

111: l_end_date := trunc(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS'));
112: **/
113: eni_dbi_util_pkg.log('The date range for Initial cost collection is ' || l_start_date || ' to ' || l_end_date);
114:
115: if BIS_COLLECTION_UTILITIES.SETUP(
116: p_object_name => 'eni_dbi_item_cost_f',
117: p_parallel => 1) = false then
118: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
119: end if;

Line 358: BIS_COLLECTION_UTILITIES.WRAPUP(

354: SELECT Max(COST_UPDATE_ID)
355: INTO l_processed_cost_id
356: FROM cst_elemental_costs cec;
357:
358: BIS_COLLECTION_UTILITIES.WRAPUP(
359: p_status => true,
360: p_period_from => l_start_date,
361: p_period_to => l_end_date,
362: p_attribute1 => 'mtl_material_transactions',

Line 386: BIS_COLLECTION_UTILITIES.WRAPUP(

382:
383: eni_dbi_util_pkg.log('An error prevented the initial cost collection from completing successfully');
384: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);
385: Rollback;
386: BIS_COLLECTION_UTILITIES.WRAPUP(
387: p_status => false,
388: p_period_from => l_start_date,
389: p_period_to => l_end_date
390: );

Line 474: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

470: l_stmt_num:=28;
471: IF (l_no_currency_rate_flag = 0) THEN
472: l_no_currency_rate_flag := 1;
473: l_stmt_num:=29;
474: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
475: END IF;
476:
477: -- Report missing conversion rates for primary currency
478: IF (l_prim_currency_code IS NOT NULL) AND

Line 483: BIS_COLLECTION_UTILITIES.writemissingrate

479: (get_missing_rate_rec.conversion_rate = -3) AND (l_prim_euro_beg = 0)
480: THEN
481: l_stmt_num:=30;
482:
483: BIS_COLLECTION_UTILITIES.writemissingrate
484: (l_prim_rate_type,
485: get_missing_rate_rec.currency_code,
486: l_prim_currency_code,
487: l_euro_start_date);

Line 495: BIS_COLLECTION_UTILITIES.writemissingrate

491: ELSIF (l_prim_currency_code IS NOT NULL) AND
492: (get_missing_rate_rec.conversion_rate < 0)
493: THEN
494: l_stmt_num:=31;
495: BIS_COLLECTION_UTILITIES.writemissingrate
496: (l_prim_rate_type,
497: get_missing_rate_rec.currency_code,
498: l_prim_currency_code,
499: get_missing_rate_rec.effective_date);

Line 507: BIS_COLLECTION_UTILITIES.writemissingrate

503: IF (l_sec_currency_code IS NOT NULL) AND
504: (get_missing_rate_rec.conversion_rate_s = -3) AND (l_sec_euro_beg = 0)
505: THEN
506: l_stmt_num:=32;
507: BIS_COLLECTION_UTILITIES.writemissingrate
508: (l_sec_rate_type,
509: get_missing_rate_rec.currency_code,
510: l_sec_currency_code,
511: l_euro_start_date);

Line 519: BIS_COLLECTION_UTILITIES.writemissingrate

515: ELSIF (l_sec_currency_code IS NOT NULL) AND
516: (get_missing_rate_rec.conversion_rate_s < 0)
517: THEN
518: l_stmt_num:=33;
519: BIS_COLLECTION_UTILITIES.writemissingrate
520: (l_sec_rate_type,
521: get_missing_rate_rec.currency_code,
522: l_sec_currency_code,
523: get_missing_rate_rec.effective_date);

Line 577: if BIS_COLLECTION_UTILITIES.SETUP(

573: THEN NULL;
574: END IF;
575:
576:
577: if BIS_COLLECTION_UTILITIES.SETUP(
578: p_object_name => 'eni_dbi_item_cost_f',
579: p_parallel => 1) = false then
580: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
581: end if;

Line 583: l_last_run_to_date_char := BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f');

579: p_parallel => 1) = false then
580: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
581: end if;
582:
583: l_last_run_to_date_char := BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f');
584: l_last_run_to_date := trunc(fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f')));
585: /** Bug: 4956685, 4936377
586: Fetch the last Processed transaction id and cost update id from bis refresh log table.
587: **/

Line 584: l_last_run_to_date := trunc(fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f')));

580: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
581: end if;
582:
583: l_last_run_to_date_char := BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f');
584: l_last_run_to_date := trunc(fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f')));
585: /** Bug: 4956685, 4936377
586: Fetch the last Processed transaction id and cost update id from bis refresh log table.
587: **/
588: SELECT MAX(decode(brl.attribute1,'mtl_material_transactions',attribute2,NULL))

Line 970: BIS_COLLECTION_UTILITIES.WRAPUP(

966: SELECT Max(COST_UPDATE_ID)
967: INTO l_processed_cost_id
968: FROM cst_elemental_costs;
969:
970: BIS_COLLECTION_UTILITIES.WRAPUP(
971: p_status => true,
972: p_period_from => l_last_run_to_date,
973: p_period_to => sysdate,
974: p_attribute1 => 'mtl_material_transactions',

Line 1003: BIS_COLLECTION_UTILITIES.WRAPUP(

999:
1000: eni_dbi_util_pkg.log('An error prevented the incremental cost collection from completing successfully');
1001: eni_dbi_util_pkg.log(o_error_code||':'||o_error_msg);
1002: Rollback;
1003: BIS_COLLECTION_UTILITIES.WRAPUP(
1004: p_status => false,
1005: p_period_from => l_last_run_to_date,
1006: p_period_to => l_last_run_to_date
1007: );