DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on INV_RESERVATION_PUB

Line 66: inv_reservation_pub.query_reservation(

62: -- records are returned based on requirement date ascending.
63:
64: l_reservation_rec.lpn_id:= null ; /* Fix for Bug#4575108 */
65:
66: inv_reservation_pub.query_reservation(
67: p_api_version_number => 1.0,
68: p_init_msg_lst => fnd_api.g_false,
69: x_return_status => l_return_status,
70: x_msg_count => l_msg_count,

Line 160: inv_reservation_pub.query_reservation(

156:
157: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
158: IF (l_reservation_found) THEN
159: IF (l_query_reservation = 'Y') THEN
160: inv_reservation_pub.query_reservation(
161: p_api_version_number => 1.0,
162: p_init_msg_lst => fnd_api.g_false,
163: x_return_status => l_return_status,
164: x_msg_count => l_msg_count,

Line 497: inv_reservation_pub.query_reservation(

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,
500: x_return_status => l_return_status,
501: x_msg_count => l_msg_count,

Line 976: inv_reservation_pub.create_reservation(p_api_version_number => 1.0,

972: wip_logger.log('loc' || l_reservation_rec.locator_id, l_return_status);
973: wip_logger.log('qty' || l_reservation_rec.primary_reservation_quantity, l_return_status);
974: wip_logger.log('lpn' || l_reservation_rec.lpn_id, l_return_status);
975: end if;
976: inv_reservation_pub.create_reservation(p_api_version_number => 1.0,
977: p_init_msg_lst => fnd_api.g_false,
978: x_return_status => l_return_status,
979: x_msg_count => l_msg_count,
980: x_msg_data => l_msg_data,

Line 1826: INV_Reservation_PUB.Update_Reservation

1822: l_reservation_rec.ship_ready_flag := NULL;
1823:
1824: if ( p_reservation_rec.primary_reservation_quantity >0 ) then
1825:
1826: INV_Reservation_PUB.Update_Reservation
1827: (
1828: p_api_version_number => 1.0
1829: , p_init_msg_lst => fnd_api.g_false
1830: , x_return_status => l_api_return_status

Line 1846: inv_reservation_pub.create_reservation(

1842: RAISE fnd_api.g_exc_unexpected_error;
1843: END IF ;
1844: else
1845:
1846: inv_reservation_pub.create_reservation(
1847: p_api_version_number => 1.0,
1848: p_init_msg_lst => fnd_api.g_false,
1849: x_return_status => l_return_status,
1850: x_msg_count => l_msg_count,

Line 1994: inv_reservation_pub.transfer_reservation(

1990: ELSE
1991: l_to_reservation_rec.primary_reservation_quantity := l_quantity;
1992: END IF;
1993:
1994: inv_reservation_pub.transfer_reservation(
1995: p_api_version_number => 1.0,
1996: p_init_msg_lst => fnd_api.g_false,
1997: x_return_status => l_return_status,
1998: x_msg_count => l_msg_count,

Line 2548: inv_reservation_pub.query_reservation(

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,
2551: x_return_status => l_return_status,
2552: x_msg_count => l_msg_count,

Line 2578: inv_reservation_pub.delete_reservation(

2574: -- dbms_output.put_line ('l_line_reservation_quantity :'|| l_line_reservation_quantity );
2575: If ( l_quantity_to_be_relieved >= l_line_reservation_quantity ) then
2576: --delete the reservation
2577: -- dbms_output.put_line ('about to delete the reservation');
2578: inv_reservation_pub.delete_reservation(
2579: p_api_version_number => 1.0,
2580: p_init_msg_lst => fnd_api.g_false,
2581: x_return_status => l_return_status,
2582: x_msg_count => l_msg_count,

Line 2601: inv_reservation_pub.update_reservation(

2597: l_quantity_to_be_relieved := 0;
2598: -- update the reservation
2599: l_to_reservation_rec := l_reservation_tbl(j);
2600: l_to_reservation_rec.primary_reservation_quantity := l_new_line_rsv_quantity;
2601: inv_reservation_pub.update_reservation(
2602: p_api_version_number => 1.0,
2603: p_init_msg_lst => fnd_api.g_false,
2604: x_return_status => l_return_status,
2605: x_msg_count => l_msg_count,