1 PACKAGE MSD_TRANSLATE_FACT_DATA AS
2 /* $Header: msdtfcts.pls 120.3 2005/12/06 22:59:05 sjagathe noship $ */
3
4 SYS_YES CONSTANT NUMBER := 1; /* Bug# 4615390 ISO */
5 SYS_NO CONSTANT NUMBER := 2; /* Bug# 4615390 ISO */
6
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;
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;
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(
34 errbuf OUT NOCOPY VARCHAR2,
35 retcode OUT NOCOPY VARCHAR2,
36 p_source_table IN VARCHAR2,
37 p_dest_table IN VARCHAR2,
38 p_instance_id IN NUMBER,
39 p_from_date IN DATE,
40 p_to_date IN DATE,
41 p_new_refresh_num IN NUMBER,
42 p_delete_flag IN VARCHAR2,
43 p_collect_ISO IN NUMBER DEFAULT SYS_NO, /* Bug# 4615390 ISO, Bug# 4865396 */
44 p_order_type_flag IN NUMBER DEFAULT C_ALL, /* Bug# 4747555*/
45 p_order_type_ids IN VARCHAR2 DEFAULT NULL);
46
47 procedure translate_booking_data(
48 errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2,
50 p_source_table IN VARCHAR2,
51 p_dest_table IN VARCHAR2,
52 p_instance_id IN NUMBER,
53 p_from_date IN DATE,
54 p_to_date IN DATE,
55 p_new_refresh_num IN NUMBER,
56 p_delete_flag IN VARCHAR2,
57 p_collect_ISO IN NUMBER DEFAULT SYS_NO, /* Bug# 4615390 ISO, Bug# 4865396 */
58 p_order_type_flag IN NUMBER DEFAULT C_ALL, /* Bug# 4747555*/
59 p_order_type_ids IN VARCHAR2 DEFAULT NULL);
60
61 procedure translate_uom_conversion(
62 errbuf OUT NOCOPY VARCHAR2,
63 retcode OUT NOCOPY VARCHAR2,
64 p_source_table IN VARCHAR2,
65 p_dest_table IN VARCHAR2,
66 p_instance_id IN NUMBER,
67 p_new_refresh_num IN NUMBER) ;
68
69 procedure translate_currency_conversion(
70 errbuf OUT NOCOPY VARCHAR2,
71 retcode OUT NOCOPY VARCHAR2,
72 p_source_table IN VARCHAR2,
73 p_dest_table IN VARCHAR2,
74 p_instance_id IN NUMBER,
75 p_from_date IN DATE,
76 p_to_date IN DATE);
77
78 procedure translate_opportunities_data(
79 errbuf OUT NOCOPY VARCHAR2,
80 retcode OUT NOCOPY VARCHAR2,
81 p_source_table IN VARCHAR2,
82 p_dest_table IN VARCHAR2,
83 p_instance_id IN NUMBER,
84 p_from_date IN DATE,
85 p_to_date IN DATE) ;
86
87 procedure translate_sales_forecast(
88 errbuf OUT NOCOPY VARCHAR2,
89 retcode OUT NOCOPY VARCHAR2,
90 p_source_table IN VARCHAR2,
91 p_dest_table IN VARCHAR2,
92 p_instance_id IN NUMBER,
93 p_fcst_desg IN VARCHAR2,
94 p_from_date IN DATE,
95 p_to_date IN DATE);
96
97 procedure translate_mfg_forecast(
98 errbuf OUT NOCOPY VARCHAR2,
99 retcode OUT NOCOPY VARCHAR2,
100 p_source_table IN VARCHAR2,
101 p_dest_table IN VARCHAR2,
102 p_instance_id IN NUMBER,
103 p_fcst_desg IN VARCHAR2,
104 p_new_refresh_num IN NUMBER,
105 p_delete_flag IN VARCHAR2);
106
107 procedure translate_pricing_data(
108 errbuf OUT NOCOPY VARCHAR2,
109 retcode OUT NOCOPY VARCHAR2,
110 p_source_table IN VARCHAR2,
111 p_dest_table IN VARCHAR2,
112 p_instance_id IN NUMBER,
113 p_price_list IN VARCHAR2,
114 p_new_refresh_num IN NUMBER);
115
116
117 PROCEDURE mfg_post_process( errbuf OUT NOCOPY VARCHAR2,
118 retcode OUT NOCOPY VARCHAR2,
119 p_instance IN VARCHAR2,
120 p_designator IN VARCHAR2,
121 p_new_refresh_num IN NUMBER);
122
123
124 PROCEDURE populate_calendar( errbuf OUT NOCOPY VARCHAR2,
125 retcode OUT NOCOPY VARCHAR2,
126 p_instance IN VARCHAR2,
127 p_new_refresh_num IN NUMBER,
128 p_table_name IN VARCHAR2);
129
130
131
132 FUNCTION Is_Post_Process_Required( errbuf OUT NOCOPY VARCHAR2,
133 retcode OUT NOCOPY VARCHAR2,
134 p_instance IN VARCHAR2,
135 p_designator IN VARCHAR2 ) return BOOLEAN;
136
137
138 PROCEDURE CLEAN_FACT_DATA( errbuf OUT NOCOPY VARCHAR2,
139 retcode OUT NOCOPY VARCHAR2,
140 p_table_name IN VARCHAR2);
141
142 END MSD_TRANSLATE_FACT_DATA;