1 PACKAGE MRP_GET_ONHAND AUTHID CURRENT_USER AS
2 /* $Header: MRPGEOHS.pls 120.0 2005/05/24 17:40:51 appldev noship $ */
3
4 g_x_return_status VARCHAR2(20);
5 g_x_msg_data VARCHAR2(1000);
6 g_x_qoh NUMBER;
7
8 g_mrp_debug VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
9
10 PROCEDURE GET_OH_QTY (item_id IN NUMBER, org_id IN NUMBER,
11 include_nonnet IN NUMBER,
12 x_qoh OUT NOCOPY NUMBER,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_data OUT NOCOPY VARCHAR2);
15
16
17 PROCEDURE do_restock
18 ( x_return_status OUT NOCOPY VARCHAR2
19 , x_msg_count OUT NOCOPY NUMBER
20 , x_msg_data OUT NOCOPY VARCHAR2
21 , p_item_id IN NUMBER
22 , p_mbf IN NUMBER
23 , p_handle_repetitive_item IN NUMBER
24 , p_repetitive_planned_item IN VARCHAR2
25 , p_qty IN NUMBER
26 , p_fixed_lead_time IN NUMBER
27 , p_variable_lead_time IN NUMBER
28 , p_buying_lead_time IN NUMBER
29 , p_uom IN VARCHAR2
30 , p_accru_acct IN NUMBER
31 , p_ipv_acct IN NUMBER
32 , p_budget_acct IN NUMBER
33 , p_charge_acct IN NUMBER
34 , p_purch_flag IN VARCHAR2
35 , p_order_flag IN VARCHAR2
36 , p_transact_flag IN VARCHAR2
37 , p_unit_price IN NUMBER
38 , p_wip_id IN NUMBER
39 , p_user_id IN NUMBER
40 , p_sysd IN DATE
41 , p_organization_id IN NUMBER
42 , p_approval IN NUMBER
43 , p_build_in_wip IN VARCHAR2
44 , p_pick_components IN VARCHAR2
45 , p_src_type IN NUMBER
46 , p_encum_flag IN VARCHAR2
47 , p_customer_id IN NUMBER
48 , p_cal_code IN VARCHAR2
49 , p_except_id IN NUMBER
50 , p_employee_id IN NUMBER
51 , p_description IN VARCHAR2
52 , p_src_org IN NUMBER
53 , p_src_subinv IN VARCHAR2
54 , p_subinv IN VARCHAR2
55 , p_location_id IN NUMBER
56 , p_po_org_id IN NUMBER
57 , p_pur_revision IN NUMBER
58 );
59
60 END MRP_GET_ONHAND;