APPS.OE_SYNC_ORDER_PVT dependencies on OE_LINE_ACKS

Line 347: INSERT INTO oe_line_acks

343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'Inserting into line acks.', 5);
345: END IF;
346:
347: INSERT INTO oe_line_acks
348: (header_id
349: ,line_id
350: ,acknowledgment_type
351: ,last_ack_code

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

608: oe_genesis_util.source_aia_enabled(p_header_rec.order_source_id) -- 10236368
609: ) THEN
610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');
613: END IF;
614:
615: select OE_XML_MESSAGE_SEQ_S.nextval
616: into l_itemkey

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

621: p_req_id => l_itemkey, -- XXXX
622: X_RETURN_STATUS => L_RETURN_STATUS);
623:
624: IF l_debug_level > 0 THEN
625: oe_debug_pub.add('sync_header_line -APPLY- Inserting into oe_line_acks for p_line_id is DONE'||l_return_status);
626: END IF;
627:
628: IF p_header_rec.header_id IS NOT NULL THEN
629: IF l_debug_level > 0 THEN

Line 1096: FROM oe_line_acks

1092: UNIT_SELLING_PRICE_PER_PQTY, PRICING_DATE, SHIP_TO_ADDRESS_ID,
1093: SHIP_FROM_ORG, SHIP_TO_ORG, INVOICE_TO_ORG,
1094: ITEM_TYPE_CODE, -- 9131629
1095: LINE_CATEGORY_CODE -- 9151484
1096: FROM oe_line_acks
1097: WHERE request_id = p_lin_req_id;
1098:
1099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1100: