APPS.INV_PICK_RELEASE_PUB dependencies on INV_SALESORDER

Line 574: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(mmtt_line.oe_header_id);

570: RAISE fnd_api.g_exc_unexpected_error;
571: END IF;
572:
573: END IF ;
574: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(mmtt_line.oe_header_id);
575: -- Assign the pick slip number to the record in MTL_MATERIAL_TRANSACTIONS_TEMP
576: UPDATE mtl_material_transactions_temp
577: SET pick_slip_number = l_pick_slip_number
578: , transaction_source_id = l_mso_header_id

Line 2845: inv_salesorder.get_salesorder_for_oeheader(l_source_header_id)

2841: select count(1) INTO l_reservation_exists
2842: from mtl_reservations mr
2843: WHERE MR.DEMAND_SOURCE_LINE_ID = l_source_line_id
2844: and MR.DEMAND_SOURCE_HEADER_ID =
2845: inv_salesorder.get_salesorder_for_oeheader(l_source_header_id)
2846: and MR.demand_source_type_id = decode(INV_CACHE.wdd_rec.source_document_type_id, 10, 8, 2)
2847: and MR.SUBINVENTORY_CODE IS NOT NULL --locator is not needed
2848: and (nvl(mr.staged_flag,'N') = 'N' and nvl(mr.detailed_quantity,0) = 0);
2849:

Line 3689: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);

3685:
3686: -- First attempt to convert the demand source header id given
3687: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.
3688: /*l_mso_header_id :=
3689: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);
3690: IF l_mso_header_id IS NULL THEN
3691: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
3692: FND_MSG_PUB.Add;
3693: RAISE fnd_api.g_exc_unexpected_error;

Line 4136: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);

4132:
4133: -- First attempt to convert the demand source header id given
4134: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.
4135: /*l_mso_header_id :=
4136: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);
4137: IF l_mso_header_id IS NULL THEN
4138: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
4139: FND_MSG_PUB.Add;
4140: RAISE fnd_api.g_exc_unexpected_error;