APPS.WIP_SO_RESERVATIONS dependencies on MTL_RESERVATIONS

Line 61: -- tell API to lock rows in mtl_reservations.

57: l_reservation_rec.supply_source_type_id :=
58: inv_reservation_global.g_source_type_wip;
59:
60: -- query reservations against this particular WIP job.
61: -- tell API to lock rows in mtl_reservations.
62: -- records are returned based on requirement date ascending.
63:
64: l_reservation_rec.lpn_id:= null ; /* Fix for Bug#4575108 */
65:

Line 250: -- mtl_reservations

246: RAISE fnd_api.g_exc_unexpected_error;
247: END IF;
248:
249: -- form line has sales order specified, but not found in
250: -- mtl_reservations
251: ELSE
252: /* ER 4163405: Replacing message WIP_SALES_ORDER_INCONSISTENCY with
253: the new message WIP_NO_SUPPLY_RESERVATIONS */
254: fnd_message.set_name('WIP', 'WIP_NO_SUPPLY_RESERVATIONS');

Line 495: -- tell API to lock rows in mtl_reservations.

491: --l_reservation_rec.demand_source_type_id := inv_reservation_global.g_source_type_oe;
492: l_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv; -- not wip
493:
494: -- query reservations for a particular inventory item
495: -- tell API to lock rows in mtl_reservations.
496: -- records are returned based on requirement date ascending.
497: inv_reservation_pub.query_reservation(
498: p_api_version_number => 1.0,
499: p_init_msg_lst => fnd_api.g_false,

Line 606: -- mtl_reservations

602: ELSE
603: RAISE fnd_api.g_exc_unexpected_error;
604: END IF;
605: -- form line has sales order specified, but not found in
606: -- mtl_reservations
607: END IF; -- reservation found for this return
608: END LOOP; -- loop through each return form line
609:
610:

Line 2060: from mtl_reservations

2056: if (p_type = 'FIRST') then
2057: -- test if this is the first reservation
2058: -- if yes, then
2059: select count(*) into cnt
2060: from mtl_reservations
2061: where demand_source_line_id = p_order_line_id;
2062:
2063: if (cnt = 1) then
2064: CTO_WIP_WORKFLOW_API_PK.first_wo_reservation_created(

Line 2074: from mtl_reservations

2070: elsif (p_type = 'LAST') then
2071: -- test if this is the last reservation
2072: -- if yes then
2073: select count(*) into cnt
2074: from mtl_reservations
2075: where demand_source_line_id = p_order_line_id;
2076:
2077: if (cnt = 0) then
2078: CTO_WIP_WORKFLOW_API_PK.last_wo_reservation_deleted(

Line 2546: -- tell API to lock rows in mtl_reservations.

2542: l_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
2543:
2544:
2545: -- query reservations against this particular WIP job.
2546: -- tell API to lock rows in mtl_reservations.
2547: -- records are returned based on requirement date ascending.
2548: inv_reservation_pub.query_reservation(
2549: p_api_version_number => 1.0,
2550: p_init_msg_lst => fnd_api.g_false,