1 package wms_parameter_ext AUTHID CURRENT_USER as
2 /* $Header: WMSGPHLS.pls 115.4 2004/03/05 21:46:07 joabraha noship $ */
3
4 g_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
5 g_miss_char CONSTANT VARCHAR2(1) := fnd_api.g_miss_char;
6 g_miss_date CONSTANT DATE := fnd_api.g_miss_date;
7
8 --==============================================================
9 -- API name : GetPOHeaderLineIDWrap
10 -- Type : Public
11 -- Function : Returns PO Header ID, Line ID or Po Line Location ID
12 -- based on Move Order Line Reference and Reference ID
13 -- and header, line or line location flag.
14 -- ( Used for join condition in seed data )
15 Function GetPOHeaderLineIDWrap(
16 p_transaction_id in number
17 , p_header_flag in varchar2 default 'N'
18 , p_line_flag in varchar2 default 'N'
19 , p_line_location_flag in varchar2 default 'N'
20 ) return number;
21 --
22 --
23 --==============================================================
24 -- API name : GetSOHeaderLineIDWrap
25 -- Type : Public
26 -- Function : Returns SO Header ID or Line ID based on Move
27 -- Order Line Reference and Reference ID
28 -- and headeror line flag.
29 -- ( Used for join condition in seed data )
30 Function GetSOHeaderLineIDWrap(
31 p_transaction_id in number
32 , p_header_flag in varchar2 default 'N'
33 , p_line_flag in varchar2 default 'N'
34 ) return number;
35 --
36 --
37 -- API name : GetItemOnHandWrap
38 -- Type : Private
39 -- Function : This is a wrapper to the function which Returns on hand stock
40 -- of a given inventory item in the transaction UOM in the
41 -- wms_parameter_pvt.( Used for capacity calculation parameters )
42 Function GetItemOnhandWrap(
43 p_organization_id in number default g_miss_num
44 , p_inventory_item_id in number default g_miss_num
45 , p_subinventory_code in varchar2 default g_miss_char
46 , p_locator_id in number default g_miss_num
47 , p_transaction_uom in varchar2 default g_miss_char
48 ) return number;
49 --
50 --
51 Procedure trace(
52 p_message in varchar2
53 , p_level in number default 4
54 );
55 --
56 -- API name : GetNumOtherLots
57 -- Type : Private
58 -- Function : This is a wrapper to the function which Returns the number of
59 -- lots for the given item within the locator other than the given lot
60 -- ( Used for building rules)
61 Function GetNumOtherLotsWrap(
62 p_transaction_id in number default g_miss_num
63 ) return number;
64 --
65 --
66 -- API name : GetLpnQuantityRevLot
67 -- Type : Private
68 -- Function : Returns quantity of the given item, revision, and lot in the given LPN
69 function getlpnquantityrevlot(
70 p_lpn_id in number
71 , p_inventory_item_id in number
72 , p_revision in varchar2 default null
73 , p_lot_number in varchar2 default null
74 , p_organization_id in number
75 ) return number;
76 --
77 --
78 -- API name : GetLpnTotalQuantity
79 -- Type : Private
80 -- Function : Returns quantity of the given item in the given LPN
81 function getlpntotalquantity(
82 p_lpn_id in number
83 , p_inventory_item_id in number
84 , p_organization_id in number
85 ) return number;
86 --
87 --
88 -- API name : GetLpnNumOtherItems
89 -- Type : Private
90 -- Function : Returns number of the given item in the the given LPN
91 function getlpnnumofitems(
92 p_lpn_id in number
93 , p_organization_id in number
94 ) return number;
95 --
96 --
97 -- API name : GetLpnNumOtherRevs
98 -- Type : Private
99 -- Function : Returns number of revisions of the given item in the given LPN
100 function getlpnnumofrevs(
101 p_lpn_id in number
102 , p_inventory_item_id in number
103 , p_organization_id in number
104 ) return number;
105 --
106 --
107 -- API name : GetLpnNumOtherLots
108 -- Type : Private
109 -- Function : Returns number of lots of the given item in the given LPN
110 function getlpnnumoflots(
111 p_lpn_id in number
112 , p_inventory_item_id in number
113 , p_organization_id in number
114 ) return number;
115 --
116 --
117 end wms_parameter_ext;