314: end if ;
315:
316:
317:
318: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
319:
320: IF (x_direct_load_profile) THEN
321: MSD_PULL_FACT_DATA.pull_shipment_data( errbuf,
322: retcode);
510: return;
511: end if ;
512: end if ;
513:
514: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
515:
516: IF (x_direct_load_profile) THEN
517: MSD_PULL_FACT_DATA.pull_booking_data( errbuf,
518: retcode);
596: end if;
597:
598: x_source_table := MSD_COMMON_UTILITIES.UOM_SOURCE_TABLE || x_dblink ;
599:
600: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
601:
602: x_dest_table := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;
603:
604:
615: return;
616: end if ;
617:
618:
619: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
620:
621: IF (x_direct_load_profile) THEN
622: MSD_PULL_FACT_DATA.pull_uom_conversion( errbuf,
623: retcode);
724: return;
725: end if ;
726:
727:
728: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
729:
730: IF (x_direct_load_profile) THEN
731: MSD_PULL_FACT_DATA.pull_currency_conversion( errbuf,
732: retcode);
838: o_source_table := MSD_COMMON_UTILITIES.OPM_MFG_FCST_SOURCE_TABLE || x_dblink ;
839:
840: x_dest_table := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;
841:
842: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
843:
844: /* OPM Comment By Rajesh Patangya */
845: /* Bug# 4620927 */
846: -- IF o_instance_type <> 2 then
885: END IF;
886: END IF;
887:
888:
889: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
890:
891: /* If 1 step colloction then proceed with PULL */
892: IF (x_direct_load_profile) THEN
893: MSD_PULL_FACT_DATA.pull_mfg_forecast( errbuf,
996: p_price_list => p_price_list );
997:
998:
999:
1000: x_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
1001:
1002: /* If 1 step colloction then proceed with PULL */
1003: IF (x_direct_load_profile) THEN
1004: MSD_PULL_FACT_DATA.pull_pricing_data( errbuf,