1 PACKAGE OE_XML_PROCESS_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUPOXS.pls 120.1 2005/07/19 11:07:01 jjmcfarl noship $ */
3
4 G_PKG_NAME VARCHAR2(30) := 'OE_XML_PROCESS_UTIL';
5
6 -- This function will concatenate two given strings
7 Procedure Concat_Strings(
8 String1 IN VARCHAR2,
9 String2 IN VARCHAR2,
10 OUT_String OUT NOCOPY VARCHAR2
11
12 );
13
14 -- This function will get the site id(SHIP_TO)
15 Procedure Get_Ship_To_Org_Id(
16 p_address_id IN NUMBER,
17 x_ship_to_org_id OUT NOCOPY NUMBER
18
19 );
20
21 -- This function will get the site id(BILL_TO)
22 Procedure Get_Bill_To_Org_Id(
23 p_address_id IN NUMBER,
24 x_bill_to_org_id OUT NOCOPY NUMBER
25
26 );
27
28 -- This function will get the Customer Id
29 Procedure Get_Sold_To_Org_Id(
30 p_address_id IN NUMBER,
31 x_sold_to_org_id OUT NOCOPY NUMBER
32
33 );
34
35 Procedure Get_Sold_To_Edi_Loc(
36 p_sold_to_org_id IN Number,
37 x_edi_location_code OUT NOCOPY Varchar2,
38
39 x_sold_to_name OUT NOCOPY Varchar2
40
41 );
42
43 Procedure Get_Ship_From_Edi_Loc(
44 p_ship_from_org_id IN Number,
45 x_edi_location_code OUT NOCOPY Varchar2
46
47 );
48
49 -- This function will get the Total of the Order or specific Line
50 Procedure Get_Order_Total(
51 p_header_id IN NUMBER,
52 p_line_id IN NUMBER,
53 p_total_type IN VARCHAR2 DEFAULT 'ALL',
54 x_order_line_total OUT NOCOPY NUMBER
55
56 );
57
58 PROCEDURE Get_Processing_Msgs
59 ( p_request_id in varchar2,
60 p_order_source_id in number := 20,
61 p_orig_sys_document_ref in varchar2 := NULL,
62 p_orig_sys_line_ref in varchar2 := NULL,
63 p_ack_code in varchar2 := '0',
64 p_org_id in number := null,
65 x_error_text out nocopy varchar2,
66
67 x_result out nocopy varchar2
68
69 );
70
71 Procedure Get_Sales_Person
72 (
73 p_salesrep_id IN Number,
74 x_salesrep OUT NOCOPY Varchar2
75
76 );
77
78 Procedure Get_Line_Ordered_Quantity
79 (
80 p_orig_sys_document_ref IN VARCHAR2,
81 p_orig_sys_line_ref IN VARCHAR2,
82 p_orig_sys_shipment_ref IN VARCHAR2,
83 p_order_source_id IN NUMBER,
84 p_sold_to_org_id IN NUMBER := NULL,
85 x_ordered_quantity OUT NOCOPY NUMBER
86
87 );
88
89 Procedure Get_Line_Ordered_Quantity_UOM
90 (
91 p_orig_sys_document_ref IN VARCHAR2,
92 p_orig_sys_line_ref IN VARCHAR2,
93 p_orig_sys_shipment_ref IN VARCHAR2,
94 p_order_source_id IN NUMBER,
95 p_sold_to_org_id IN NUMBER := NULL,
96 x_ordered_quantity_uom OUT NOCOPY VARCHAR2
97
98 );
99
100 PROCEDURE Set_Cancelled_Flag
101 (
102 p_orig_sys_document_ref in varchar2,
103 p_transaction_type in varchar2,
104 p_order_source_id in number,
105 p_sold_to_org_id in number := null,
106 p_change_sequence in varchar2 := null,
107 p_org_id in number,
108 p_xml_message_id in number
109 );
110
111 PROCEDURE Clear_Oe_Header_And_Line_Acks
112 (p_orig_sys_document_ref in varchar2,
113 p_ack_type in varchar2,
114 p_sold_to_org_id in number := NULL,
115 p_change_sequence in varchar2 := NULL,
116 p_request_id in number := NULL
117 );
118
119 Procedure Derive_Line_Operation_Code
120 ( p_orig_sys_document_ref in varchar2,
121 p_orig_sys_line_ref in varchar2,
122 p_orig_sys_shipment_ref in varchar2,
123 p_order_source_id in number,
124 p_sold_to_org_id in number := NULL,
125 p_org_id in number,
126 x_operation_code OUT NOCOPY varchar2
127 );
128
129 Procedure get_address_details
130 (p_site_use_id In Number,
131 p_site_use_code In Varchar2,
132 x_location Out NOCOPY Varchar2,
133 x_address1 Out NOCOPY Varchar2,
134 x_address2 Out NOCOPY Varchar2,
135 x_address3 Out NOCOPY Varchar2,
136 x_address4 Out NOCOPY Varchar2,
137 x_city Out NOCOPY Varchar2,
138 x_state Out NOCOPY Varchar2,
139 x_country Out NOCOPY Varchar2,
140 x_postal_code Out NOCOPY Varchar2,
141 x_edi_location_code Out NOCOPY varchar2,
142 x_customer_name Out NOCOPY Varchar2,
143 x_return_status Out NOCOPY Varchar2
144 );
145
146 Procedure Get_Contact_Details
147 (p_contact_id In Number,
148 p_cust_acct_id In Number,
149 x_first_name Out NOCOPY Varchar2,
150 x_last_name Out NOCOPY Varchar2,
151 x_return_status Out NOCOPY Varchar2
152 );
153
154 Procedure Check_Rejected_Level
155 (p_header_ack_code In Varchar2,
156 p_line_ack_code In Varchar2,
157 p_shipment_ack_code In Varchar2,
158 p_response_profile In Varchar2,
159 p_ordered_quantity In Number,
160 p_response_flag In Varchar2,
161 p_level_code In Varchar2,
162 x_insert_flag Out Nocopy Varchar2);
163
164 Procedure Process_Response_Reject
165 (p_header_ack_code In Varchar2,
166 p_line_ack_code In Varchar2,
167 p_shipment_ack_code In Varchar2,
168 p_ordered_quantity In Number,
169 p_response_flag In Varchar2,
170 p_event_raised_flag In Varchar2,
171 p_level_code In Varchar2,
172 p_orig_sys_document_ref In Varchar2,
173 p_change_sequence In Varchar2,
174 p_org_id In Varchar2,
175 p_sold_to_org_id In Number,
176 p_xml_message_id In Number,
177 p_confirmation_flag In Varchar2 DEFAULT NULL,
178 p_confirmation_message In Varchar2 DEFAULT NULL,
179 x_insert_level Out Nocopy Varchar2,
180 x_raised_event Out Nocopy Varchar2);
181
182
183 END OE_XML_PROCESS_UTIL;