APPS.OE_HOLDS_PVT dependencies on OE_SYNC_ORDER_PVT

Line 2121: oe_debug_pub.add('.... Calling oe_sync_order_pvt.sync_header_line...');

2117: end if;
2118: end if;
2119:
2120: if (l_debug_level > 0 ) then
2121: oe_debug_pub.add('.... Calling oe_sync_order_pvt.sync_header_line...');
2122: end if;
2123:
2124: -- XXXX Do we need to generate req_id here
2125: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec -- NULL

Line 2125: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec -- NULL

2121: oe_debug_pub.add('.... Calling oe_sync_order_pvt.sync_header_line...');
2122: end if;
2123:
2124: -- XXXX Do we need to generate req_id here
2125: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE( p_header_rec => l_header_rec -- NULL
2126: ,p_line_rec => l_line_rec -- NULL
2127: ,p_hold_source_id => NULL
2128: ,p_order_hold_id => l_order_hold_id
2129: ,p_change_type => 'RELEASE');

Line 5169: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec

5165: );
5166: END IF;
5167:
5168: -- XXXX Do we need to generate req_id here
5169: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
5170: ,p_line_rec => l_line_rec
5171: ,p_hold_source_id => p_hold_source_rec.hold_source_id
5172: ,p_change_type => 'APPLY');
5173: ELSE --p_hold_source_rec.hold_entity_code = 'O'

Line 5191: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec

5187: );
5188: END IF;
5189: -- IF(p_hold_source_rec.header_id IS NOT NULL OR p_hold_source_rec.line_id IS NOT NULL) THEN
5190: -- XXXX Do we need to generate req_id here
5191: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
5192: ,p_line_rec => l_line_rec
5193: ,p_hold_source_id => p_hold_source_rec.hold_source_id
5194: ,p_change_type => 'APPLY');
5195: -- END IF; Bug 6791576

Line 5383: oe_debug_pub.add('.... Calling oe_sync_order_pvt.sync_header_line...');

5379: end if;
5380: end if;
5381:
5382: if (l_debug_level > 0 ) then
5383: oe_debug_pub.add('.... Calling oe_sync_order_pvt.sync_header_line...');
5384: end if;
5385:
5386: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec -- NULL
5387: ,p_line_rec => l_line_rec -- NULL

Line 5386: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec -- NULL

5382: if (l_debug_level > 0 ) then
5383: oe_debug_pub.add('.... Calling oe_sync_order_pvt.sync_header_line...');
5384: end if;
5385:
5386: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec -- NULL
5387: ,p_line_rec => l_line_rec -- NULL
5388: ,p_hold_source_id => p_hold_release_rec.hold_source_id
5389: ,p_change_type => 'RELEASE'
5390: ,p_hold_release_id => p_hold_release_rec.hold_release_id);

Line 5393: oe_debug_pub.add('.... Returned from oe_sync_order_pvt.sync_header_line...');

5389: ,p_change_type => 'RELEASE'
5390: ,p_hold_release_id => p_hold_release_rec.hold_release_id);
5391:
5392: if (l_debug_level > 0 ) then
5393: oe_debug_pub.add('.... Returned from oe_sync_order_pvt.sync_header_line...');
5394: end if;
5395: END IF;
5396: -- GENESIS --
5397: END Release_Order_holds;

Line 15092: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec

15088: );
15089: END IF;
15090:
15091: -- XXXX Do we need to generate req_id here
15092: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
15093: ,p_line_rec => l_line_rec
15094: ,p_hold_source_id => p_hold_source_rec.hold_source_id
15095: ,p_order_hold_id => p_hold_source_rec.hold_id -- Bug 14494236
15096: ,p_change_type => 'APPLY');

Line 15116: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec

15112: );
15113: END IF;
15114:
15115: -- XXXX Do we need to generate req_id here
15116: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(p_header_rec => l_header_rec
15117: ,p_line_rec => l_line_rec
15118: ,p_hold_source_id => p_hold_source_rec.hold_source_id
15119: ,p_order_hold_id => p_hold_source_rec.hold_id -- Bug 14494236
15120: ,p_change_type => 'APPLY');