1 PACKAGE MSD_SR_UTIL AS
2 /* $Header: msdutils.pls 120.6 2006/07/04 12:05:32 sjagathe noship $ */
3
4
5 /* Public Functions */
6
7 --function org(p_org_id in NUMBER) return VARCHAR2;
8 function item(p_item_id in NUMBER, p_org_id in NUMBER) return VARCHAR2;
9 function cust(p_cust_id in NUMBER) return VARCHAR2;
10 function schn(p_schn_id in VARCHAR2) return VARCHAR2;
11 function srep(p_srep_id in NUMBER, p_org_id in NUMBER) return VARCHAR2;
12 function uom_conv(uom_code varchar2, item_id number) return number;
13 function get_item_cost(p_item_id in number, p_org_id in number) return number;
14 function convert_global_amt(p_curr_code in varchar2, p_date in date) return number;
15 function shipped_date(p_departure_id in number) return date;
16 function booked_date(p_header_id in number) return date;
17 function location(p_loc_id in number) return varchar2;
18 function Master_Organization return number;
19 function item_organization return varchar2; /* Bug# 4157588 */
20 function get_category_set_id return number;
21 function get_eol_category_set_id return number;
22 function get_conversion_type return varchar2;
23 function get_customer_attr return varchar2;
24
25
26
27 function get_null_pk return number;
28 function get_null_desc return varchar2;
29 function get_all_scs_pk return number;
30 function get_all_scs_desc return varchar2;
31 function get_all_geo_pk return number;
32 function get_all_geo_desc return varchar2;
33 function get_all_org_pk return number;
34 function get_all_org_desc return varchar2;
35 function get_all_prd_pk return number;
36 function get_all_prd_desc return varchar2;
37 function get_all_rep_pk return number;
38 function get_all_rep_desc return varchar2;
39
40 function get_all_dcs_pk return number;
41 function get_all_dcs_desc return VARCHAR2;
42
43
44 FUNCTION get_dimension_desc(p_type varchar2,
45 p_code varchar2) return VARCHAR2;
46
47
48
49 function on_hold(p_header_id in number, p_line_id in number) return varchar2;
50
51 FUNCTION IS_ITEM_OPTIONAL_FOR_LVL(p_component_item_id in NUMBER) RETURN NUMBER;
52
53 /* Bug# 4157588 */
54 FUNCTION IS_ITEM_OPTIONAL_FOR_LVL(p_component_item_id in NUMBER, p_org_id in NUMBER) RETURN NUMBER;
55
56 FUNCTION IS_ITEM_OPTIONAL_FOR_FACT(p_component_item_id in NUMBER,
57 p_component_sequence_id in NUMBER,
58 p_parent_line_id in NUMBER) RETURN NUMBER;
59
60 FUNCTION FIND_PARENT_ITEM (p_link_to_line_id in NUMBER,
61 p_include_class in varchar2) RETURN NUMBER;
62
63
64 /*
65 FUNCTION FIND_PARENT_FOR_PTO( p_comp_seq_id IN NUMBER,
66 p_link_to_line_id IN NUMBER,
67 p_include_class IN VARCHAR2) RETURN NUMBER;
68 */
69
70 FUNCTION IS_PRODUCT_FAMILY_FORECASTABLE (p_org_id in NUMBER,
71 p_inventory_item_id in NUMBER,
72 p_check_optional in NUMBER) RETURN NUMBER;
73
74 FUNCTION CONFIG_ITEM_EXISTS ( p_header_id IN NUMBER,
75 p_org_id IN NUMBER,
76 p_ato_line_id IN NUMBER) RETURN NUMBER;
77
78 FUNCTION get_zone_attr return varchar2;
79
80 function set_customer_attr( p_profile_name IN VARCHAR2,
81 p_profile_value IN VARCHAR2,
82 p_profile_Level IN VARCHAR2) return number;
83
84 FUNCTION get_sr_zone_pk ( p_location_id IN NUMBER,
85 p_zone_attr IN VARCHAR2) RETURN NUMBER;
86
87 FUNCTION get_service_req_org_id (p_txn_source_id IN NUMBER) return NUMBER;
88
89 FUNCTION get_service_req_acct_id (p_txn_source_id IN NUMBER,
90 p_cust_filter in VARCHAR2) return NUMBER;
91
92 FUNCTION get_service_req_zone_id (p_txn_source_id IN NUMBER,
93 p_zone_filter in VARCHAR2) return NUMBER;
94
95 FUNCTION is_txn_depot_repair(p_txn_source_id IN NUMBER) return VARCHAR2;
96
97
98 FUNCTION get_customer_id( p_party_id IN NUMBER) return NUMBER ;
99
100 FUNCTION dp_enabled_item (p_inventory_item_id in NUMBER,
101 p_organization_id in NUMBER) return NUMBER; --jarorad
102
103 /*vinekuma */
104 /*Is used in Liability Analysis Views */
105 function get_all_sup_pk return number;
106 function get_all_sup_desc return varchar2;
107 function get_all_auth_pk return number;
108 function get_all_auth_desc return varchar2;
109 /*vinekuma */
110
111 function get_suppliers_pk return number; --jarorad
112 function get_suppliers_desc return VARCHAR2; --jarorad
113 function get_internal_customers_desc return VARCHAR2;
114
115 FUNCTION get_onhand_quantity(
116 p_organization_id in number,
117 p_inventory_item_id in number,
118 p_transaction_date in date
119 ) return number;
120
121 /* Bug# 5367784 */
122
123 FUNCTION get_sr_custzone_pk ( p_location_id IN NUMBER,
124 p_customer_id IN NUMBER,
125 p_zone_attr IN VARCHAR2) RETURN VARCHAR2;
126
127 FUNCTION get_sr_custzone_desc ( p_location_id IN NUMBER,
128 p_customer_name IN VARCHAR2,
129 p_zone_attr IN VARCHAR2) RETURN VARCHAR2;
130
131 FUNCTION get_sr_zone_pk1 ( p_location_id IN NUMBER,
132 p_zone_attr IN VARCHAR2) RETURN NUMBER;
133
134 FUNCTION get_sr_zone_desc ( p_location_id IN NUMBER,
135 p_zone_attr IN VARCHAR2) RETURN VARCHAR2;
136
137 END MSD_SR_UTIL;