1 package INV_PPEngine_PVT as
2 /* $Header: INVVPPES.pls 120.1 2006/06/28 11:24:32 bradha noship $ */
3
4 -- File : INVVPPES.pls
5 -- Content : INV_PPEngine_PVT package specification
6 -- Description : Pick / put away engine private API's
7 -- Notes :
8 -- Modified : 30/10/98 ckuenzel created
9 -- 02/08/99 mzeckzer changed
10 -- 07/30/03 grao changed
11 --
12 TYPE g_number_tbl_type IS TABLE OF NUMBER;
13 --
14 -- API name : Create_Suggestions
15 -- Type : Private
16 -- Function : Creates pick and/or put away suggestions
17 -- The program will use WMS pick/put rules/strategies
18 -- if Oracle WMS is installed; otherwise, rules in
19 -- mtl_picking_rules will be used.
20 --
21 -- Notes
22 -- 1. Integration with reservations
23 -- If table p_reservations passed by the calling is not empty, the
24 -- engine will detailing based on a combination of the info in the
25 -- move order line (the record that represents detailing request),
26 -- and the info in p_reservations. For example, a sales order line
27 -- can have two reservations, one for revision A in quantity of 10,
28 -- and one for revision B in quantity of 5, and the line quantity
29 -- can be 15; so when the pick release api calls the engine
30 -- p_reservations will have two records of the reservations. So
31 -- if the move order line based on the sales order line does not
32 -- specify a revision, the engine will merge the information from
33 -- move order line and p_reservations to create the input for
34 -- detailing as two records, one for revision A, and one for revision
35 -- B. Please see documentation for the pick release API for more
36 -- details.
37 --
38 -- 2. Serial Number Detailing in Picking
39 -- Currently the serial number detailing is quite simple. If the caller
40 -- gives a range (start, and end) serial numbers in the move order line
41 -- and pass p_suggest_serial as fnd_api.true, the engine will filter
42 -- the locations found from a rule, and suggest unused serial numbers
43 -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
44 -- (default), the engine will not give serial numbers in the output.
45 --
46 -- Input Parameters
47 -- p_api_version_number standard input parameter
48 -- p_init_msg_lst standard input parameter
49 -- p_commit standard input parameter
50 -- p_validation_level standard input parameter
51 -- p_transaction_temp_id equals to the move order line id
52 -- for the detailing request
53 -- p_reservations reservations for the demand source
54 -- as the transaction source
55 -- in the move order line.
56 -- p_suggest_serial whether or not the engine should suggest
57 -- serial numbers in the detailing
58
59 -- p_quick_pick_flag This flag is used to call quick pick functionality for the Inventory Move
60 -- If the value is 'Y' in Patch set 'J' onwords, Picking rule validation will
61 -- not be called. The Default Value is 'N'
62 -- Output Parameters
63 -- x_return_status standard output parameters
64 -- x_msg_count standard output parameters
65 -- x_msg_data standard output parameters
66 --
67 -- Version : Current version 1.0
68 --
69 PROCEDURE create_suggestions
70 (
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
73 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
74 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_transaction_temp_id IN NUMBER,
79 p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
80 p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
81 p_plan_tasks IN BOOLEAN DEFAULT FALSE,
82 p_quick_pick_flag IN VARCHAR2 DEFAULT 'N'
83 ) ;
84 -- API name : Create_Suggestions
85 -- Type : Private
86 -- Function : Creates pick and/or put away suggestions
87 -- The program will use WMS pick/put rules/strategies
88 -- if Oracle WMS is installed; otherwise, rules in
89 -- mtl_picking_rules will be used.
90 -- Overloaded to add a new parameter p_organization_id for Performance bug 5264987
91 PROCEDURE create_suggestions
92 (
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_transaction_temp_id IN NUMBER,
101 p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
102 p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
103 p_plan_tasks IN BOOLEAN DEFAULT FALSE,
104 p_quick_pick_flag IN VARCHAR2 DEFAULT 'N',
105 p_organization_id IN NUMBER
106 ) ;
107 END inv_ppengine_pvt;