APPS.OE_SYNC_ORDER_PVT dependencies on OE_HEADER_ACKS

Line 145: INSERT INTO oe_header_acks

141: x_party_site_id => l_bill_to_party_site_id
142: );
143: END IF;
144:
145: INSERT INTO oe_header_acks
146: (header_id
147: ,acknowledgment_type
148: ,last_ack_code
149: ,request_id

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

550: p_header_rec.header_id IS NOT NULL AND
551: p_header_rec.booked_flag = 'Y' THEN
552:
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');
555: END IF;
556: select OE_XML_MESSAGE_SEQ_S.nextval
557: into l_itemkey
558: from dual;

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

562: p_req_id => l_itemkey, --XXXX
563: x_return_status => l_return_status);
564:
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');
567: END IF;
568:
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');

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

584: p_header_rec.header_id IS NULL AND
585: p_hold_source_id IS NOT NULL THEN
586:
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for p_hold_source_id');
589: END IF;
590:
591:
592: FOR hdr_rec IN get_hdr_for_hldsrc_cur

Line 616: INSERT INTO oe_header_acks

612: IF l_debug_level > 0 THEN
613: oe_debug_pub.add('sync_header_line - l_itemkey '|| l_itemkey);
614: END IF;
615:
616: INSERT INTO oe_header_acks
617: (header_id
618: ,acknowledgment_type
619: ,last_ack_code
620: ,request_id

Line 663: INSERT INTO oe_header_acks

659: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
660: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
661: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
662: END IF;
663: INSERT INTO oe_header_acks
664: (header_id
665: ,acknowledgment_type
666: ,last_ack_code
667: ,request_id

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

747:
748: END LOOP;
749:
750: IF l_debug_level > 0 THEN
751: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for p_hold_source_id is DONE');
752: END IF;
753: END IF;
754: END IF;
755:

Line 920: FROM oe_header_acks

916: ORDERED_DATE ,ORG_ID ,CHANGE_DATE,
917: CHANGE_SEQUENCE ,SOLD_TO_ORG_ID ,ORDER_SOURCE_ID,
918: REQUEST_ID ,ACKNOWLEDGMENT_TYPE ,FLOW_STATUS_CODE,
919: INVOICE_ADDRESS_ID, PRICE_LIST_ID
920: FROM oe_header_acks
921: WHERE request_id = p_hdr_req_id;
922:
923: -- Cursor modified for Enh. 7244277, 7644412, 7644426
924: CURSOR get_line_req_cur IS