APPS.INV_RESERVATION_VALIDATE_PVT dependencies on OE_DS_PVT

Line 1626: debug_print('In validate_demand_source_so: oe_ds_pvt.g_ds_soissue_flag = ' || OE_DS_PVT.G_DS_SOISSUE_FLAG );

1622: l_debug := g_debug;
1623:
1624: IF (l_debug = 1) THEN
1625: debug_print('In validate_demand_source_so: demand_source_type_id = ' || p_demand_source_type_id);
1626: debug_print('In validate_demand_source_so: oe_ds_pvt.g_ds_soissue_flag = ' || OE_DS_PVT.G_DS_SOISSUE_FLAG );
1627: END IF;
1628:
1629: IF (p_demand_source_type_id = INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE and OE_DS_PVT.G_DS_SOISSUE_FLAG <> 'Y') THEN
1630: select count(1)

Line 1629: IF (p_demand_source_type_id = INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE and OE_DS_PVT.G_DS_SOISSUE_FLAG <> 'Y') THEN

1625: debug_print('In validate_demand_source_so: demand_source_type_id = ' || p_demand_source_type_id);
1626: debug_print('In validate_demand_source_so: oe_ds_pvt.g_ds_soissue_flag = ' || OE_DS_PVT.G_DS_SOISSUE_FLAG );
1627: END IF;
1628:
1629: IF (p_demand_source_type_id = INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE and OE_DS_PVT.G_DS_SOISSUE_FLAG <> 'Y') THEN
1630: select count(1)
1631: into l_dropship_count
1632: from oe_drop_ship_sources
1633: where header_id = p_demand_source_header_id

Line 3396: debug_print ('Inside validate sales order :oe_ds_pvt.g_ds_soissue_flag ' || OE_DS_PVT.G_DS_SOISSUE_FLAG);

3392: -- bugfix 16104833 --added the check for Drop Ship
3393: --
3394: IF l_debug = 1 THEN
3395: debug_print ('Inside validate sales order :l_source_type_code ' || l_source_type_code);
3396: debug_print ('Inside validate sales order :oe_ds_pvt.g_ds_soissue_flag ' || OE_DS_PVT.G_DS_SOISSUE_FLAG);
3397: END IF;
3398: --
3399: -- Validate 5 -- if the demand type is sales order, call validate_demand_source_so
3400: -- to see if the sales order is dropship order.

Line 3401: IF (p_demand_type_id = inv_reservation_global.g_source_type_oe and NVL(l_source_type_code, 'INTERNAL') = 'EXTERNAL' and OE_DS_PVT.G_DS_SOISSUE_FLAG <> 'Y') THEN

3397: END IF;
3398: --
3399: -- Validate 5 -- if the demand type is sales order, call validate_demand_source_so
3400: -- to see if the sales order is dropship order.
3401: IF (p_demand_type_id = inv_reservation_global.g_source_type_oe and NVL(l_source_type_code, 'INTERNAL') = 'EXTERNAL' and OE_DS_PVT.G_DS_SOISSUE_FLAG <> 'Y') THEN
3402: validate_demand_source_so
3403: ( x_return_status => l_return_status
3404: , p_demand_source_type_id => p_demand_type_id
3405: , p_demand_source_header_id => l_order_header_id