DBA Data[Home] [Help]

PACKAGE: APPS.MSC_CL_PUBLISH

Source


1 PACKAGE MSC_CL_PUBLISH AUTHID CURRENT_USER AS
2 /* $Header: MSCXCPS.pls 115.7 2003/11/12 02:14:16 pshah ship $ */
3 
4     TYPE number_arr IS TABLE OF NUMBER;
5 	TYPE acceptance_flags IS TABLE OF msc_sup_dem_entries.acceptance_required_flag%TYPE;
6 
7     TYPE shippingControlList    IS TABLE OF msc_trading_partner_sites.shipping_control%TYPE;
8 
9     PROCEDURE PUBLISH (ERRBUF		OUT NOCOPY VARCHAR2,
10 		       RETCODE		OUT NOCOPY NUMBER,
11 		       p_sr_instance_id	NUMBER,
12     		   p_user_id	NUMBER,
13 	           p_po_enabled_flag	NUMBER,
14 		       p_oh_enabled_flag	NUMBER,
15 		       p_so_enabled_flag	NUMBER,
16 		       p_asl_enabled_flag	NUMBER,
17 		       p_sup_resp_flag		NUMBER,
18                p_po_sn_flag         NUMBER,
19                p_oh_sn_flag         NUMBER,
20                p_so_sn_flag         NUMBER,
21 			   p_suprep_sn_flag     NUMBER
22 		      );
23 
24 /* Global parameters for Conncurrent request purpose */
25    G_SUCCESS                    CONSTANT NUMBER := 0;
26    G_WARNING                    CONSTANT NUMBER := 1;
27    G_ERROR                      CONSTANT NUMBER := 2;
28 
29 /* Global Parameters for Automatic Collections purpose */
30    G_AUTO_NO_COLL               CONSTANT NUMBER := 2;
31    G_AUTO_NET_COLL              CONSTANT NUMBER := 3;
32    G_AUTO_TAR_COLL              CONSTANT NUMBER := 4;
33 
34    SYS_YES                      CONSTANT NUMBER := 1;
35    SYS_NO                       CONSTANT NUMBER := 2;
36    G_MSC_DEBUG   VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
37 
38 END;