1 PACKAGE gme_picking_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVPCKS.pls 120.1.12020000.2 2013/01/30 15:41:31 gmurator ship $ */
3 TYPE mtl_req_rec IS RECORD (
4 organization_id NUMBER
5 ,batch_id NUMBER
6 ,material_detail_id NUMBER
7 ,inventory_item_id NUMBER
8 ,revision VARCHAR2 (3)
9 ,subinventory VARCHAR2 (10)
10 ,locator_id NUMBER
11 ,open_qty NUMBER
12 ,dtl_um VARCHAR2 (3)
13 ,mtl_req_date DATE
14 );
15
16 TYPE mtl_req_tab IS TABLE OF mtl_req_rec
17 INDEX BY BINARY_INTEGER;
18
19 PROCEDURE conc_picking (
20 err_buf OUT NOCOPY VARCHAR2
21 ,ret_code OUT NOCOPY VARCHAR2
22 ,p_organization_id IN NUMBER
23 ,p_all_batches IN VARCHAR2
24 , -- 1 = All, 2 = Backordered
25 p_include_pending IN VARCHAR2
26 ,p_include_wip IN VARCHAR2
27 ,p_from_batch IN VARCHAR2
28 ,p_to_batch IN VARCHAR2
29 ,p_oprn_no IN VARCHAR2
30 ,p_oprn_vers IN NUMBER
31 ,p_product_no IN VARCHAR2
32 ,p_ingredient_no IN VARCHAR2
33 ,p_days_forward IN NUMBER
34 ,p_from_req_date IN VARCHAR2
35 ,p_to_req_date IN VARCHAR2
36 ,p_pick_grouping_rule IN VARCHAR2
37 ,p_print_pick_slip IN VARCHAR2 DEFAULT 'N'
38 ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
39 ,p_sales_order IN VARCHAR2);
40
41 -- Added p_called_by parameter to be used for Endeca view.
42 /* Bug 5212556 Added inventory_item_id */
43 FUNCTION get_open_qty (
44 p_organization_id IN NUMBER
45 ,p_batch_id IN NUMBER
46 ,p_material_detail_id IN NUMBER
47 ,p_inventory_item_id IN NUMBER
48 ,p_subinventory IN VARCHAR2
49 ,p_plan_qty IN NUMBER
50 ,p_wip_plan_qty IN NUMBER
51 ,p_actual_qty IN NUMBER
52 ,p_backordered_qty IN NUMBER
53 ,p_dtl_um IN VARCHAR2
54 ,p_called_by IN VARCHAR2 DEFAULT 'P')
55 RETURN NUMBER;
56
57 PROCEDURE pick_material (
58 p_mtl_req_tbl IN gme_picking_pvt.mtl_req_tab
59 ,p_task_group_id IN NUMBER
60 ,p_print_pick_slip IN VARCHAR2 DEFAULT 'N'
61 ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_conc_request_id OUT NOCOPY NUMBER);
64
65 PROCEDURE process_line (
66 p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
67 ,p_grouping_rule_id IN NUMBER
68 ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
69 ,x_return_status OUT NOCOPY VARCHAR2);
70 END gme_picking_pvt;