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