1 PACKAGE CSP_Minmax_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvmmxs.pls 115.0 2003/04/25 18:49:49 phegde noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_Minmax_PVT';
5
6 PROCEDURE run_min_max_plan ( p_item_select IN VARCHAR2
7 , p_handle_rep_item IN NUMBER
8 , p_pur_revision IN NUMBER
9 , p_cat_select IN VARCHAR2
10 , p_cat_set_id IN NUMBER
11 , p_mcat_struct IN NUMBER
12 , p_level IN NUMBER
13 , p_restock IN NUMBER
14 , p_include_nonnet IN NUMBER
15 , p_include_po IN NUMBER
16 , p_include_wip IN NUMBER
17 , p_include_if IN NUMBER
18 , p_net_rsv IN NUMBER
19 , p_net_unrsv IN NUMBER
20 , p_net_wip IN NUMBER
21 , p_org_id IN NUMBER
22 , p_user_id IN NUMBER
23 , p_employee_id IN NUMBER
24 , p_subinv IN VARCHAR2
25 , p_dd_loc_id IN NUMBER
26 , p_wip_batch_id IN NUMBER
27 , p_approval IN NUMBER
28 , p_buyer_hi IN VARCHAR2
29 , p_buyer_lo IN VARCHAR2
30 , p_range_buyer IN VARCHAR2
31 , p_cust_id IN NUMBER
32 , p_po_org_id IN NUMBER
33 , p_range_sql IN VARCHAR2
34 , p_sort IN VARCHAR2
35 , p_selection IN NUMBER
36 , p_sysdate IN DATE
37 , p_s_cutoff IN DATE
38 , p_d_cutoff IN DATE
42 , p_exception_set_id IN NUMBER
39 , p_order_by IN VARCHAR2
40 , p_encum_flag IN VARCHAR2
41 , p_cal_code IN VARCHAR2
43 , x_return_status OUT NOCOPY VARCHAR2
44 , x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 --Bug# 2677358
48 FUNCTION get_onhand_qty( p_include_nonnet NUMBER
49 , p_level NUMBER
50 , p_org_id NUMBER
51 , p_subinv VARCHAR2
52 , p_item_id NUMBER
56 , p_mbf IN NUMBER
53 , p_sysdate DATE) RETURN NUMBER;
54
55 PROCEDURE do_restock( p_item_id IN NUMBER
57 , p_handle_repetitive_item IN NUMBER
58 , p_repetitive_planned_item IN VARCHAR2
59 , p_qty IN NUMBER
60 , p_fixed_lead_time IN NUMBER
61 , p_variable_lead_time IN NUMBER
62 , p_buying_lead_time IN NUMBER
63 , p_uom IN VARCHAR2
64 , p_accru_acct IN NUMBER
65 , p_ipv_acct IN NUMBER
66 , p_budget_acct IN NUMBER
67 , p_charge_acct IN NUMBER
68 , p_purch_flag IN VARCHAR2
69 , p_order_flag IN VARCHAR2
70 , p_transact_flag IN VARCHAR2
71 , p_unit_price IN NUMBER
72 , p_wip_id IN NUMBER
73 , p_user_id IN NUMBER
74 , p_sysd IN DATE
75 , p_organization_id IN NUMBER
76 , p_approval IN NUMBER
77 , p_build_in_wip IN VARCHAR2
78 , p_pick_components IN VARCHAR2
79 , p_src_type IN NUMBER
80 , p_encum_flag IN VARCHAR2
81 , p_customer_id IN NUMBER
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 , x_ret_stat OUT NOCOPY VARCHAR2
93 , x_ret_mesg OUT NOCOPY VARCHAR2);
94
95
96 FUNCTION get_shipped_qty( p_organization_id IN NUMBER
97 , p_inventory_item_id IN NUMBER
98 , p_order_line_id IN NUMBER) RETURN NUMBER;
99
100 PRAGMA RESTRICT_REFERENCES(get_shipped_qty, WNDS);
101
102
103 FUNCTION get_staged_qty( p_org_id NUMBER
104 , p_subinv VARCHAR2
105 , p_item_id NUMBER
106 , p_order_line_id NUMBER
107 , p_include_nonnet NUMBER) RETURN NUMBER;
108
109 PRAGMA RESTRICT_REFERENCES(get_staged_qty, WNDS);
110
111
112 FUNCTION get_pick_released_qty( p_org_id NUMBER
113 , p_subinv VARCHAR2
114 , p_item_id NUMBER
115 , p_order_line_id NUMBER) RETURN NUMBER;
116
117 PRAGMA RESTRICT_REFERENCES(get_pick_released_qty, WNDS);
118
119 --
120 END CSP_Minmax_PVT;