PACKAGE: APPS.FTE_LOCATION_PARAMETERS_PKG

Source

1 PACKAGE FTE_LOCATION_PARAMETERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: FTEGFACS.pls 115.7 2004/07/21 11:52:28 alksharm noship $ */
3 
4   --
5   -- Package FTE_LOCATION_PARAMETERS_PKG
6   --
7 
8 l_debug_on     BOOLEAN := TRUE;
9 g_debug_set    BOOLEAN := TRUE;
10 
11 TYPE Index_Varchar100_Tbl_Type  IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
12 
13 --NON-INDEXED TABLES
14 TYPE NoIndex_Number_Tbl_Type      IS TABLE OF NUMBER;
15 TYPE NoIndex_Varchar100_Tbl_Type  IS TABLE OF VARCHAR2(100);
16 
17 TYPE TL_FAC_INFO_REC_TYPE IS RECORD(
18 
19 location_id             NUMBER,
20 stop_id                 NUMBER,
21 fac_code                VARCHAR2(60),
22 loading_protocol        VARCHAR2(30),
23 fac_charge_basis        VARCHAR2(30),
24 fac_handling_time       NUMBER,
25 fac_currency            VARCHAR2(30),
26 fac_modifier_id         NUMBER,
27 fac_pricelist_id        NUMBER,
28 fac_weight_uom_class    VARCHAR2(30),
29 fac_weight_uom          VARCHAR2(30),
30 fac_volume_uom_class    VARCHAR2(30),
31 fac_volume_uom          VARCHAR2(30),
32 fac_distance_uom_class  VARCHAR2(30),
33 fac_distance_uom        VARCHAR2(30),
34 fac_time_uom_class      VARCHAR2(30),
35 fac_time_uom            VARCHAR2(30));
36 
37 
38 TYPE TL_FAC_INFO_TAB_TYPE  IS TABLE OF  TL_FAC_INFO_REC_TYPE INDEX BY BINARY_INTEGER;
39 
40 PROCEDURE Create_Facilities (p_location_ids    IN   WSH_LOCATIONS_PKG.ID_Tbl_Type,
41                              p_company_names   IN   WSH_LOCATIONS_PKG.Address_Tbl_Type,
42                              p_site_names      IN   WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
43                              x_return_status   OUT  NOCOPY  VARCHAR2,
44                              x_error_msg       OUT  NOCOPY  VARCHAR2);
45 
46 PROCEDURE Create_Facility (p_location_id   IN   NUMBER,
47                            p_facility_code IN   VARCHAR2  default  NULL,
48                            x_return_status OUT  NOCOPY  VARCHAR2,
49                            x_error_msg     OUT  NOCOPY  VARCHAR2);
50 
51 PROCEDURE Get_Fac_Info (x_fac_info_rows IN OUT NOCOPY Tl_Fac_Info_Tab_Type,
52                         x_return_status    OUT NOCOPY VARCHAR2 );
53 
54 PROCEDURE Get_Fac_Lat_Long_and_TimeZone(p_country IN VARCHAR2,
55 			p_city IN VARCHAR2,
56 			p_postalcode IN VARCHAR2,
57 			p_state IN VARCHAR2,
58 			p_county IN VARCHAR2,
59 			p_province IN VARCHAR2,
60 			x_return_status OUT NOCOPY VARCHAR2,
61 			x_msg_count OUT NOCOPY VARCHAR2,
62 			x_msg_data OUT NOCOPY VARCHAR2,
63 			x_latitude OUT NOCOPY VARCHAR2,
64 			x_longitude OUT NOCOPY VARCHAR2,
65 			x_timezone OUT NOCOPY VARCHAR2,
66 			x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY
67 			);
68 
69 END FTE_LOCATION_PARAMETERS_PKG;
70