1 PACKAGE gme_picking_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVPCKS.pls 120.1.12010000.1 2008/07/25 10:31:15 appldev 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 /* Bug 5212556 Added inventory_item_id */
42 FUNCTION get_open_qty (
43 p_organization_id IN NUMBER
44 ,p_batch_id IN NUMBER
45 ,p_material_detail_id IN NUMBER
46 ,p_inventory_item_id IN NUMBER
47 ,p_subinventory IN VARCHAR2
48 ,p_plan_qty IN NUMBER
49 ,p_wip_plan_qty IN NUMBER
50 ,p_actual_qty IN NUMBER
51 ,p_backordered_qty IN NUMBER
52 ,p_dtl_um IN VARCHAR2)
53 RETURN NUMBER;
54
55 PROCEDURE pick_material (
56 p_mtl_req_tbl IN gme_picking_pvt.mtl_req_tab
57 ,p_task_group_id IN NUMBER
58 ,p_print_pick_slip IN VARCHAR2 DEFAULT 'N'
59 ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_conc_request_id OUT NOCOPY NUMBER);
62
63 PROCEDURE process_line (
64 p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
65 ,p_grouping_rule_id IN NUMBER
66 ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
67 ,x_return_status OUT NOCOPY VARCHAR2);
68 END gme_picking_pvt;