DBA Data[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on GMP_BOM_ROUTING_PKG

Line 12073: l_profile := NVL(GMP_BOM_ROUTING_PKG.get_profile_value('GMP_COLLECT_EXPR_ONHAND', pdblink ),0);

12069: /* Bug # 5238790 */
12070: l_profile := 0 ;
12071: -- l_profile := nvl(FND_PROFILE.VALUE('GMP_COLLECT_EXPR_ONHAND'),0) ;
12072: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
12073: l_profile := NVL(GMP_BOM_ROUTING_PKG.get_profile_value('GMP_COLLECT_EXPR_ONHAND', pdblink ),0);
12074:
12075: IF api_mode THEN
12076: /* If forecast and sales order select queries have joins with gmp_item_aps
12077: we need to select only schedules and warehouses here

Line 12487: l_profile := GMP_BOM_ROUTING_PKG.get_profile_value('IC$DEFAULT_LOCT', pdblink );

12483:
12484: /* This profile value holds the Defualt Location */
12485: -- l_profile := FND_PROFILE.value('IC$DEFAULT_LOCT') ;
12486: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
12487: l_profile := GMP_BOM_ROUTING_PKG.get_profile_value('IC$DEFAULT_LOCT', pdblink );
12488:
12489: log_message('Default Location = ' || l_profile );
12490:
12491: -- b_profile := fnd_profile.value('BIS_PRIMARY_RATE_TYPE') ;

Line 12493: b_profile := GMP_BOM_ROUTING_PKG.get_profile_value('BIS_PRIMARY_RATE_TYPE', pdblink );

12489: log_message('Default Location = ' || l_profile );
12490:
12491: -- b_profile := fnd_profile.value('BIS_PRIMARY_RATE_TYPE') ;
12492: /* bug:6710684 Vpedarla made changes to fetch the profile value from source server*/
12493: b_profile := GMP_BOM_ROUTING_PKG.get_profile_value('BIS_PRIMARY_RATE_TYPE', pdblink );
12494:
12495: log_message('Primary Rate = ' || b_profile);
12496:
12497: /* populate the org_string */