DBA Data[Home] [Help]

APPS.OE_LINE_SECURITY dependencies on OE_ACKNOWLEDGMENT_PUB

Line 129: OE_Acknowledgment_Pub.Is_Delivery_Required

125: x_on_operation_action = 3 And
126: nvl(p_record.transaction_phase_code,'F') = 'F'
127: Then
128: If p_record.order_source_id = 20 Then
129: OE_Acknowledgment_Pub.Is_Delivery_Required
130: (
131: p_customer_id => p_record.sold_to_org_id,
132: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
133: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

Line 132: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

128: If p_record.order_source_id = 20 Then
129: OE_Acknowledgment_Pub.Is_Delivery_Required
130: (
131: p_customer_id => p_record.sold_to_org_id,
132: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
133: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
134: x_party_id => l_party_id,
135: x_party_site_id => l_party_site_id,
136: x_is_delivery_required => l_is_delivery_reqd,

Line 133: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

129: OE_Acknowledgment_Pub.Is_Delivery_Required
130: (
131: p_customer_id => p_record.sold_to_org_id,
132: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
133: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
134: x_party_id => l_party_id,
135: x_party_site_id => l_party_site_id,
136: x_is_delivery_required => l_is_delivery_reqd,
137: x_return_status => l_return_status

Line 153: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

149: p_entity_id => p_record.header_id,
150: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
151: p_requesting_entity_id => p_record.header_id,
152: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
153: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
154: p_param1 => p_record.header_id,
155: p_param2 => p_record.order_source_id,
156: p_param3 => p_record.orig_sys_document_ref,
157: p_param4 => p_record.sold_to_org_id,

Line 160: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

156: p_param3 => p_record.orig_sys_document_ref,
157: p_param4 => p_record.sold_to_org_id,
158: p_param5 => Null,
159: p_param6 => p_record.org_id,
160: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
161: p_param8 => Null,
162: p_param9 => p_record.sold_to_org_id,
163: p_param10 => l_party_site_id,
164: p_param11 => Null,

Line 174: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

170: p_entity_id => p_record.line_id,
171: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
172: p_requesting_entity_id => p_record.line_id,
173: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
174: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
175: p_param1 => p_record.header_id,
176: p_param2 => p_record.order_source_id,
177: p_param3 => p_record.orig_sys_document_ref,
178: p_param4 => p_record.sold_to_org_id,

Line 181: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

177: p_param3 => p_record.orig_sys_document_ref,
178: p_param4 => p_record.sold_to_org_id,
179: p_param5 => Null,
180: p_param6 => p_record.org_id,
181: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
182: p_param8 => Null,
183: p_param9 => p_record.sold_to_org_id,
184: p_param10 => l_party_site_id,
185: x_return_status => l_return_status);

Line 199: OE_Acknowledgment_Pub.Is_Delivery_Required

195: (p_column_name => p_column_name,
196: p_on_operation_action => .1);
197:
198: If p_record.order_source_id = 20 Then
199: OE_Acknowledgment_Pub.Is_Delivery_Required
200: (
201: p_customer_id => p_record.sold_to_org_id,
202: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
203: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

Line 202: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

198: If p_record.order_source_id = 20 Then
199: OE_Acknowledgment_Pub.Is_Delivery_Required
200: (
201: p_customer_id => p_record.sold_to_org_id,
202: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
203: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
204: x_party_id => l_party_id,
205: x_party_site_id => l_party_site_id,
206: x_is_delivery_required => l_is_delivery_reqd,

Line 203: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

199: OE_Acknowledgment_Pub.Is_Delivery_Required
200: (
201: p_customer_id => p_record.sold_to_org_id,
202: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
203: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
204: x_party_id => l_party_id,
205: x_party_site_id => l_party_site_id,
206: x_is_delivery_required => l_is_delivery_reqd,
207: x_return_status => l_return_status

Line 222: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

218: p_entity_id => p_record.header_id,
219: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
220: p_requesting_entity_id => p_record.header_id,
221: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
222: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
223: p_param1 => p_record.header_id,
224: p_param2 => p_record.order_source_id,
225: p_param3 => p_record.orig_sys_document_ref,
226: p_param4 => p_record.sold_to_org_id,

Line 229: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

225: p_param3 => p_record.orig_sys_document_ref,
226: p_param4 => p_record.sold_to_org_id,
227: p_param5 => Null,
228: p_param6 => p_record.org_id,
229: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
230: p_param8 => Null,
231: p_param9 => p_record.sold_to_org_id,
232: p_param10 => l_party_site_id,
233: p_param11 => Null,

Line 243: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

239: p_entity_id => p_record.line_id,
240: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
241: p_requesting_entity_id => p_record.line_id,
242: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
243: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
244: p_param1 => p_record.header_id,
245: p_param2 => 20,
246: p_param3 => p_record.orig_sys_document_ref,
247: p_param4 => p_record.sold_to_org_id,

Line 250: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

246: p_param3 => p_record.orig_sys_document_ref,
247: p_param4 => p_record.sold_to_org_id,
248: p_param5 => Null,
249: p_param6 => p_record.org_id,
250: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
251: p_param8 => Null,
252: p_param9 => p_record.sold_to_org_id,
253: p_param10 => l_party_site_id,
254: x_return_status => l_return_status);

Line 308: OE_Acknowledgment_Pub.Is_Delivery_Required

304: End If;
305: End If;
306:
307: If p_record.order_source_id = 20 Then
308: OE_Acknowledgment_Pub.Is_Delivery_Required
309: (
310: p_customer_id => p_record.sold_to_org_id,
311: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
312: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

Line 311: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

307: If p_record.order_source_id = 20 Then
308: OE_Acknowledgment_Pub.Is_Delivery_Required
309: (
310: p_customer_id => p_record.sold_to_org_id,
311: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
312: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
313: x_party_id => l_party_id,
314: x_party_site_id => l_party_site_id,
315: x_is_delivery_required => l_is_delivery_reqd,

Line 312: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

308: OE_Acknowledgment_Pub.Is_Delivery_Required
309: (
310: p_customer_id => p_record.sold_to_org_id,
311: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,
312: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,
313: x_party_id => l_party_id,
314: x_party_site_id => l_party_site_id,
315: x_is_delivery_required => l_is_delivery_reqd,
316: x_return_status => l_return_status

Line 331: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

327: p_entity_id => p_record.header_id,
328: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
329: p_requesting_entity_id => p_record.header_id,
330: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_HDR,
331: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
332: p_param1 => p_record.header_id,
333: p_param2 => p_record.order_source_id,
334: p_param3 => p_record.orig_sys_document_ref,
335: p_param4 => p_record.sold_to_org_id,

Line 338: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

334: p_param3 => p_record.orig_sys_document_ref,
335: p_param4 => p_record.sold_to_org_id,
336: p_param5 => Null,
337: p_param6 => p_record.org_id,
338: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
339: p_param8 => Null,
340: p_param9 => p_record.sold_to_org_id,
341: p_param10 => l_party_site_id,
342: p_param11 => Null,

Line 352: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

348: p_entity_id => p_record.line_id,
349: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
350: p_requesting_entity_id => p_record.line_id,
351: p_request_type => OE_GLOBALS.G_GENERATE_XML_REQ_LN,
352: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
353: p_param1 => p_record.header_id,
354: p_param2 => 20,
355: p_param3 => p_record.orig_sys_document_ref,
356: p_param4 => p_record.sold_to_org_id,

Line 359: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

355: p_param3 => p_record.orig_sys_document_ref,
356: p_param4 => p_record.sold_to_org_id,
357: p_param5 => Null,
358: p_param6 => p_record.org_id,
359: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,
360: p_param8 => Null,
361: p_param9 => p_record.sold_to_org_id,
362: p_param10 => l_party_site_id,
363: x_return_status => l_return_status);