[Home] [Help]
PACKAGE: APPS.FTE_ACS_RULE_UTIL_PKG
Source
1 PACKAGE FTE_ACS_RULE_UTIL_PKG AS
2 /* $Header: FTEACSXS.pls 120.1 2005/06/06 09:50:22 appldev $ */
3
4 -- -----------------------------------------------------------------------------------
5 -- FUNCTION SPECIFICATIONS
6 -- -----------------------
7 --
8 -- -----------------------------------------------------------------------------------
9 FUNCTION CONV_TO_BASE_UOM(p_input_value IN NUMBER,
10 p_from_uom IN VARCHAR2,
11 p_to_uom IN VARCHAR2) RETURN NUMBER;
12
13 -- -----------------------------------------------------------------------------------
14 -- PROCEDURE SPECIFICATIONS
15 -- ------------------------
16 --
17 -- -----------------------------------------------------------------------------------
18 --
19 -- R12 Enhancements
20 --
21 PROCEDURE GET_FORMATED_REGIONS( p_location_id IN NUMBER,
22 x_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
23 x_all_region_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
24 x_postal_zone_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
25 x_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE GET_POSTAL_CODE(p_location_id IN NUMBER,
28 x_postal_code OUT NOCOPY VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2);
30
31
32 PROCEDURE SET_RANGE_OVERLAP_FLAG(p_group_id IN NUMBER);
33
34
35 PROCEDURE INSERT_INTO_GTT( p_input_data IN FTE_ACS_PKG.fte_cs_entity_tab_type,
36 x_return_status OUT NOCOPY VARCHAR2);
37
38 PROCEDURE FORMAT_ENTITY_INFO( p_input_cs_tab IN OUT NOCOPY FTE_ACS_PKG.fte_cs_entity_tab_type,
39 p_entity IN VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2);
41
42 PROCEDURE GET_SHIP_METHOD_CODE(p_carrier_id IN NUMBER,
43 p_service_level IN VARCHAR2,
44 p_mode_of_transport IN VARCHAR2,
45 p_org_id IN NUMBER,
46 x_ship_method_code OUT NOCOPY VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_return_message OUT NOCOPY VARCHAR2);
49
50 PROCEDURE GET_CANDIDATE_RECORDS( p_search_level IN VARCHAR2,
51 p_query_gtt IN BOOLEAN,
52 p_single_rec IN FTE_ACS_PKG.FTE_CS_ENTITY_REC_TYPE DEFAULT NULL,
53 x_output_tab OUT NOCOPY FTE_ACS_CACHE_PKG.FTE_CS_ENTITY_ATTR_TAB,
54 x_return_status OUT NOCOPY VARCHAR2);
55
56 END FTE_ACS_RULE_UTIL_PKG;
57