1713: IF l_debug_level > 0 THEN
1714: oe_debug_pub.add( 'OE_HOLDS_PVT - RELEASE ORDERS- BEFORE SYNC_HEADER_LINE');
1715: END IF;
1716: -- XXXX Do we need to generate req_id here
1717: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => NULL
1718: ,p_line_rec => NULL
1719: ,p_hold_source_id => NULL
1720: ,p_order_hold_id => l_order_hold_id
1721: ,p_change_type => 'RELEASE');
4710: );
4711: END IF;
4712:
4713: -- XXXX Do we need to generate req_id here
4714: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
4715: ,p_line_rec => l_line_rec
4716: ,p_hold_source_id => p_hold_source_rec.hold_source_id
4717: ,p_change_type => 'APPLY');
4718: ELSE --p_hold_source_rec.hold_entity_code = 'O'
4732: );
4733: END IF;
4734: -- IF(p_hold_source_rec.header_id IS NOT NULL OR p_hold_source_rec.line_id IS NOT NULL) THEN
4735: -- XXXX Do we need to generate req_id here
4736: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
4737: ,p_line_rec => l_line_rec
4738: ,p_hold_source_id => p_hold_source_rec.hold_source_id
4739: ,p_change_type => 'APPLY');
4740: -- END IF; Bug 6791576
4831: oe_debug_pub.add( 'OE_HOLDS_PVT - hold_source _id '|| p_hold_release_rec.hold_source_id);
4832: oe_debug_pub.add( 'OE_HOLDS_PVT - hold_release_id' ||p_hold_release_rec.hold_release_id);
4833: END IF;
4834: -- XXXX Do we need to generate req_id here
4835: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => NULL
4836: ,p_line_rec => NULL
4837: ,p_hold_source_id => p_hold_release_rec.hold_source_id
4838: ,p_change_type => 'RELEASE'
4839: ,p_hold_release_id => p_hold_release_rec.hold_release_id);
13443: );
13444: END IF;
13445:
13446: -- XXXX Do we need to generate req_id here
13447: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
13448: ,p_line_rec => l_line_rec
13449: ,p_hold_source_id => p_hold_source_rec.hold_source_id
13450: ,p_change_type => 'APPLY');
13451:
13466: );
13467: END IF;
13468:
13469: -- XXXX Do we need to generate req_id here
13470: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
13471: ,p_line_rec => l_line_rec
13472: ,p_hold_source_id => p_hold_source_rec.hold_source_id
13473: ,p_change_type => 'APPLY');
13474: END IF; --p_hold_source_rec.hold_entity_code = 'O'