PACKAGE: APPS.CSP_PART_SEARCH_PVT

Source

1 PACKAGE csp_part_search_pvt AUTHID CURRENT_USER as
2 /*$Header: cspvsrcs.pls 120.3.12020000.2 2012/07/13 11:12:15 htank ship $*/
3 -- Start of Comments
4 -- Package name     : CSP_PART_SEARCH_PVT
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 TYPE search_params_rec IS RECORD (
11   search_method          varchar2(30):= null,
12   my_inventory           boolean := null,
13   technicians            boolean := null,
14   manned_warehouses      boolean := null,
15   unmanned_warehouses    boolean := null,
16   include_alternates     boolean := null,
17   include_closed         boolean := null,
18   quantity_type          varchar2(30) := 'AVAILABLE',
19   ship_set               boolean := null,
20   need_by_date           date    := null,
21   resource_type          varchar2(30) := null,
22   resource_id            number  := null,
23   distance               number  := null,
24   distance_uom           varchar2(30) := null,
25   source_organization_id number := null,
26   source_subinventory    varchar2(30) := null,
27   to_location_id         number := null,
28   to_hz_location_id      number := null,
29   current_location       boolean := null,
30   requirement_header_id  number := null,
31   called_from            varchar2(30) := 'OTHER');
32 
33 
34 TYPE required_parts_rec IS RECORD (
35   inventory_item_id          number := null,
36   revision                   varchar2(3) := null,
37   quantity                   number := null);
38 
39 TYPE  required_parts_tbl IS TABLE OF required_parts_rec
40                                     INDEX BY BINARY_INTEGER;
41 
42 procedure search(p_required_parts IN required_parts_tbl,
43                  p_search_params  IN search_params_rec,
44                  x_return_status  OUT NOCOPY varchar2,
45                  x_msg_data       OUT NOCOPY varchar2,
46                  x_msg_count      OUT NOCOPY varchar2
47 )  ;
48 
49 function get_avail_qty (
50              p_organization_id   number,
51              p_subinventory_code varchar2,
52              p_inventory_item_id number,
53              p_revision          varchar2,
54              p_quantity_type     varchar2)
55   return number;
56 
57 function get_arrival_time(
58              p_cutoff            date     default null,
59              p_cutoff_tz         number   default null,
60              p_lead_time         number   default null,
61              p_lead_time_uom     varchar2 default null,
62              p_intransit_time    number   default null,
63              p_delivery_time     date     default null,
64              p_safety_zone       number   default null,
65              p_location_id       number   default null,
66              p_location_source   varchar2 default null,
67              p_organization_id   number   default null,
68              p_subinventory_code varchar2 default null)
69   return date;
70 
71 function get_ship_to_tz(
72              p_location_id       number   default null,
73              p_location_source   varchar2 default null)
74   return number;
75 
76 function get_src_distance (
77       p_req_header_id number,
78       p_src_org_id number,
79       p_src_subinv varchar2
80     )
81     return varchar2;
82 
83 function get_cutoff_time(
84 		p_cutoff	date,
85 		p_cutoff_tz	number
86 	) return date;
87 
88 end;
89