PACKAGE: APPS.WSH_PR_CREATE_DELIVERIES

Source

1 PACKAGE WSH_PR_CREATE_DELIVERIES AUTHID CURRENT_USER AS
2 /* $Header: WSHPRDLS.pls 115.0 99/07/16 08:19:56 porting ship $ */
3 
4 --
5 -- Package
6 --   	WSH_PR_CREATE_DELIVERIES
7 --
8 -- Purpose
9 --
10 
11   --
12   -- PACKAGE TYPES
13   --
14         TYPE delRecTyp IS RECORD (
15                 header_id                       BINARY_INTEGER,
16 		ship_to_site_use_id             BINARY_INTEGER,
17 		ship_method_code		VARCHAR2(30),
18 		customer_id			BINARY_INTEGER,
19 		fob_code			VARCHAR2(30),
20 		freight_terms_code		VARCHAR2(30),
21 		currency_code			VARCHAR2(15),
22 		delivery_id			BINARY_INTEGER
23 	);
24 
25 	TYPE delRecTabTyp IS TABLE OF delRecTyp INDEX BY BINARY_INTEGER;
26 
27   --
28   -- PUBLIC VARIABLES
29   --
30 	delivery_table				delRecTabTyp;
31 
32   --
33   -- PUBLIC FUNCTIONS/PROCEDURES
34   --
35 
36   --
37   -- Name
38   --   FUNCTION Init
39   --
40   -- Purpose
41   --   Initializes the package
42   --
43   -- Return Values
44   --  -1 => Failure
45   --   0 => Success
46   --
47 
48   FUNCTION Init
49   RETURN BINARY_INTEGER;
50 
51   --
52   -- Name
53   --   FUNCTION Get_Delivery
54   --
55   -- Purpose
56   --   Gets the delivery_id to be used in autocreate deliveries when
57   --   inserting picking line details
58   --
59   -- Arguments
60   --   p_header_id		=> order header id
61   --   p_ship_to_site_use_id	=> ship to site use id (ultimate ship to)
62   --   p_ship_method_code	=> ship method (freight carrier)
63   --
64   -- Return Values
65   --  -1 => Failure
66   --   others => delivery_id
67   --
68 
69   FUNCTION Get_Delivery(
70 	p_header_id		IN		BINARY_INTEGER,
71 	p_ship_to_site_use_id	IN		BINARY_INTEGER,
72 	p_ship_method_code	IN		VARCHAR2,
73 	p_organization_id	IN		BINARY_INTEGER
74   )
75   RETURN BINARY_INTEGER;
76 
77 END WSH_PR_CREATE_DELIVERIES;