PACKAGE: APPS.WSH_PR_CUSTOM

Source

1 PACKAGE WSH_PR_CUSTOM AUTHID CURRENT_USER AS
2 /* $Header: WSHPRCSS.pls 115.1 99/07/16 08:19:50 porting ship $ */
3 
4 --
5 -- Package
6 --   	WSH_PR_PICKING_CUSTOM
7 --
8 -- Purpose
9 --      This package contains user customizable routines for
10 --      Pick Release:
11 --       - Contains mechanism to compute order value
12 --       - Contains mechanism to reorder picking lines
13 --
14 -- History
15 --      20-AUG-96    RSHIVRAM    Created
16 --
17 
18   --
19   -- PUBLIC FUNCTIONS/PROCEDURES
20   --
21 
22   --
23   -- Name
24   --   FUNCTION Outstanding_Order_Value
25   --
26   -- Purpose
27   --   This functions calculates the value of the order, which
28   --   is used in the order by clause for releasing lines.
29   --
30   -- Arguments
31   --   p_header_id
32   --
33   -- Return Values
34   --   - value of order
35   --   - 0 if failure
36   --
37   -- Notes
38   --
39 
40   FUNCTION Outstanding_Order_Value(
41 		p_header_id			IN	BINARY_INTEGER
42   )
43   RETURN BINARY_INTEGER;
44 
45 
46   --
47   -- Name
48   --   FUNCTION Process_lines
49   --
50   -- Purpose
51   --   This functions return the maximum number of lines
52   --   pick release will fetch at a time to process
53   --
54   -- Return Values
55   --   - number of lines
56   --   - -1 not specified, use default
57   --
58   -- Notes
59   --
60 
61   FUNCTION Process_Lines
62   RETURN BINARY_INTEGER;
63 
64 
65 /* Not supported yet */
66   --
67   -- Name
68   --   FUNCTION Reorder_Picking_Line
69   --
70   -- Purpose
71   --   This function reorders picking lines for a given batch.
72   --
73   -- Return Values
74   --  -1 => Failure
75   --   0 => Success
76   --
77   -- Notes
78   --
79 
80   FUNCTION Reorder_Picking_Line(
81 		p_batch_id			IN	BINARY_INTEGER
82   )
83   RETURN BINARY_INTEGER;
84 
85 PRAGMA RESTRICT_REFERENCES(Outstanding_Order_value, WNDS, WNPS);
86 
87 END WSH_PR_CUSTOM;