1 Package CSP_MIN_MAX_PLANNING AUTHID CURRENT_USER AS
2 /*$Header: cspppmms.pls 120.0 2005/05/25 11:41:59 appldev noship $*/
3 --
4 --
5
6 PROCEDURE NODE_LEVEL_ID(p_level_id IN VARCHAR2);
7 FUNCTION NODE_LEVEL_ID return VARCHAR2;
8
9 PROCEDURE RUN_MIN_MAX
10 ( errbuf OUT NOCOPY varchar2
11 ,retcode OUT NOCOPY number
12 ,p_org_id IN NUMBER
13 ,P_level_id IN VARCHAR2
14 ,p_level IN NUMBER
15 ,P_SUBINV_ENABLE_FLAG IN NUMBER
16 ,p_subinv IN VARCHAR2
17 ,p_selection IN NUMBER
18 ,p_cat_set_id IN NUMBER
19 ,p_catg_struct_id IN NUMBER
20 ,p_Catg_lo IN VARCHAR2
21 ,p_catg_hi IN VARCHAR2
22 ,p_item_lo IN VARCHAR2
23 ,p_item_hi IN VARCHAR2
24 ,p_planner_lo IN VARCHAR2
25 ,p_planner_hi IN VARCHAR2
26 ,p_buyer_lo IN VARCHAR2
27 ,p_buyer_hi IN VARCHAR2
28 ,p_sort IN VARCHAR2
29 --,p_range IN NUMBER
30 --,p_low IN VARCHAR2
31 --,p_high IN VARCHAR2
32 ,p_d_cutoff IN VARCHAR2
33 ,p_d_cutoff_rel IN NUMBER
34 ,p_s_cutoff IN VARCHAR2
35 ,p_s_cutoff_rel IN NUMBER
36 ,p_user_id IN NUMBER
37 ,p_restock IN NUMBER
38 ,p_handle_rep_item IN NUMBER
39 ,p_dd_loc_id IN NUMBER
40 ,p_net_unrsv IN NUMBER
41 ,p_net_rsv IN NUMBER
42 ,p_net_wip IN NUMBER
43 ,p_include_po IN NUMBER
44 ,p_include_mo IN NUMBER
45 ,p_include_wip IN NUMBER
46 ,p_include_if IN NUMBER
47 ,p_include_nonnet IN NUMBER
48 ,p_lot_ctl IN NUMBER
49 ,p_display_mode IN NUMBER
50 ,p_show_desc IN NUMBER
51 ,p_pur_revision IN NUMBER
52 );
53
54 END; -- Package spec