DBA Data[Home] [Help]

APPS.INV_RSV_DETAIL_STAGE_PVT dependencies on INV_RESERVATION_PUB

Line 741: inv_reservation_pub.query_reservation(

737:
738: --l_query_input.ship_ready_flag := NULL;
739: --l_query_input.staged_flag := NULL;
740:
741: inv_reservation_pub.query_reservation(
742: p_api_version_number => 1.0
743: , p_init_msg_lst => fnd_api.g_true
744: , x_return_status => l_return_status
745: , x_msg_count => l_msg_count

Line 907: inv_reservation_pub.delete_reservation

903: IF (l_debug = 1) THEN
904: debug_print('Deleting reservation - reservation id :'||l_mtl_reservation_non_staged(i).reservation_id);
905: END IF;
906:
907: inv_reservation_pub.delete_reservation
908: ( p_api_version_number => 1.0
909: , p_init_msg_lst => fnd_api.g_false
910: , x_return_status => l_return_status
911: , x_msg_count => l_msg_count

Line 949: inv_reservation_pub.delete_reservation

945: debug_print('l_remaining_reservation_qty >= l_mtl_reservation_non_staged(i).primary_reservation_quantity');
946: debug_print('Deleting reservation - reservation id :' || l_mtl_reservation_non_staged(i).reservation_id);
947: END IF;
948:
949: inv_reservation_pub.delete_reservation
950: ( p_api_version_number => 1.0
951: , p_init_msg_lst => fnd_api.g_false
952: , x_return_status => l_return_status
953: , x_msg_count => l_msg_count

Line 1005: inv_reservation_pub.update_reservation(

1001: END IF;
1002:
1003: -- This update will always reduce the primary qty.
1004: -- Unmarking of the serial in case of serial controlled items is handled by the api
1005: inv_reservation_pub.update_reservation(
1006: p_api_version_number => 1.0
1007: , p_init_msg_lst => fnd_api.g_false
1008: , x_return_status => l_return_status
1009: , x_msg_count => l_msg_count

Line 1125: inv_reservation_pub.create_reservation(

1121: IF (l_debug = 1) THEN
1122: debug_print('Calling create resrevation for creating the detailed reservation ');
1123: END IF;
1124:
1125: inv_reservation_pub.create_reservation(
1126: p_api_version_number => 1.0
1127: , p_init_msg_lst => fnd_api.g_false
1128: , x_return_status => l_return_status
1129: , x_msg_count => l_msg_count

Line 1162: inv_reservation_pub.query_reservation(

1158: IF (l_debug = 1) THEN
1159: debug_print('Querying reservation before updating the detailed qty ');
1160: END IF;
1161: -- Query for the one reservation created for updating the det qty
1162: inv_reservation_pub.query_reservation(
1163: p_api_version_number => 1.0
1164: , p_init_msg_lst => fnd_api.g_true
1165: , x_return_status => l_return_status
1166: , x_msg_count => l_msg_count

Line 1193: inv_reservation_pub.update_reservation(

1189: debug_print('Updating the detailed qty and sec detailed qty fields ');
1190: END IF;
1191:
1192: --This update is meant only to update the det qty and sec det qty
1193: inv_reservation_pub.update_reservation(
1194: p_api_version_number => 1.0
1195: , p_init_msg_lst => fnd_api.g_false
1196: , x_return_status => l_return_status
1197: , x_msg_count => l_msg_count

Line 1240: inv_reservation_pub.query_reservation(

1236: IF (l_debug = 1) THEN
1237: debug_print('Querying reservation before staging ');
1238: END IF;
1239: -- Query for the one detailed reservation created
1240: inv_reservation_pub.query_reservation(
1241: p_api_version_number => 1.0
1242: , p_init_msg_lst => fnd_api.g_true
1243: , x_return_status => l_return_status
1244: , x_msg_count => l_msg_count

Line 1272: inv_reservation_pub.update_reservation(

1268: IF (l_debug = 1) THEN
1269: debug_print('Updating the staging fields ');
1270: END IF;
1271:
1272: inv_reservation_pub.update_reservation(
1273: p_api_version_number => 1.0
1274: , p_init_msg_lst => fnd_api.g_false
1275: , x_return_status => l_return_status
1276: , x_msg_count => l_msg_count