PACKAGE: APPS.WSH_PICK_CUSTOM

Source

1 PACKAGE WSH_PICK_CUSTOM AUTHID CURRENT_USER AS
2 /* $Header: WSHPRCUS.pls 115.1 2002/05/15 19:04:05 pkm ship    $ */
3 
4 --
5 -- Package
6 --        WSH_PICK_CUSTOM
7 --
8 -- Purpose
9 --      This package contains user customizable routines for
10 --      Pick Release:
11 --       - Contains mechanism to compute order value
12 --
13   --
14   -- PUBLIC FUNCTIONS/PROCEDURES
15   --
16 
17   --
18   -- Name
19   --   FUNCTION Outstanding_Order_Value
20   --
21   -- Purpose
22   --   This functions calculates the value of the order, which
23   --   is used in the order by clause for releasing lines.
24   --
25   -- Arguments
26   --   p_header_id
27   --
28   -- Return Values
29   --   - value of order
30   --   - 0 if failure
31   --
32   -- Notes
33 
34   FUNCTION Outstanding_Order_Value(
35           p_header_id              IN   BINARY_INTEGER
36   )
37   RETURN BINARY_INTEGER;
38 
39 PRAGMA RESTRICT_REFERENCES(Outstanding_Order_value, WNDS, WNPS);
40 
41 END WSH_PICK_CUSTOM;