1 PACKAGE MSD_SR_UTIL AUTHID CURRENT_USER AS
2 /* $Header: msdutils.pls 120.7 2011/12/09 11:47:48 rissingh ship $ */
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 FUNCTION IS_PF_FORECASTABLE ( p_org_id in NUMBER,
74 p_inventory_item_id in NUMBER,
75 p_product_family_item_id in NUMBER,
76 p_check_optional in NUMBER,
77 pf_available in NUMBER default 1) RETURN NUMBER;
78
79
80
81 FUNCTION CONFIG_ITEM_EXISTS ( p_header_id IN NUMBER,
82 p_org_id IN NUMBER,
83 p_ato_line_id IN NUMBER) RETURN NUMBER;
84
85 FUNCTION get_zone_attr return varchar2;
86
87 function set_customer_attr( p_profile_name IN VARCHAR2,
88 p_profile_value IN VARCHAR2,
89 p_profile_Level IN VARCHAR2) return number;
90
91 FUNCTION get_sr_zone_pk ( p_location_id IN NUMBER,
92 p_zone_attr IN VARCHAR2) RETURN NUMBER;
93
94 FUNCTION get_service_req_org_id (p_txn_source_id IN NUMBER) return NUMBER;
95
96 FUNCTION get_service_req_acct_id (p_txn_source_id IN NUMBER,
97 p_cust_filter in VARCHAR2) return NUMBER;
98
99 FUNCTION get_service_req_zone_id (p_txn_source_id IN NUMBER,
100 p_zone_filter in VARCHAR2) return NUMBER;
101
102 FUNCTION is_txn_depot_repair(p_txn_source_id IN NUMBER) return VARCHAR2;
103
104
105 FUNCTION get_customer_id( p_party_id IN NUMBER) return NUMBER ;
106
107 FUNCTION dp_enabled_item (p_inventory_item_id in NUMBER,
108 p_organization_id in NUMBER) return NUMBER; --jarorad
109
110 /*vinekuma */
111 /*Is used in Liability Analysis Views */
112 function get_all_sup_pk return number;
113 function get_all_sup_desc return varchar2;
114 function get_all_auth_pk return number;
115 function get_all_auth_desc return varchar2;
116 /*vinekuma */
117
118 function get_suppliers_pk return number; --jarorad
119 function get_suppliers_desc return VARCHAR2; --jarorad
120 function get_internal_customers_desc return VARCHAR2;
121
122 FUNCTION get_onhand_quantity(
123 p_organization_id in number,
124 p_inventory_item_id in number,
125 p_transaction_date in date
126 ) return number;
127
128 /* Bug# 5367784 */
129
130 FUNCTION get_sr_custzone_pk ( p_location_id IN NUMBER,
131 p_customer_id IN NUMBER,
132 p_zone_attr IN VARCHAR2) RETURN VARCHAR2;
133
134 FUNCTION get_sr_custzone_desc ( p_location_id IN NUMBER,
135 p_customer_name IN VARCHAR2,
136 p_zone_attr IN VARCHAR2) RETURN VARCHAR2;
137
138 FUNCTION get_sr_zone_pk1 ( p_location_id IN NUMBER,
139 p_zone_attr IN VARCHAR2) RETURN NUMBER;
140
141 FUNCTION get_sr_zone_desc ( p_location_id IN NUMBER,
142 p_zone_attr IN VARCHAR2) RETURN VARCHAR2;
143
144 END MSD_SR_UTIL;