PACKAGE: APPS.MSD_SOP_FACT_DATA

Source

1 PACKAGE MSD_SOP_FACT_DATA AUTHID CURRENT_USER AS
2 /* $Header: msdsfdcs.pls 120.1 2005/12/08 22:22:55 sjagathe noship $ */
3 
4 
5     Type cs_name_rec is RECORD (
6         cs_name            varchar2(30)
7         );
8     Type cs_name_list is TABLE of cs_name_rec index by binary_integer;
9 
10 
11     Type cs_id_rec is RECORD (
12         cs_definition_id       number
13         );
14     Type cs_id_list is TABLE of cs_id_rec index by binary_integer;
15 
16 
17     PROCEDURE sop_fact_data_collect(errbuf             OUT NOCOPY VARCHAR2,
18                                    retcode             OUT NOCOPY VARCHAR2,
19                                    p_instance_id       IN NUMBER,
20                                    p_date_from	       IN VARCHAR2,
21                                    p_date_to           IN VARCHAR2,
22                                 /* p_booking_data      IN NUMBER,
23                                    p_shipment_data     IN NUMBER,             Bug# 4867205*/
24                                    p_total_backlog     IN NUMBER,
25                                    p_pastdue_backlog   IN NUMBER,
26                                    p_onhand_inventory  IN NUMBER,
27                                    p_production_plan   IN NUMBER,
28                                    p_actual_production IN NUMBER
29                                        );
30 
31 
32     PROCEDURE sop_fact_data_pull(errbuf      OUT NOCOPY VARCHAR2,
33                                  retcode     OUT NOCOPY VARCHAR2
34                                 );
35 
36 END MSD_SOP_FACT_DATA;