DBA Data[Home] [Help]

APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_GLOBAL_FORECASTING

Line 1: PACKAGE BODY MSC_GLOBAL_FORECASTING AS

1: PACKAGE BODY MSC_GLOBAL_FORECASTING AS
2: /* $Header: MSCPHOGB.pls 120.14 2011/03/22 00:36:13 hulu ship $ */
3:
4: SYS_YES CONSTANT INTEGER := 1;
5: SYS_NO CONSTANT INTEGER := 2;

Line 191: MSC_GLOBAL_FORECASTING.get_ship_to(

187: 8, nvl(to_char(forecast.zone_id),'-99'),
188: 9, decode(forecast.zone_id, null, '-99',
189: to_char(forecast.customer_id)||':'||
190: to_char(forecast.zone_id)),
191: MSC_GLOBAL_FORECASTING.get_ship_to(
192: list.number8,
193: forecast.plan_id,
194: forecast.sales_order_id)) ship_to,
195: CONSUMED row_type,

Line 223: MSC_GLOBAL_FORECASTING.get_ship_to(

219: 8, nvl(to_char(forecast.zone_id),'-99'),
220: 9, decode(forecast.zone_id, null, '-99',
221: to_char(forecast.customer_id)||':'||
222: to_char(forecast.zone_id)),
223: MSC_GLOBAL_FORECASTING.get_ship_to(
224: list.number8,
225: forecast.plan_id,
226: forecast.sales_order_id)),
227: CONSUMED, CONSUMED_OFF,

Line 1298: END MSC_GLOBAL_FORECASTING;

1294:
1295: return '-1';
1296: END get_ship_to;
1297:
1298: END MSC_GLOBAL_FORECASTING;