DBA Data[Home] [Help]

APPS.OE_LINE_SECURITY dependencies on OE_ACKNOWLEDGMENT_PUB

Line 131: OE_Acknowledgment_Pub.Is_Delivery_Required

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

Line 134: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

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

Line 135: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

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

Line 155: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 162: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 176: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 183: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 201: OE_Acknowledgment_Pub.Is_Delivery_Required

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

Line 204: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

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

Line 205: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

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

Line 224: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 231: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 245: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 252: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 310: OE_Acknowledgment_Pub.Is_Delivery_Required

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

Line 313: p_transaction_type => OE_Acknowledgment_Pub.G_TRANSACTION_TYPE,

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

Line 314: p_transaction_subtype => OE_Acknowledgment_Pub.G_TRANSACTION_SSO,

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

Line 333: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 340: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 354: p_request_unique_key1 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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

Line 361: p_param7 => OE_ACKNOWLEDGMENT_PUB.G_TRANSACTION_SSO,

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