APPS.OE_SYNC_ORDER_PVT dependencies on OE_HEADER_ACKS

Line 170: INSERT INTO oe_header_acks

166: );
167:
168: END IF;
169:
170: INSERT INTO oe_header_acks
171: (header_id
172: ,acknowledgment_type
173: ,last_ack_code
174: ,request_id

Line 661: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');

657: -- p_header_rec.booked_flag = 'Y' AND bug 16041842
658: oe_genesis_util.source_aia_enabled(p_header_rec.order_source_id) THEN -- 10236368
659:
660: IF l_debug_level > 0 THEN
661: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');
662: END IF;
663: select OE_XML_MESSAGE_SEQ_S.nextval
664: into l_itemkey
665: from dual;

Line 673: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');

669: p_req_id => l_itemkey, --XXXX
670: x_return_status => l_return_status);
671:
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');
674: END IF;
675:
676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');

Line 703: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for p_hold_source_id');

699: -- is sensitive to the order header being AIA enabled or not.
700: ----
701:
702: IF l_debug_level > 0 THEN
703: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for p_hold_source_id');
704: END IF;
705:
706:
707: FOR hdr_rec IN get_hdr_for_hldsrc_cur

Line 731: INSERT INTO oe_header_acks

727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('sync_header_line - l_itemkey '|| l_itemkey);
729: END IF;
730:
731: INSERT INTO oe_header_acks
732: (header_id
733: ,acknowledgment_type
734: ,last_ack_code
735: ,request_id

Line 778: INSERT INTO oe_header_acks

774: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
775: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
776: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
777: END IF;
778: INSERT INTO oe_header_acks
779: (header_id
780: ,acknowledgment_type
781: ,last_ack_code
782: ,request_id

Line 871: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for p_hold_source_id is DONE');

867:
868: END LOOP;
869:
870: IF l_debug_level > 0 THEN
871: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for p_hold_source_id is DONE');
872: END IF;
873: END IF;
874: END IF;
875:

Line 1069: FROM oe_header_acks ack,

1065: ack.CHANGE_SEQUENCE ,ack.SOLD_TO_ORG_ID ,ack.ORDER_SOURCE_ID,
1066: ack.REQUEST_ID ,ack.ACKNOWLEDGMENT_TYPE ,ack.FLOW_STATUS_CODE,
1067: ack.INVOICE_ADDRESS_ID, ack.PRICE_LIST_ID,
1068: ack.TRANSACTIONAL_CURR_CODE --Bug 9182921
1069: FROM oe_header_acks ack,
1070: oe_order_headers_all hdr -- Bug 10009062 Fix
1071: WHERE ack.request_id = p_hdr_req_id
1072: AND hdr.header_id = ack.header_id;
1073: