DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_MFG_FORECAST

Line 11: TYPE a_forecast_designator_type IS TABLE OF msd_mfg_forecast.forecast_designator%TYPE;

7: /* Bug# 4747555 */
8: C_ALL CONSTANT NUMBER := 1;
9:
10:
11: TYPE a_forecast_designator_type IS TABLE OF msd_mfg_forecast.forecast_designator%TYPE;
12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;
13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;

Line 12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;

8: C_ALL CONSTANT NUMBER := 1;
9:
10:
11: TYPE a_forecast_designator_type IS TABLE OF msd_mfg_forecast.forecast_designator%TYPE;
12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;
13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;

Line 13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;

9:
10:
11: TYPE a_forecast_designator_type IS TABLE OF msd_mfg_forecast.forecast_designator%TYPE;
12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;
13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;

Line 14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;

10:
11: TYPE a_forecast_designator_type IS TABLE OF msd_mfg_forecast.forecast_designator%TYPE;
12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;
13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;

Line 15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;

11: TYPE a_forecast_designator_type IS TABLE OF msd_mfg_forecast.forecast_designator%TYPE;
12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;
13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;

Line 16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;

12: TYPE a_item_type IS TABLE OF msd_mfg_forecast.item%TYPE;
13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;

Line 17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;

13: TYPE a_inv_org_type IS TABLE OF msd_mfg_forecast.inv_org%TYPE;
14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;

Line 18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;

14: TYPE a_customer_type IS TABLE OF msd_mfg_forecast.customer%TYPE;
15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;

Line 19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;

15: TYPE a_sales_channel_type IS TABLE OF msd_mfg_forecast.sales_channel%TYPE;
16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;

Line 20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;

16: TYPE a_ship_to_loc_type IS TABLE OF msd_mfg_forecast.ship_to_loc%TYPE;
17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;

Line 21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;

17: TYPE a_user_defined1_type IS TABLE OF msd_mfg_forecast.user_defined1%TYPE;
18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;

Line 22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;

18: TYPE a_user_defined2_type IS TABLE OF msd_mfg_forecast.user_defined2%TYPE;
19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;

Line 23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;

19: TYPE a_bucket_type_type IS TABLE OF msd_mfg_forecast.bucket_type%TYPE;
20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;

Line 24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;

20: TYPE a_forecast_date_type IS TABLE OF msd_mfg_forecast.forecast_date%TYPE;
21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;

Line 25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;

21: TYPE a_rate_end_date_type IS TABLE OF msd_mfg_forecast.rate_end_date%TYPE;
22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;

Line 26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;

22: TYPE a_original_quantity_type IS TABLE OF msd_mfg_forecast.original_quantity%TYPE;
23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;
30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;

Line 27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;

23: TYPE a_current_quantity_type IS TABLE OF msd_mfg_forecast.current_quantity%TYPE;
24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;
30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;
31: TYPE a_prd_level_id_type IS TABLE OF msd_mfg_forecast.prd_level_id%TYPE;

Line 28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;

24: TYPE a_sr_inv_org_pk_type IS TABLE OF msd_mfg_forecast.sr_inv_org_pk%TYPE;
25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;
30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;
31: TYPE a_prd_level_id_type IS TABLE OF msd_mfg_forecast.prd_level_id%TYPE;
32:

Line 29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;

25: TYPE a_sr_item_pk_type IS TABLE OF msd_mfg_forecast.sr_item_pk%TYPE;
26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;
30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;
31: TYPE a_prd_level_id_type IS TABLE OF msd_mfg_forecast.prd_level_id%TYPE;
32:
33: procedure translate_shipment_data(

Line 30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;

26: TYPE a_sr_customer_pk_type IS TABLE OF msd_mfg_forecast.sr_customer_pk%TYPE;
27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;
30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;
31: TYPE a_prd_level_id_type IS TABLE OF msd_mfg_forecast.prd_level_id%TYPE;
32:
33: procedure translate_shipment_data(
34: errbuf OUT NOCOPY VARCHAR2,

Line 31: TYPE a_prd_level_id_type IS TABLE OF msd_mfg_forecast.prd_level_id%TYPE;

27: TYPE a_sr_sales_channel_pk_type IS TABLE OF msd_mfg_forecast.sr_sales_channel_pk%TYPE;
28: TYPE a_sr_ship_to_loc_pk_type IS TABLE OF msd_mfg_forecast.sr_ship_to_loc_pk%TYPE;
29: TYPE a_sr_user_defined1_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined1_pk%TYPE;
30: TYPE a_sr_user_defined2_pk_type IS TABLE OF msd_mfg_forecast.sr_user_defined2_pk%TYPE;
31: TYPE a_prd_level_id_type IS TABLE OF msd_mfg_forecast.prd_level_id%TYPE;
32:
33: procedure translate_shipment_data(
34: errbuf OUT NOCOPY VARCHAR2,
35: retcode OUT NOCOPY VARCHAR2,