APPS.OE_SYNC_ORDER_PVT dependencies on OE_LINE_ACKS

Line 301: INSERT INTO oe_line_acks

297: );
298: END IF;
299:
300:
301: INSERT INTO oe_line_acks
302: (header_id
303: ,line_id
304: ,acknowledgment_type
305: ,last_ack_code

Line 506: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');

502: IF (p_line_rec.line_id IS NOT NULL AND
503: p_header_rec.booked_flag = 'Y') THEN
504:
505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');
507: END IF;
508:
509: select OE_XML_MESSAGE_SEQ_S.nextval
510: into l_itemkey

Line 519: oe_debug_pub.add('sync_header_line -APPLY- Inserting into oe_line_acks for p_line_id is DONE'||l_return_status);

515: p_req_id => l_itemkey, -- XXXX
516: X_RETURN_STATUS => L_RETURN_STATUS);
517:
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add('sync_header_line -APPLY- Inserting into oe_line_acks for p_line_id is DONE'||l_return_status);
520: END IF;
521:
522: IF p_header_rec.header_id IS NOT NULL THEN
523: IF l_debug_level > 0 THEN

Line 942: FROM oe_line_acks

938: INVOICE_TO_CUSTOMER_ID, INVOICE_TO_CONTACT_ID, INVOICE_TO_ORG_ID,
939: UNIT_SELLING_PRICE, PRICE_LIST_ID, UNIT_LIST_PRICE,
940: UNIT_LIST_PRICE_PER_PQTY, UNIT_PERCENT_BASE_PRICE,
941: UNIT_SELLING_PRICE_PER_PQTY, PRICING_DATE, SHIP_TO_ADDRESS_ID
942: FROM oe_line_acks
943: WHERE request_id = p_lin_req_id;
944:
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946: