1 PACKAGE CSP_EXCESS_PARTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvpexs.pls 120.1 2005/08/25 15:23:38 hhaugeru noship $ */
3 procedure excess_parts
4 ( errbuf OUT NOCOPY varchar2
5 ,retcode OUT NOCOPY number
6 ,p_org_id IN NUMBER
7 ,P_level_id IN VARCHAR2
8 ,p_level IN NUMBER
9 ,P_SUBINV_ENABLE_FLAG IN NUMBER default 1
10 ,p_subinv IN VARCHAR2
11 ,p_selection IN NUMBER
12 ,p_cat_set_id IN NUMBER
13 ,p_catg_struct_id IN NUMBER
14 ,p_Catg_lo IN VARCHAR2
15 ,p_catg_hi IN VARCHAR2
16 ,p_item_lo IN VARCHAR2
17 ,p_item_hi IN VARCHAR2
18 ,p_planner_lo IN VARCHAR2
19 ,p_planner_hi IN VARCHAR2
20 ,p_buyer_lo IN VARCHAR2
21 ,p_buyer_hi IN VARCHAR2
22 ,p_sort IN VARCHAR2
23 --,p_range IN NUMBER
24 --,p_low IN VARCHAR2
25 --,p_high IN VARCHAR2
26 ,p_d_cutoff IN VARCHAR2
27 ,p_d_cutoff_rel IN NUMBER
28 ,p_s_cutoff IN VARCHAR2
29 ,p_s_cutoff_rel IN NUMBER
30 ,p_user_id IN NUMBER
31 ,p_restock IN NUMBER
32 ,p_handle_rep_item IN NUMBER
33 ,p_dd_loc_id IN NUMBER
34 ,p_net_unrsv IN NUMBER
35 ,p_net_rsv IN NUMBER
36 ,p_net_wip IN NUMBER
37 ,p_include_po IN NUMBER
38 ,p_include_wip IN NUMBER
39 ,p_include_if IN NUMBER
40 ,p_include_nonnet IN NUMBER
41 ,p_lot_ctl IN NUMBER
42 ,p_display_mode IN NUMBER
43 ,p_show_desc IN NUMBER
44 ,p_pur_revision IN NUMBER
45 ,p_called_from IN VARCHAR2 default 'STD'
46 );
47
48 FUNCTION get_business_rule(
49 p_organization_id IN NUMBER,
50 p_subinventory_code IN VARCHAR2)
51 return number;
52
53 procedure defective_return(
54 p_organization_id number,
55 p_subinventory_code varchar2,
56 p_planning_parameters_id number,
57 p_level_id varchar2,
58 p_parts_loop_id number,
59 p_hierarchy_node_id number,
60 p_called_from varchar2);
61
62 procedure clean_up(
63 p_organization_id number,
64 p_subinventory_code varchar2,
65 p_condition_type varchar2);
66
67 procedure apply_business_rules(
68 p_organization_id number,
69 p_subinventory_code varchar2 default null,
70 p_excess_rule_id number);
71
72 PROCEDURE Build_Item_Cat_Select(p_Cat_structure_id IN NUMBER
73 ,x_item_select OUT NOCOPY VARCHAR2
74 ,x_cat_Select OUT NOCOPY VARCHAR2
75 );
76 PROCEDURE Build_Range_Sql
77 ( p_cat_structure_id IN NUMBER
78 , p_cat_lo IN VARCHAR2
79 , p_cat_hi IN VARCHAR2
80 , p_item_lo IN VARCHAR2
81 , p_item_hi IN VARCHAR2
82 , p_planner_lo IN VARCHAR2
83 , p_planner_hi IN VARCHAR2
84 , p_lot_ctl IN NUMBER
85 , x_range_sql OUT NOCOPY VARCHAR2
86 );
87
88 FUNCTION onhand
89 ( p_organization_id IN NUMBER,
90 p_inventory_item_id IN NUMBER,
91 p_subinventory_code IN VARCHAR2,
92 p_revision_qty_control_code IN NUMBER,
93 p_include_nonnet IN NUMBER,
94 p_planning_level IN NUMBER
95 ) return number;
96
97 function demand(
98 p_organization_id number,
99 p_inventory_item_id number,
100 p_subinventory_code varchar2,
101 p_include_nonnet number, -- 2
102 p_planning_level number, -- 2
103 p_net_unreserved number, -- 1
104 p_net_reserved number, -- 1
105 p_net_wip number, -- 1
106 p_demand_cutoff number -- number of days
107 )
108 return number;
109
110 function get_shipped_qty
111 (p_organization_id IN NUMBER,
112 p_inventory_item_id IN NUMBER,
113 p_order_line_id IN NUMBER
114 ) return NUMBER;
115
116 PROCEDURE NODE_LEVEL_ID(p_level_id IN VARCHAR2);
117 FUNCTION NODE_LEVEL_ID return VARCHAR2;
118 end;