1 package INV_PPEngine_PVT AUTHID CURRENT_USER as
2 /* $Header: INVVPPES.pls 120.1.12010000.2 2009/08/03 12:18:58 mitgupta ship $ */
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 -- Bug8757642. Added p_wave_simulation_mode with default vale 'N' for WavePlanning Project.
70 -- This project is available only in for R121 and mainline. To retain dual maintenance INV code changes are made in branchline, however it will not affect any existing flow.
71 PROCEDURE create_suggestions
72 (
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
75 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
76 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_transaction_temp_id IN NUMBER,
81 p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
82 p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
83 p_plan_tasks IN BOOLEAN DEFAULT FALSE,
84 p_quick_pick_flag IN VARCHAR2 DEFAULT 'N',
85 p_wave_simulation_mode IN VARCHAR2 DEFAULT 'N'
86 ) ;
87 -- API name : Create_Suggestions
88 -- Type : Private
89 -- Function : Creates pick and/or put away suggestions
90 -- The program will use WMS pick/put rules/strategies
91 -- if Oracle WMS is installed; otherwise, rules in
92 -- mtl_picking_rules will be used.
93 -- Overloaded to add a new parameter p_organization_id for Performance bug 5264987
94 PROCEDURE create_suggestions
95 (
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
98 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
99 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_none,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_transaction_temp_id IN NUMBER,
104 p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
105 p_suggest_serial IN VARCHAR2 DEFAULT fnd_api.g_false,
106 p_plan_tasks IN BOOLEAN DEFAULT FALSE,
107 p_quick_pick_flag IN VARCHAR2 DEFAULT 'N',
108 p_organization_id IN NUMBER,
109 p_wave_simulation_mode IN VARCHAR2 DEFAULT 'N'
110 ) ;
111 END inv_ppengine_pvt;