1 PACKAGE gme_move_orders_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVMOVS.pls 120.2 2011/05/20 14:44:34 gmurator ship $ */
3
4 -- Bug 9941121 Add new parameter p_grouping_rule_id.
5 PROCEDURE create_move_order_hdr (
6 p_organization_id IN NUMBER
7 ,p_move_order_type IN NUMBER
8 ,p_grouping_rule_id IN NUMBER DEFAULT 0
9 ,x_move_order_header_id OUT NOCOPY NUMBER
10 ,x_return_status OUT NOCOPY VARCHAR2);
11
12 PROCEDURE create_move_order_lines (
13 p_move_order_header_id IN NUMBER
14 ,p_move_order_type IN NUMBER
15 ,p_material_details_tbl IN gme_common_pvt.material_details_tab
16 ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab
17 ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
18 ,x_return_status OUT NOCOPY VARCHAR2);
19
20 PROCEDURE create_batch_move_order (
21 p_batch_header_rec IN gme_batch_header%ROWTYPE
22 ,p_material_details_tbl IN gme_common_pvt.material_details_tab
23 ,x_return_status OUT NOCOPY VARCHAR2);
24
25 PROCEDURE get_move_order_lines (
26 p_organization_id IN NUMBER
27 ,p_batch_id IN NUMBER
28 ,p_material_detail_id IN NUMBER
29 ,x_mo_line_tbl OUT NOCOPY gme_common_pvt.mo_lines_tab
30 ,x_return_status OUT NOCOPY VARCHAR2);
31
32 PROCEDURE delete_move_order_lines (
33 p_organization_id IN NUMBER
34 ,p_batch_id IN NUMBER
35 ,p_material_detail_id IN NUMBER
36 ,p_invis_move_line_id IN NUMBER DEFAULT NULL
37 ,p_invis_move_header_id IN NUMBER DEFAULT NULL
38 ,x_return_status OUT NOCOPY VARCHAR2);
39
40 PROCEDURE update_move_order_lines (
41 p_batch_id IN NUMBER
42 ,p_material_detail_id IN NUMBER
43 ,p_new_qty IN NUMBER := NULL
44 ,p_new_date IN DATE := NULL
45 ,p_invis_move_line_id IN NUMBER DEFAULT NULL
46 ,x_return_status OUT NOCOPY VARCHAR2);
47
48 FUNCTION pending_move_orders_exist (
49 p_organization_id IN NUMBER
50 ,p_batch_id IN NUMBER
51 ,p_material_detail_id IN NUMBER)
52 RETURN BOOLEAN;
53
54 PROCEDURE get_pending_move_order_qty (
55 p_mtl_dtl_rec IN gme_material_details%ROWTYPE
56 ,x_pending_qty OUT NOCOPY NUMBER
57 ,x_return_status OUT NOCOPY VARCHAR2);
58
59 PROCEDURE delete_batch_move_orders (
60 p_organization_id IN NUMBER
61 ,p_batch_id IN NUMBER
62 ,p_delete_invis IN VARCHAR2 := 'F'
63 ,x_return_status OUT NOCOPY VARCHAR2);
64 END gme_move_orders_pvt;