1 PACKAGE INV_MMX_WRAPPER_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVMMXWS.pls 115.5 2003/09/29 22:25:11 yssingh ship $ */
3
4 -- Package Variable Declarations.
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_MMX_WRAPPER_PVT';
7
8
9 -- PL/SQL table TYPE for set of subinventories.
10 TYPE SubInvTableType IS TABLE OF MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE INDEX BY BINARY_INTEGER;
11
12 PROCEDURE exec_min_max
13 ( x_return_status OUT NOCOPY VARCHAR2
14 , x_msg_count OUT NOCOPY NUMBER
15 , x_msg_data OUT NOCOPY VARCHAR2
16 , p_organization_id IN NUMBER
17 , p_user_id IN NUMBER
18 , p_subinv_tbl IN SubInvTableType
19 , p_employee_id IN NUMBER DEFAULT NULL
20 , p_gen_report IN VARCHAR2 DEFAULT 'N'
21 , p_mo_line_grouping IN NUMBER DEFAULT 1
22 , p_item_select IN VARCHAR2 DEFAULT NULL
23 , p_handle_rep_item IN NUMBER DEFAULT 3
24 , p_pur_revision IN NUMBER DEFAULT NULL
25 , p_cat_select IN VARCHAR2 DEFAULT NULL
26 , p_cat_set_id IN NUMBER DEFAULT NULL
27 , p_mcat_struct IN NUMBER DEFAULT NULL
28 , p_level IN NUMBER DEFAULT 2
29 , p_restock IN NUMBER DEFAULT 1
30 , p_include_nonnet IN NUMBER DEFAULT 1
31 , p_include_po IN NUMBER DEFAULT 1
32 , p_include_mo IN NUMBER DEFAULT 1
33 , p_include_wip IN NUMBER DEFAULT 2
34 , p_include_if IN NUMBER DEFAULT 1
35 , p_net_rsv IN NUMBER DEFAULT 1
36 , p_net_unrsv IN NUMBER DEFAULT 1
37 , p_net_wip IN NUMBER DEFAULT 2
38 , p_dd_loc_id IN NUMBER DEFAULT NULL
39 , p_buyer_hi IN VARCHAR2 DEFAULT NULL
40 , p_buyer_lo IN VARCHAR2 DEFAULT NULL
41 , p_range_buyer IN VARCHAR2 DEFAULT '1 = 1'
42 , p_range_sql IN VARCHAR2 DEFAULT '1 = 1'
43 , p_sort IN VARCHAR2 DEFAULT 1
44 , p_selection IN NUMBER DEFAULT 3
45 , p_sysdate IN DATE DEFAULT SYSDATE
46 , p_s_cutoff IN DATE DEFAULT NULL
47 , p_d_cutoff IN DATE DEFAULT NULL
48 );
49
50 PROCEDURE do_restock
51 ( x_return_status OUT NOCOPY VARCHAR2
52 , x_msg_count OUT NOCOPY NUMBER
53 , x_msg_data OUT NOCOPY VARCHAR2
54 , p_item_id IN NUMBER
55 , p_mbf IN NUMBER
56 , p_handle_repetitive_item IN NUMBER
57 , p_repetitive_planned_item IN VARCHAR2
58 , p_qty IN NUMBER
59 , p_fixed_lead_time IN NUMBER
60 , p_variable_lead_time IN NUMBER
61 , p_buying_lead_time IN NUMBER
62 , p_uom IN VARCHAR2
63 , p_accru_acct IN NUMBER
64 , p_ipv_acct IN NUMBER
65 , p_budget_acct IN NUMBER
66 , p_charge_acct IN NUMBER
67 , p_purch_flag IN VARCHAR2
68 , p_order_flag IN VARCHAR2
69 , p_transact_flag IN VARCHAR2
70 , p_unit_price IN NUMBER
71 , p_wip_id IN NUMBER
72 , p_user_id IN NUMBER
73 , p_sysd IN DATE
74 , p_organization_id IN NUMBER
75 , p_approval IN NUMBER
76 , p_build_in_wip IN VARCHAR2
77 , p_pick_components IN VARCHAR2
78 , p_src_type IN NUMBER
79 , p_encum_flag IN VARCHAR2
80 , p_customer_id IN NUMBER
81 , p_customer_site_id IN NUMBER DEFAULT NULL
82 , p_cal_code IN VARCHAR2
83 , p_except_id IN NUMBER
84 , p_employee_id IN NUMBER
85 , p_description IN VARCHAR2
86 , p_src_org IN NUMBER
87 , p_src_subinv IN VARCHAR2
88 , p_subinv IN VARCHAR2
89 , p_location_id IN NUMBER
90 , p_po_org_id IN NUMBER
91 , p_pur_revision IN NUMBER
92 , p_mo_line_grouping IN NUMBER DEFAULT 1
93 );
94
95
96 PROCEDURE get_move_order_info
97 ( x_return_status OUT NOCOPY VARCHAR2
98 , x_msg_count OUT NOCOPY NUMBER
99 , x_msg_data OUT NOCOPY VARCHAR2
100 , x_move_order_header_id OUT NOCOPY NUMBER
101 , x_move_order_line_num OUT NOCOPY NUMBER
102 , p_user_id IN NUMBER
103 , p_organization_id IN NUMBER
104 , p_subinv IN VARCHAR2
105 , p_src_subinv IN VARCHAR2
106 , p_approval IN NUMBER
107 , p_need_by_date IN DATE
108 );
109
110 END INV_MMX_WRAPPER_PVT;