1 PACKAGE CSP_EXCESS_PARTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvpexs.pls 120.7 2010/11/15 12:09:20 htank ship $ */
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 procedure find_best_routing_rule (
49 p_source_type IN VARCHAR2
50 , p_source_org_id IN NUMBER
51 , p_source_subinv IN VARCHAR2
52 , p_source_terr_id IN NUMBER
53 , p_ret_trans_type IN VARCHAR2
54 , p_item_id IN NUMBER
55 , x_rule_id OUT NOCOPY NUMBER
56 , x_return_status OUT NOCOPY VARCHAR2
57 , x_msg_count OUT NOCOPY NUMBER
58 , x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 FUNCTION get_business_rule(
62 p_organization_id IN NUMBER,
63 p_subinventory_code IN VARCHAR2)
64 return number;
65
66 procedure defective_return(
67 p_organization_id number,
68 p_subinventory_code varchar2,
69 p_planning_parameters_id number,
70 p_level_id varchar2,
71 p_parts_loop_id number,
72 p_hierarchy_node_id number,
73 p_called_from varchar2);
74
75 procedure clean_up(
76 p_organization_id number,
77 p_subinventory_code varchar2,
78 p_condition_type varchar2);
79
80 procedure apply_business_rules(
81 p_organization_id number,
82 p_subinventory_code varchar2 default null,
83 p_excess_rule_id number);
84
85 PROCEDURE Build_Item_Cat_Select(p_Cat_structure_id IN NUMBER
86 ,x_item_select OUT NOCOPY VARCHAR2
87 ,x_cat_Select OUT NOCOPY VARCHAR2
88 );
89 PROCEDURE Build_Range_Sql
90 ( p_cat_structure_id IN NUMBER
91 , p_cat_lo IN VARCHAR2
92 , p_cat_hi IN VARCHAR2
93 , p_item_lo IN VARCHAR2
94 , p_item_hi IN VARCHAR2
95 , p_planner_lo IN VARCHAR2
96 , p_planner_hi IN VARCHAR2
97 , p_lot_ctl IN NUMBER
98 , x_range_sql OUT NOCOPY VARCHAR2
99 );
100
101 FUNCTION onhand
102 ( p_organization_id IN NUMBER,
103 p_inventory_item_id IN NUMBER,
104 p_subinventory_code IN VARCHAR2,
105 p_revision_qty_control_code IN NUMBER,
106 p_include_nonnet IN NUMBER,
107 p_planning_level IN NUMBER
108 ) return number;
109
110 function demand(
111 p_organization_id number,
112 p_inventory_item_id number,
113 p_subinventory_code varchar2,
114 p_include_nonnet number, -- 2
115 p_planning_level number, -- 2
116 p_net_unreserved number, -- 1
117 p_net_reserved number, -- 1
118 p_net_wip number, -- 1
119 p_demand_cutoff number -- number of days
120 )
121 return number;
122
123 function get_shipped_qty
124 (p_organization_id IN NUMBER,
125 p_inventory_item_id IN NUMBER,
126 p_order_line_id IN NUMBER
127 ) return NUMBER;
128
129 PROCEDURE NODE_LEVEL_ID(p_level_id IN VARCHAR2);
130 FUNCTION NODE_LEVEL_ID return VARCHAR2;
131
132 -- bug # 8518127
133 PROCEDURE populate_excess_list (
134 p_excess_part IN OUT nocopy CSP_EXCESS_LISTS_PKG.EXCESS_RECORD_TYPE,
135 p_is_insert_record IN VARCHAR2 default 'Y'
136 );
137
138 procedure charges_return_routing(
139 p_return_type in varchar2,
140 p_hz_location_id in number,
141 p_item_id in number,
142 x_operating_unit out nocopy number,
143 x_organization_id out nocopy number,
144 x_subinventory_code out nocopy varchar2,
145 x_hz_location_id out nocopy number,
146 x_hr_location_id out nocopy number,
147 x_return_status out nocopy varchar2,
148 x_msg_count out nocopy number,
149 x_msg_data out nocopy varchar2);
150
151 end;