DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on MTL_SALES_ORDERS

Line 3625: -- MTL_SALES_ORDERS that corresponds to the OE

3621: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3622: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
3623: -- to or updated
3624: l_mso_header_id NUMBER; -- The header ID for the record in
3625: -- MTL_SALES_ORDERS that corresponds to the OE
3626: -- header and line passed in.
3627: l_api_return_status VARCHAR2(1);
3628: -- The return status of APIs called
3629: -- within this API.

Line 3687: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.

3683: RAISE fnd_api.g_exc_unexpected_error;
3684: END IF;
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');

Line 4072: -- MTL_SALES_ORDERS that corresponds to the OE

4068: l_dummy_sn INV_Reservation_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
4069: l_new_rsv_id NUMBER; -- The reservation ID that has been transferred
4070: -- to or updated
4071: l_mso_header_id NUMBER; -- The header ID for the record in
4072: -- MTL_SALES_ORDERS that corresponds to the OE
4073: -- header and line passed in.
4074: l_api_return_status VARCHAR2(1);
4075: -- The return status of APIs called
4076: -- within this API.

Line 4134: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.

4130: RAISE fnd_api.g_exc_unexpected_error;
4131: END IF;
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');