1 PACKAGE MSD_DEM_SR_UTIL AS
2 /* $Header: msddemsus.pls 120.2.12000000.3 2007/09/24 11:33:06 nallkuma noship $ */
3
4 /*** CONSTANTS ***/
5
6
7 /*** PROCEDURES ***
8 * EXECUTE_REMOTE_QUERY
9 */
10
11 /*
12 * This procedure executes a query passed from a remote database.
13 */
14
15 procedure EXECUTE_REMOTE_QUERY(query IN VARCHAR2);
16
17
18 /*** FUNCTIONS ***
19 * SET_CUSTOMER_ATTRIBUTE
20 * GET_CATEGORY_SET_ID
21 * GET_CONVERSION_TYPE
22 * GET_MASTER_ORGANIZATION
23 * GET_CUSTOMER_ATTRIBUTE
24 */
25
26
27
28 /*
29 * Usability Enhancements. Bug # 3509147.
30 * This function sets the value of profile MSD_CUSTOMER_ATTRIBUTE to NONE
31 * if collecting for the first time
32 */
33 FUNCTION SET_CUSTOMER_ATTRIBUTE (
34 p_profile_code IN VARCHAR2,
35 p_profile_value IN VARCHAR2,
36 p_profile_level IN VARCHAR2)
37 RETURN NUMBER;
38
39 /*
40 * This function gets the value of the source profile MSD_DEM_CATEGORY_SET_NAME
41 */
42 FUNCTION GET_CATEGORY_SET_ID
43 RETURN NUMBER;
44
45 /*
46 * This function gets the value of the source profile MSD_DEM_CONVERSION_TYPE
47 */
48 FUNCTION GET_CONVERSION_TYPE
49 RETURN VARCHAR2;
50
51 /*
52 * This function gets the ID of the master organization in the source instance.
53 */
54 FUNCTION GET_MASTER_ORGANIZATION
55 RETURN NUMBER;
56
57 /*
58 * This function gets the value of the source profile MSD_DEM_CUSTOMER_ATTRIBUTE
59 */
60 FUNCTION GET_CUSTOMER_ATTRIBUTE
61 RETURN VARCHAR2;
62
63
64 function get_null_pk return number;
65
66 function get_null_code return VARCHAR2;
67
68 function get_null_desc return VARCHAR2;
69
70 function uom_conv (uom_code varchar2,
71 item_id number) return number;
72
73 FUNCTION IS_ITEM_OPTIONAL_FOR_LVL(p_component_item_id in NUMBER) RETURN NUMBER;
74
75
76 FUNCTION IS_PRODUCT_FAMILY_FORECASTABLE (p_org_id in NUMBER,
77 p_inventory_item_id in NUMBER,
78 p_check_optional in NUMBER) RETURN NUMBER;
79
80 FUNCTION CONFIG_ITEM_EXISTS ( p_header_id IN NUMBER,
81 p_org_id IN NUMBER,
82 p_ato_line_id IN NUMBER) RETURN NUMBER;
83
84 function convert_global_amt(p_curr_code in varchar2, p_date in date) return number;
85
86 FUNCTION get_zone_attr return varchar2; --jarora
87
88 FUNCTION get_sr_zone_desc ( p_location_id IN NUMBER,
89 p_zone_attr IN VARCHAR2) RETURN VARCHAR2; --jarora
90
91 FUNCTION get_sr_zone_pk ( p_location_id IN NUMBER,
92 p_zone_attr IN VARCHAR2) RETURN NUMBER; --jarora
93
94 FUNCTION is_txn_depot_repair(p_txn_source_id IN NUMBER) return VARCHAR2; --jarora
95
96 FUNCTION get_service_req_org_id (p_txn_source_id IN NUMBER) return NUMBER; --jarora
97
98 END MSD_DEM_SR_UTIL;