1 PACKAGE MSC_X_UTIL AUTHID CURRENT_USER AS
2 /* $Header: MSCXUTLS.pls 115.18 2004/03/19 01:48:23 pshah ship $ */
3
4 G_COMPANY_MAPPING CONSTANT NUMBER := 1;
5 G_ORGANIZATION_MAPPING CONSTANT NUMBER := 2;
6 G_COMPANY_SITE_MAPPING CONSTANT NUMBER := 3;
7
8 G_SUPPLIER CONSTANT NUMBER := 1;
9 G_CUSTOMER CONSTANT NUMBER := 2;
10 G_ORGANIZATION CONSTANT NUMBER := 3;
11 G_SUPPLIER_SITE CONSTANT NUMBER := 5;
12 G_CUSTOMER_SITE CONSTANT NUMBER := 6;
13
14 OEM_COMPANY_ID CONSTANT NUMBER := 1;
15
16 G_COMPANY_SITE CONSTANT NUMBER := 3;
17
18 -- function get_party_name takes in party_id and returns the party
19 -- name from HZ_PARTIES
20 FUNCTION GET_PARTY_NAME (p_party_id IN NUMBER)
21 RETURN VARCHAR2;
22
23 -- function get_xref_party_name takes in party_id s of a trading partner
24 -- and a cross referenced trading partner and returns the xref name of the
25 -- cross referenced trading partner
26 FUNCTION GET_XREF_PARTY_NAME (p_party_id IN NUMBER, p_xref_party_id IN NUMBER)
27 RETURN VARCHAR2;
28
29 -- function get_buyer_code takes in inventory_item_id of an item
30 -- and returns the buyer code for that item.
31 FUNCTION GET_BUYER_CODE(p_inventory_item_id IN NUMBER,
32 p_publisher_id IN NUMBER,
33 p_publisher_site_id IN NUMBER,
34 p_customer_id IN NUMBER,
35 p_customer_site_id IN NUMBER,
36 p_supplier_id IN NUMBER,
37 p_supplier_site_id IN NUMBER)
38 RETURN VARCHAR2;
39
40
41 -- function get_category_code takes in inventory_item_id of an item,
42 -- customer and supplier info and returns the category name of the
43 -- item defined in the OEM's org.
44 FUNCTION GET_CATEGORY_CODE(p_inventory_item_id IN NUMBER,
45 p_publisher_id IN NUMBER,
46 p_publisher_site_id IN NUMBER,
47 p_customer_id IN NUMBER,
48 p_customer_site_id IN NUMBER,
49 p_supplier_id IN NUMBER,
50 p_supplier_site_id IN NUMBER)
51 RETURN VARCHAR2;
52
53 --- Procedure to create partitions if they have not already been
54 -- created. Called from plan creation script.
55 PROCEDURE CREATE_EXCH_PARTITIONS(p_status OUT NOCOPY NUMBER);
56
57 PROCEDURE GET_UOM_CONVERSION_RATES(p_uom_code IN VARCHAR2,
58 p_dest_uom_code IN VARCHAR2,
59 p_inventory_item_id IN NUMBER DEFAULT 0,
60 p_conv_found OUT NOCOPY BOOLEAN,
61 p_conv_rate OUT NOCOPY NUMBER);
62
63 FUNCTION UPDATE_SHIP_RCPT_DATES (
64 p_customer_id IN NUMBER,
65 p_customer_site_id IN NUMBER,
66 p_supplier_id IN NUMBER,
67 p_supplier_site_id IN NUMBER,
68 p_order_type IN NUMBER,
69 p_item_id IN NUMBER,
70 p_ship_date IN DATE,
71 p_rcpt_date IN DATE) RETURN DATE;
72
73 FUNCTION GET_CUSTOMER_TRANSIT_TIME(p_publisher_id IN NUMBER,
74 p_publisher_site_id IN NUMBER,
75 p_customer_id IN NUMBER,
76 p_customer_site_id IN NUMBER) RETURN NUMBER;
77
78 FUNCTION GET_LOOKUP_MEANING(p_lookup_type in varchar2,
79 p_order_type_code in Number)
80 RETURN varchar2;
81
82 PROCEDURE SCE_TO_APS(
83 p_map_type IN NUMBER,
84 p_sce_company_id IN NUMBER,
85 p_sce_company_site_id IN NUMBER,
86 p_relationship_type IN NUMBER,
87 aps_partner_id OUT NOCOPY NUMBER,
88 aps_partner_site_id OUT NOCOPY NUMBER,
89 aps_sr_instance_id OUT NOCOPY NUMBER
90 );
91
92 PROCEDURE GET_CALENDAR_CODE(
93 p_supplier_id in number,
94 p_supplier_site_id in number,
95 p_customer_id in number,
96 p_customer_site_id in number,
97 p_calendar_code out nocopy varchar2,
98 p_sr_instance_id out nocopy number,
99 p_tp_ids in number default 1,
100 p_tp_instance_id in number default 99999,
101 p_oem_ident in number default 3);
102
103 FUNCTION GET_SHIPPING_CONTROL(p_customer_name IN VARCHAR2,
104 p_customer_site_name IN VARCHAR2,
105 p_supplier_name IN VARCHAR2,
106 p_supplier_site_name IN VARCHAR2)
107 RETURN NUMBER;
108
109 FUNCTION GET_SHIPPING_CONTROL_ID(l_customer_id IN NUMBER,
110 l_customer_site_id IN NUMBER,
111 l_supplier_id IN NUMBER,
112 l_supplier_site_id IN NUMBER)
113 RETURN NUMBER;
114
115
116 FUNCTION GET_BUYER_CODE(p_inventory_item_id IN NUMBER,
117 p_organization_id IN NUMBER,
118 p_sr_instance_id IN NUMBER
119 )
120 RETURN VARCHAR2;
121
122 END MSC_X_UTIL;